Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nivlac

    cmmrfrds-Help With CancelUpdate Method

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

    Quit Access WITHOUT Saving Record

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

    Quit Access WITHOUT Saving Record

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

    Quit Access WITHOUT Saving Record

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

    Quit Access WITHOUT Saving Record

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

    URGENT! Menu Bar is Gone!

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

    URGENT! Menu Bar is Gone!

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

    URGENT! Menu Bar is Gone!

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

    URGENT! Menu Bar is Gone!

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

    URGENT! Menu Bar is Gone!

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

    Counting Business Days for Report

    Anybody?!?!?!
  12. nivlac

    Just glad to have found this site.

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

    Who modified a DBO???

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

    Who modified a DBO???

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

    Counting Business Days for Report

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

    Database Security

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

    Can we assign 1 system.mdw file to a DB on a network?

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

    nashman!!!

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

    Info on split database

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

    RE: automatically log people out

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

Part and Inventory Search

Back
Top