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: *

  • Users: torb123
  • Content: Threads
  • Order by date
  1. torb123

    DAO Recordset

    I am working with products and systems. Some products are systems by themselves. I have set to a command button to make the product a system, but I want it to check and make sure it hasn't already been created as a system to eleminate duplicates. I am basing it off of the ProductName, and...
  2. torb123

    DAO Recordset

    I am working with three DAO recordsets, rst0 and rstK are related. When I create a record for rst0 I want to take the primary key of that new record which is SystemID and relate it by adding the SystemID to the recordset rstK. Unfortunately I am not sure how to do this. I have the code to the...
  3. torb123

    Adding line items to an order

    I am sure this has been discussed before, but I didn't find anything while searching. I have an order form set up similar to the order form in the Northwind database. The individual products are related to the order through the subform, using ProductID. The way it is set up, you can not add a...
  4. torb123

    Email - getting rid of the extra in To:

    I have a form that sends an invoice via email to a customer. To get the To: line I use a D-Lookup, but since the field is a hyperlink, it puts unnecessarytext in the To: Line. My D-Lookup is: .To = DLookup("[Contact1Email]", "Customers", "[CustomerID]=[Forms]![Orders]![CustomerID]") It puts...
  5. torb123

    Updating Datasheet Subform from Main Form

    I have an orders form with a subform that shows the individual products for the specific order. I am trying to make a button that you can click on to update or change the pricing from what it is currently to the new price (in case it needs updated so I don't need to go throug each one). I have...
  6. torb123

    Need help auto entering data into a subform.

    I have created a database to track customers, orders, invoicing, etc. I need help with the orders subform (order details). My table structure is customers (one) to orders (many), orders (one) to order details (many), and products (one) to order details (many). The order details table has each...

Part and Inventory Search

Back
Top