I am interested in using the CancelUpdate Method, but am still having trouble understanding the specifics of the code. Referring to thread 181-13622, did you ever get your problem worked out? If so, how? I simply need to have the database ignore any changes made to an open record if the user...
Okay, I've gotten some help with code that kicks out idle users. That part works great. After the designated time, the application tries to quit. However, there are required fields on my data-entry form (always different depending on a series of checkboxes). When the application tries to...
In an effort to protect a database, I managed to remove the menu bar and can't get it back! I went to Tools, Startup...and unchecked the two boxes called "Allow Built-in Toolbars" and "Allow Toolbar/Menu Changes". I hit OK, closed out of the database, went back in, and...
Well, I guess this is my day for questions! I have a secure database that has 13 users. Only the 3 admins have rights to see the objects in design view. However, all 3 of these people were out of the office at a time when 2 of my forms were modified! How can I find out which user modified...
I have read FAQ 181-261 and thread 181-47925 regarding the code used to count business days between 2 dates. But apparently I'm a bit slow, because I still don't get WHERE I need to put this in order for it to work. Any suggestions?
Thanks!
nivlac
Thanks for pointing me to your FAQ on automatically logging people out. However, the code didn't work properly in my application. Could you contact me at ruchsa@samcstl.org or nasushcur@hotmail.com and help me figure out where I went wrong? Thanks!
Nivlac
I have read the thread started by cdbillups on 1/3/02, but am looking for something slightly different. I am using a split database (Access 97) where the front end sits on the shared drive and the back end resides in a shared folder on my personal drive. There are about 20 users. We also have...
How can I make certain text fields required for data-entry ONLY IF a corresponding checkbox is checked on a form. For example, if an employee checks the Add Item box, then the Item Name, Manufacturer, and Catalog Number MUST be filled in. However, if the employee checks the Price Change box...
I'm sure this will be simple, but I'm brain-fried. I have a database set up with user and group level security. Iwould like most users to see a simple data-entry form, while a select few can see the same form with additional controls only visible to them. How can I get Access to look at the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.