Replies

Hi Gene…

I don’t think Wendell’s around at the moment, so I’ll jump in…
You don’t “create” that capability… It just is… It’s part of Access itself… Put your cursor on almost any field in any table of the database and hit Shift-F2… It’ll Zoom…

Laura…

It sounds like you need some good old fashioned normalization there… I don’t know how far along in the database design you are, but it may be better for you to re-think some of the tables and relationships involved before you end up trying to fix this kind of thing often…

Is it possible for you to attach a sample of your database… Zipped with just the tables, queries and/or form in question with a small amount of dummy data in it? …I’m not sure whether what you want can be done with the way you have it set up… but it’d be easier to tell if I could see something…

Laura…

It sounds like you need some good old fashioned normalization there… I don’t know how far along in the database design you are, but it may be better for you to re-think some of the tables and relationships involved before you end up trying to fix this kind of thing often…

Is it possible for you to attach a sample of your database… Zipped with just the tables, queries and/or form in question with a small amount of dummy data in it? …I’m not sure whether what you want can be done with the way you have it set up… but it’d be easier to tell if I could see something…

Personally I’d suggest you change it to Random rather than an incrementing autonumber…
Actually, I think I read a post earlier today where one of the Woody’s Gurus said that it’s a 1 in a billion chance of getting the same number twice…

HTH

Personally I’d suggest you change it to Random rather than an incrementing autonumber…
Actually, I think I read a post earlier today where one of the Woody’s Gurus said that it’s a 1 in a billion chance of getting the same number twice…

HTH

Hi Laura…

In short… Yes you should…
Not necessarily a number, but a date or something to say this is a new record for the same patient with different employee(s) involved…

I don’t know how you have the db structured and how or what you are adding as details to each reship record, so I can’t really go into further advice… but post back with more details and/or sample data if you need more help…

Hi Laura…

In short… Yes you should…
Not necessarily a number, but a date or something to say this is a new record for the same patient with different employee(s) involved…

I don’t know how you have the db structured and how or what you are adding as details to each reship record, so I can’t really go into further advice… but post back with more details and/or sample data if you need more help…

In Access 2002… 2 gig… See the link below (my question a while back) for more details…
Post 304325

In Access 2002… 2 gig… See the link below (my question a while back) for more details…
Post 304325

It’s not the formula itself… It’s the fact that you know ALL of the formulas!!! LOL

It’s not the formula itself… It’s the fact that you know ALL of the formulas!!! LOL

I knew there’d be an easier way… Leave it to me to re-invent the wheel…
Sorry Hans! I should just wait for you to share your wisdom…

I knew there’d be an easier way… Leave it to me to re-invent the wheel…
Sorry Hans! I should just wait for you to share your wisdom…

There may be an easier way… but I created a little function using DateDiff() that will return a string with the results as you want them…
See the attached example and the code in Module1…

HTH

P.S. There’s no error handling or anything in there… It’s just a quick example…

There may be an easier way… but I created a little function using DateDiff() that will return a string with the results as you want them…
See the attached example and the code in Module1…

HTH

P.S. There’s no error handling or anything in there… It’s just a quick example…