Search results

Sure heres the SQL for the Query: SELECT Orders.OrderID, Orders.[Last Name], Employees.FirstName, Orders.[Part Number], Orders.OrderDate, Orders.[Job Task], Orders.[Part Location], Orders.StartTime, Orders.EndTime, ([endtime]-[starttime])*24 AS total, Orders.[Order Complete]...

The part that just won't work is that the form comes up blank. With none of the combo boxes availiable, not even the OK or cancel buttons. I am not able to download the sample database because of the IT restrictions at my company, I was planning on doing that tonight at home.

I do not have a wherecondition specified (I don't know what its function really is). My Report "Productivity" is set that when opened, it opens a form(report Filter) in front of it, which should filter the query(Production Log) and so filter the report. I got instructions how to do it through...

Helpn I'm going Bald: Form Filter Question I am trying to create a way for users to be able to filter a report just by opening it, and entering their criteria. so far I have it set up that a form with different list boxes pops-up, the user fills in the parameters, and clicks OK. From there it...

I am still working my way up the Access moutian. I am working on a project that lets users search the database for a number of different items, which will then generate a report. I just cannot figure it out. I tried this code that developed a dialog box, but I get the runtime error 2585. The...