Recent content by nivlac

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...

No luck yet, but I've had another thought. The way it is coded now, after 5 minutes of "idle" time, another form opens telling the user that the app will close in 2 minutes unless they click on the "OK" button. After 2 more minutes, the code runs application.quit. AFTER...

Okay, well, we now know that DoCmd.SetWarnings = False doesn't work in this instance. Even without the warning, the fields in the data-entry form still require data. Now I'm trying to figure out to apply the CancelUpdate function. nivlac

BanditWk - I'm using application.quit TrojanRabbit - I'm going to try setting the warnings to false now. Will let you know what happens. Tell me more about the rollback. How would it affect other users in the db, or would it? nivlac

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...

Dirgesh, That's actually what I'm doing right now. I just thought there might be an easy way to undo what was easily done in 2 seconds. I've always known I could copy my objects to a new db and start over with security. I've just been trying to learn new ways around my mishaps (and learn how...

Jeff, Bear with me. I'm a little confused. I can open a different db and link the tables to my problem db. But all other db objects can only be copied/imported. Therefore, won't I only be enabling the shift key on startup in the new database? I'm not quite sure how to get to the module in...

The CONTROL key didn't work. My AutoExec macro still runs. Anything else? nivlac ruchsa@samcstl.org nasushcur@hotmail.com

Robert, I wish I could do that! I disabled the shift key at startup with a module when I first built the db. Also, many of the options on the normal menu bar have been removed, so I'm quite limited on using that. Any other suggestions? I'm really at a loss on this one. (But I have...

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...

Anybody?!?!?!

I couldn't agree more with everyone. I truly appreciate everything this site has to offer. Just wish I could give back some of the insights that I've received. I have found a wealth of knowledge in you all, and have found a place where the only stupid question is the one not asked. Thanks...

Michael, Thanks for the tips. Apparently the security does NOT protect my db like I expected it to. I'll work on tightening some of the weak spots. The db WAS created using ALL of the recommended steps, including the new workgroup (wouldn't have it any other way around this place!) I still...

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