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!

Search results for query: *

  1. generallyconfused

    Do recordsets behave differently under different connections?

    Hi all, Try this out for me please.... I have 2 databases. The first, db1, only contains a form with a command button and some code under it (The code is below). The second, db2, has one table. This table is kinda weird however in that it is related to itself. This table stores part and...
  2. generallyconfused

    Updating Multiple Related Tables

    I have 2 databases that have five data tables that are related to each other. The relationships look something like this.... Database 1 (db1) Database 2 (db2) Tbl2 Tbl2 / | \ / | Tbl1-+-Tbl3--Tbl5...
  3. generallyconfused

    How to turn off autonumber via vba.

    Hello all, It is possible to change an autonumber fields datatype to a number (long integer) via the access gui under table design. My question is how would I do the same thing via vba code, preferably with ADO, to a dbase that is not open. I was thinking of something like this..... First...
  4. generallyconfused

    Help with "Filter On:" using a combo box.

    Hello all, Forgive the cross post, but I orignally posted this in "Access Other Topics" when it is far more suited for this forum. I have a form with a combo box. The combo box looks up entries from a table that is not the recordsource for the form. It grabs two pieces of criteria...
  5. generallyconfused

    Form filter woes...

    Hello all, I have a form with a combo box. The combo box looks up two values (ID, Item) from another table. The first column width is set to zero so the user cannot see the ID of the item they are selecting. When attempting to filter (right click combo box, select filter for:, enter item) I...
  6. generallyconfused

    Access Backwards Compatibility

    Hello all, I've developed a little access application for my boss in Access 2002. He is operating in Access 2000. I have the default file format set to 2000 in my version of 2002. And the dbase works great for me in 2002. My problem is when I send him a copy of the dbase to look over, the...

Part and Inventory Search

Back
Top