Recent content by freightguy

If we were to use GHUDSON's code, would it be possible to use it in the Switchboard menu? I can see this being used if you have a main form but can't see where to place this code anywhere in the switchboard form. thank you

thank you all - the revisiting the query and including the quotes did the trick. Great reading material as well on working around combo boxes. Cheers!

Hi everyone I am working on a shipping program and one of the subforms contains a list of technologies and technology description (similar to Category and Product Name). On the subform I have two combo boxes. The first provides a distinct list of "Technology" and the second combo box provides...

I think I had it that way at one time but I will try what you suggest. Failing that I will come back and provide you with rest of the code. thank you for pointing that out.

Hi all - I am having a difficult time locating my problem. I have an error handling code in the "On Exit" event of a form's button. This event runs through a recordset then compiles and sends an email. On the same command button I have an "On Click" event that controls the data input for about...

I had to same problem but mine was due to the ID field. I simply moved the ID field from first field to last field and the error did not re-occur (I used the query builder). The message was right that we cannot assign a value to the field (field being the primary ID in my case) - hope this...

Awesome! Thank you.

Hi everyone. Need assistance with a query using DATEPART. When I use the Query builder the query is as such: SELECT tblShipment.expID, tblShipment.SRDate, tblShipment.ProjectNumber FROM tblShipment WHERE (((Year([srdate]))=2018) AND ((DatePart("q",[SRDate]))=3)); Above returns all records...

First hats off to both June7 and Mark for pointing out some useless code and other errors. This code was riddled with syntax errors. First I was referencing the wrong subform name then I had a typo when referring to one of the fields. All good now and thank you again. The more I cleaned up...

QUOTE You originally said the second subform Recordset was causing error. Is that still the case? Try commenting the first and see if the second runs solo. The procedure says closing rsDetail causes error. Get rid of code pertaining to those recordset objects UNQUOTE Yes still causing error...

Interesting. You're both right. I just dimmed out all the code with recordset and I was still able to send email successfully. The code I used was done several years ago. I'm going to have to dig up my notes and see what the recordset was all about. thank you both again

Hmmm strSQL is being used because it produces a list of items (part number, qty, etc..) shipped. (this part works) strSQL2 is suppose to return the weight and dimensions of the case shipped. I can't tell if it works because thats the second recordset where I'm having problems with.

Well that's doesn't sound promising :eek: I didn't notice your post #8 until you mentioned it. Thanks If the one SQL query included ALL fields required to send in email, it might work that way. I would only need one recordset to work with. thanks for looking into this. I'll come back when I...

My bad. I posted the code that works well. Below is the same code when I try to add a second recordset using a different subform. Private Sub Command20_Exit(Cancel As Integer) Dim strEmail, strBody As String Dim objOutlook As Object Dim objEmail As Object Dim db As DAO.Database Dim rsDetail...

yes and still working at it (you're reply sent me back to the text books to read up on recordsetclone ;) thank you