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!

Recent content by torb123

  1. torb123

    DAO Recordset

    Thanks PHV, works great.
  2. 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...
  3. torb123

    DAO Recordset

    Yeah, it worked great! (stupid typeo's) Thanks again :)
  4. torb123

    DAO Recordset

    LOL, didn't even notice the typeo. Thanks I will try it out and let you know how it goes. Thanks PHV and TheAceMan1
  5. torb123

    DAO Recordset

    Thanks for the tip, but it didn't work. I was thinking since it is a new record, if there is a way for me to have it go to the last record in rst0 or tblSystem and give me the SystemID (which is an autonumber). I am not sure how to do that though either. Thanks again.
  6. 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...
  7. torb123

    E-mailing multiple reports in one e-mail

    Fensbo, I use outlook, and it looks like that is what you will be using too. I have a documents table (named EmailDocuments) that has a link to where the documents are located on the server, as well as a yes/no check box to determine if that document is to be attached or not. Then I run a...
  8. torb123

    Adding line items to an order

    Thank you for your responses. Payback, I currently don't have a product description, and that should work out fine. Hadn't thought of it before, thanks again.
  9. 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...
  10. torb123

    Email - getting rid of the extra in To:

    That did it, thanks. My new code is: .To = HyperlinkPart(DLookup("[Contact1Email]", "Customers", "[CustomerID]=[Forms]![Orders]![CustomerID]"), acDisplayedValue)
  11. 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...
  12. torb123

    Updating Datasheet Subform from Main Form

    Thanks jaydeebetoo, but the form requery's fine. It is just that my code changes the price for every order in the database, and I only want it to change prices for the order that is being viewed.
  13. 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...
  14. torb123

    Need help auto entering data into a subform.

    Ok, so I am the biggest Idiot. I had it typed as recrodset instead of recordset. Thank you all for the help. I am now havnig a little trouble bringing in the price, but I should be able to figure it out. Thanks again, Eric
  15. torb123

    Need help auto entering data into a subform.

    I had changed it from 2.5/3.5 compatible to Microsoft DAO 3.6 Object Library at the end of last week, but it didn't help with the error. Thanks
See more

Part and Inventory Search

Back
Top