Recent content by falcon7a

I am trying to look into an Access table. If certain conditions are met, I want the variable CompactorDate to store the date. The code works fine if the DLookup function returns a date. The program errors out if DLookup returns Null. The IF loop doesn't seem to solve the problem either. The...

have a report in which I would like to display "Yes" if a certain entry exists in a query table. I am using an If loop as shown below. I am getting an error at the line "If qryTempData.EPCStatusDesc = 'Dock Door'. EPCStatusDesc is a field in the query table. How can i get "Yes" to be printed if...

Thanks for your help so far. The query table has been populated using the code that I posted. I understand the query table will only have the text 'dock door' in it. I made it that way just as a test. I however, still don't know to look into the query table and print out "Yes" if the text...

I have a report in which I would like to display "Yes" if a certain entry exists in a query table. I am using an If loop as shown below. I am getting an error at the line If qryTempData.EPCStatusDesc = Dock Door. EPCStatusDesc is a field in the query table. How can i get "Yes" to be printed if...

I am trying to modify the contents of a report based on the values in a query table that i populate through a form. I tried to do that by the following code in the report: Private Sub Report_Open(Cancel As Integer) Dim Text19 As TextBox If (something) Me.Text19 = Yes Else me.Text19 = No End...