Search results for query: *

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

Try this first. I still refer to it when create a new database that requires security. http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq%2Easp#_Toc493299660 Nivlac

Paul, Let me check a few things tonight on my database. I may have your solution. It will be long, so I may need to email it to you if that's okay. If you've already figured it out, drop me a quick note at ruchsa@samcstl.org. Otherwise, I'll prepare the steps involved in securing your...

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

If I'm understanding your question correctly, try this--open your fron-end database. Go to Tools, Add-Ins, Linked Table Manager. Choose the tables for which you want to correct the link. Be sure you check the box at the bottom that says, "Always prompt for new location." As the...

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