Search results for query: *

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

ok. any ideas on limiting the length of a textbox on an unbound form. for example I have a textbox which I want to limit to 255 characters. However, if the user exceeds that the data will be truncated. If I put in an input mask then I get an underscore which is a bit of a pain because you...

How do I limit the length data going into a textbox for an unbound form. Am I stuck using a input mask?

I am converting one of my text fields to a memo field and have a couple of questions. 1) I put in an input mask and found that it only allowed 125 characters in it? Should I be able to put in more. 2) Is there a way to eliminate the underscore when using a input mask 3) The field is...

I have a multi-user database that when split runs incredibly slow. However, when all the objects are under one mdb it runs fine. Any ideas.

Jeremy, FYI. I have a multiuser client mdb that resides on a xp home edition. If the user does not log in as a computer administrator when doing a compact and repair the other pc's shortcuts will not work. It may just be a xp home thing?