Search results for query: *

Are these spreadsheets constant? If so, try building a form with a list box and place the paths and names of all your files in the box. Then code it like this: Dim stFile As String Dim stTable As String stTable = "TableName" stFile = [Forms]![Formname]![ListBoxName]...

All right, I give up! I'm trying to run a query(s) that will return data and perform calculations based on the criteria >=[Forms]![My_Form]![Date_In1] and <=[Forms]![My_Form]![Date_Out1]. This returns values for Starts and Hours on a particular piece of equipment (which will essentially tell...

Doh! Thanks for sticking with me. I had a brainfart there due to a lack of sleep. Thanks for your time and patience, works like a charm. All's well in Metropolis, once again.

I'm not sure if that will help in the short term. I'm using a mm/yy date on a form as the criteria for the query to find the appropriate records. However, you're response did help me find a temporary solution. Maybe I should rephrase now that it's working (within the last 10 mins). Is there...

Is there a simple way to do a search by using a mm/yy format to find data in a mm/dd/yyyy format. I tried using a query that would add days to the mm/yy format (since I'm assuming Access believes the data to be from the first day of the month), but no luck. I'm probably missing a VERY obvious...