Recent content by mrMika

thank you both for your input. The strange thing about this is that the number that is being generated is far from the being the highest. For example if there were 100 records the autonumber might generate 25 or 50 instead of 101. Somehow there seems to be some sort of corruption in the db...

Thanks for the tip. Have you heard of this same problem occuring in Access 2000?

I have a table that uses an autonumber that is indexed and unique. However, when a new record is added the number generated is not unique which then causes an error. Any ideas?

I'm looking into Lotus notes and Domino to use as a CRM and workflow manager. I have never used it and am unfamiliar with it. Any one have any comments or resources that would help me get up to speed?

Figured that one out yet? Are all the users sharing the same front end? Have you tried doing some mods to the mdb and menu bar logged in with user rights?

Perhaps creating a macro with a "Shell" command to open it up might work?

is the runtime located on the computer that you are working on? If so what is the shotcut path to it? If it is not located locally I don't see how it would run but if it is then I'm thinking that it should.

since no one has responded I'll take a shot in the dark. Was the database that you are trying to open created or edited by a user that has rights that are greater than yours?

is the run time MS Access app the one that you are trying to open or are you opening up a different Access database?

right you are. thanks

Jebry, I thought that this would work but it does not. On the change event it does look at the field length that was originally there but the length will not change from the originall. for Example: the field may have had the word "test" in it orignally which has a length of 4. Change this...

I have a unbound form with a textbox that saves to a field that is of the type textbox. The save/update runs off a query . However, when I run the query and there are over 125 characters I get an error message "3001: Invalid Arguement". If i code the query in vba then it runs fine. Is there...

Thanks for the help

Thanks Bob

You can ignore this post. I'm doing this a different way. Thanks