Search results for query: *

Thanks PHV, works great.

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

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

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

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.

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

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

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.

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

That did it, thanks. My new code is: .To = HyperlinkPart(DLookup("[Contact1Email]", "Customers", "[CustomerID]=[Forms]![Orders]![CustomerID]"), acDisplayedValue)

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

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.

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

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

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

Thanks for cleaning up my code PH, I just copied it (for the most part) from the SQL mode of the query because I don't really know the language. I still have the same error though.

I was trying to type DAO.Recordset, but it wouldn't come up with just recordset as a dropdown option. The only option with recordset in it was dao.RecordsetOptionEnum. Would that have anything to do with the error? Should I change dao.recordset to dao.RecordsetOptionEnum? I have Microsoft...

I tried using the immediate window, but when I put in ?strSQL, it doesn't bring up anything, when I hit enter it just puts in a blank line. I then made a query to pull the records. The query works fine, but it will not work when I put the code into the VBA editor. The code I took from the...

Thanks a lot Richard, I will give it a try on Monday and let you know how it goes.

I appreciate your help willir, but I am having a compile error when I run the code at the line: "Set rstT = CurrentDB.OpenRecrodset(strSQL)" I think it is with the .OpenRecordset Method. The error is, "Compile Error, method or datamember not found" I checked online about the error, and it...