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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by methodmano

  1. methodmano

    SQL Grouping Query Help

    Thanks a lot! I knew I was missing something simple. Thanks a lot for your help.
  2. methodmano

    SQL Grouping Query Help

    I have a DB that is keeping track of refills of patient's drugs. In one table I have the number of refills and an ID (ID,refills - other fields omitted) that corresponds to another table with the drug information (ID,name,dosage,price). Ex. (2,8) -> (2,drugA,dosageA,priceA) where 2 is the ID...
  3. methodmano

    FindRecord Not Working on Certain Tab?

    Solved. Sorry about the post. Forms!firstForm!tabControl.Value = 0
  4. methodmano

    FindRecord Not Working on Certain Tab?

    I have a form that has 2 tabs where on the first tab is the primary key of the information - pSSN. I have another form that is an abbreviated list of information from the first one with primary key pSSN as well. I have a button on the second form that when clicked opens the first form and goes...
  5. methodmano

    Concurrency Control Question

    Awesome - thanks for the details. One last thing though (I think!): "Worry more about data corruption/backups and how you're going to do updates on the live database (hint: you can't)." What do you mean by this? Can you give me an example or a quick explanation? Again, thank you very much...
  6. methodmano

    Concurrency Control Question

    Thanks for the reply. Good to know that it is possible. Again, I'm not familiar with this aspect of Access and am still a bit unsure. Do I need to do something before I let the users access the DB or will it automatically handle multiple users? How does Access handle two users accessing the...
  7. methodmano

    Concurrency Control Question

    I've developed a DB (forms, reports, etc) using MSAccess2003 for a company where the users only have access to shared applications and a shared network drive (very locked down environment). I'll be placing the DB on the shared network drive (only possibility). How do I go about handling...
See more

Part and Inventory Search

Back
Top