Search results

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,

I can not use a validation rule as I import the table into my database and it won't allow me to save the validation rule on the field. Is there a way that I can add it to the VBA code I listed above? Thanks.

I have the code on the on click event of a button. I still cannot get the validation to work.

What do you mean "before update"?

Sorry, I was just giving an example. My code is really: If Not IsNull(Me.nomkey) Then strWhere = strWhere & "([Nom Key] = " & Me.nomkey & ") AND "

I am using the below code to search in a number field. When I enter text in the field, it asks for a parameter value before throwing an error. How can I get it to throw an error that says "Please enter a numeric value" instead? If Not IsNull(Me.number) Then strWhere = strWhere &...