Recent content by rywello

Ok, sounds good. arnelgp : No I did not change the combobox name. Why would I be getting the below error? Now I am I am getting the error Syntax error (missing Operator) in expression on the below line: rs.FindFirst "[EMP_NB] = " & Me.cboEmployee I have the 2 forms linked by EMP_NB.

Here it is. I am also trying to get the shift types in each date across kind of like a calendar but not sure if that is possible with these forms. Thanks!

I changed the table name to Employees. Now I am I am getting the error Syntax error (missing Operator) in expression on the below line: rs.FindFirst "[EMP_NB] = " & Me.cboEmployee I have the 2 forms linked by EMP_NB. I tried to attach the DB but keep getting an error.

Thanks! I no longer get the type mismatch or any errors but the subform is not populating. Is Me.tblDays_subform.Form.RecordSource = strSQL correct when referring to the subform?

I have the below code and to link a subform and a form based on the combobox value. I get a data type mismatch on the code highlighted in orange. It is a number field so I am not sure why the error. Also the subform is based on a query. Any help is appreciated. Private Sub...

Hi Again, I have tried adding on to my select statement but I am getting the error "Too few parameters. Expected 2. I am trying to pull the records that have a PIGIDATE equal to today's date or 1 day greater than today's date and the PlantAnticipatedDate has no value. Not sure where I am going...

I figured it out! Thanks for the help!

Where do I put it?

Hi Everyone, I am trying to create an html formatted table in Outlook that displays the results of a query. I can get the 2 tables to display on the email but they merge together into one. I also would like to write text above the second table. Below is my code. Any suggestions? Function...

I used the statement with the "OR" instead of "AND". Thanks again!

That works great! Thanks!

I want to bring back all the records for the plants 00CX and 01FT.

I got the first part of the select statement to work and bring back all the records for 00CX so I tried adding on to it. strSQL = "SELECT * FROM tblTrucks WHERE [Plant] = '" & "00CX" & "'"

I am writing a select statement to bring back the data for two plants 00BB and 01FT from the tblTrucks table, Plant column. The below query only brings back the data for 00BB but nothing for 01FT. Not sure what I am missing. Any help is appreciated. strSQL = "SELECT * FROM tblTrucks WHERE...

That works! thanks,