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

    Making a security password for all users

    Thank you gentlemen!
  2. mlunter

    Making a security password for all users

    I read up a bit on MDW files, and I see the MDW file that is associated with my DB's. What do I have to do to take the group permissions I already made and apply them to everyone who opens the DB? I'm clicking through the security settings and going nuts trying to figure it out. Thank you...
  3. mlunter

    Making a security password for all users

    I used the Access security wizard to set up access permissions for different users. It works fine on my PC - in fact, I have to use the password to login to every Access DB I have to open now. The DB is stored on a server, and many different PCs will have access to it. When other users open...
  4. mlunter

    Code to open form in design view and then back in datasheet view

    I'm sorry, but I am pretty weak with VBA (but improving). This is what I put and it didn't work: -------------------------------------------------- Private Sub Form_Open(Cancel As Integer) docmd.openform frmEditMonthlyForecastDataQueryView, acFormDs, End Sub...
  5. mlunter

    Code to open form in design view and then back in datasheet view

    Hello everyone and thank you for all the useful information, I have a form that is setup to be in datasheet view. I want the information to look just like a query except I am blocking a few things from being edited. I set up the form, and when I link to it from another form it opens it up in...
  6. mlunter

    Requery Module that can't find form

    Hello, I have a form (called "A"), with another subform (called "B") inside of it. There are three listboxes in form A that use queries to lookup values. Form A is unbound. Form B, which is bound to a query, is supposed to take values from form A. I have the default values for the fields on...
  7. mlunter

    Using VBA to Insert Rows in Excel When Row Value Changes

    Gavin, Well done. That solution works perfectly. Thank you both for the help!! Mark S. Lunter II
  8. mlunter

    Using VBA to Insert Rows in Excel When Row Value Changes

    Bob, Thank you for the reply! The second set of code is almost there. What I believe it does is count the number of times the value in Row 1 changes and insert that many rows into Row 1 at the top of the worksheet. Any suggestions on how to get it to insert the rows between value changes...
  9. mlunter

    Using VBA to Insert Rows in Excel When Row Value Changes

    I am working with a table like the following: ROW 1 A A A B B C C C When the row value changes from A to B, and B to C, I would simply like insert a row. My dataset is huge, so doing this manually is not an option. I looked through the forums for help but was unable to find...

Part and Inventory Search

Back
Top