Search results

Are you using alot of text in the field description area in design mode? I am having the same problem, and found I could add a word to a description for one field at a time up to a certain number of fields, then get that error. We put alot of detail into those descriptions, so I wonder if...

Pat - Thanks for reminding us to use the BeforeUpdate event of the form, that makes the most sense vs. the fields. As far as using a default, as I mentioned in an earlier post, we have found that if someone is entering data, and gets sidetracked by a call or whatever, if fields are defaulted...

We take the Access data tables, convert the files to comma delimited files, and export them that way. Thank you both for the suggestions, they sound perfect for this situation!

RG - We send this data somewhere where they require us to have all the fields filled in, and if there are any blanks or don't knows or N/A's, they want 888. It can either be done at the time of entry or before I send it, but somehow every month I have to go through all these records and make...

Actually, I have 2 things I want to accomplish. I don't want to use a default in the form, I want to wait until the person has finished entry, because we have found it is too easy to skip over fields that are already filled in. So from here on in, without writing an if statement for every...

I would like to use code to look at each field in my form (they are all textboxes) and if it is blank, fill it with "888". I have read enough to know I should use the NZ function, but can someone tell me how it should be written to look through every textbox on the form?

Thanks, but can't email any databases in any form from here. Will go thru what you recommended though, I'm not really satisfied with the outcome as yet either.

Got it, not pretty but it works. Put a close and open macro on the main form, and then used the requery and it works. Thanks.

Tried that, no change. Any other suggestions?

In Access 97, I have a tab control with a subform on it. You enter demographics info, then jump over to the subgform (on the same tab page) and enter more specific info about that person. The parent child relationship is set up correctly. I have a drop-down list for the person to choose the...

I have no form to use the code in, just a table with raw data

I have tried various suggestions posted, but still can't seem to get the result I need. I have a field I have to import to a database, SS (Social Security Number). In the database I am exporting from, it is text and does not use leading zeros. In the database I am importing into, it must have...

I am putting a validation rule in my table that is In (0,1,2,3,888) or is null, with the field size as long integer. This is changed from In (0,1,2,3) or is null, which works fine. I keep getting the message Property size is too large (error 3309). Can anyone help?

I have a macro that runs behind a button on a form. When you click the button, the first thing that happens is a table containing only begin and end date is opened, what is entered in two textboxes on the form is entered, and the table is closed. Then a bunch of queries run that are based on...

I have a questionaire with 15 questions like this: DVT Prophy y n n/a Tubes y n n/a Where y=1, n=0, n/a=9. I need a query to use for a report that takes the number of responses that are either 1 or 9 (combined #) and...

Thank you, that was it!

added zip file Adding a zipped file in case anyone can figure this out...

Tried all your suggestions, compact & repair,checked references, new db with copied stuff, mdb.close added, still no luck. If you run the query by itself or a macro though, it works fine, and the code below I am using for a validation routine and it works fine, so I guess I will just use alot...

No error messages. Ran some of the queries by themselves and they updated fine. Made a macro with a few of them and they updated fine. Just don't want to have to do this long macro for all these queries if I can make this work.

Sorry, neither worked?