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

    Using VBA to set a field value in unrelated table

    What is the best way to set a value in an unrelated table programatically? For example, I have a table called z_ProgDefaults that has certain default values for different portions of the program. I want to have an On_Click event on the chkMsg control in the ProjChangeOrders form automatically...
  2. jtuj71

    Best way to set values in unrelated tables programatically

    What is the best way to set a value in an unrelated table programatically? For example, I have a table called z_ProgDefaults that has certain default values for different portions of the program. I want to have an On_Click event on the chkMsg control in the ProjChangeOrders form automatically...
  3. jtuj71

    Multiple forms sharing common subform

    Yes, thanks. :-) One other clarification...If I'm understanding you correctly, the contacts table should have all three foreign keys in it?
  4. jtuj71

    Multiple forms sharing common subform

    The Architects, Customers, and Vendors tables can have multiple contacts per companyID. For example, XYZ Architects can have 5 contacts (jim smith, jane doe, etc.) The data stored in the contacts db is on an individual level - cell phone, office extension, spouse, etc.. But, Acme Distributors...
  5. jtuj71

    Multiple forms sharing common subform

    I have 3 tables (architects, customers, and vendors) using a contacts subform. It all seems to work correctly but I want to ensure that I'm linking them correctly. I have the three tables' key fields joined to the ID field in the contacts table but I can't enable referential integrity because...

Part and Inventory Search

Back
Top