Recent content by nightmaregenerator

How would I apply the clear fields macro to the disable fields macro? I have been trying all sorts of combination but none seem to work.

Sorry for no reply, I'm back at school and never have time to post anymore but I have been working on the database to fix relationships and normalization, just on that for the drivers you mentioned currHourlyRate, for this because drivers can take a single, double and road train, for the kms...

I'll try to answer and give an explanation for everything you mentioned. I knew and do try to avoid the space problem but I do have a bad habit of naming tables and queries with spaces. But I will be more aware of that! Basically the database does exactly what you explained; we then create a...

From looking at the page you supplied and the database you provided I think I understand the problem with the normalization, just to be sure I know what it the problem is. Is it the fact that the reference instead of being the primary key from the employee's database it is instead the employees...

Here is the database I am currently using. Otherwise it makes perfect sense.

I have list of about 20 or so users that keeps growing I have implemented a parameter query to successfully isolate the users activity between two dates. But have been unsuccessful at two things. I can't seem to figure out how to get the parameter query to isolate single names. I have tried...

I have list of about 20 or so users that keeps growing I have implemented a parameter query to successfully isolate the users activity between two dates. But have been unsuccessful at two things. I can't seem to figure out how to get the parameter query to isolate single names. I have tried...

I did try to use a form but I had another error come up which was Enter Parameter: [Forms]![QueryRequest]![txtFirstName] and that would continue for the fields I had put that reference into.

I found a similar page and tried implementing a Parameter Query, but when ever I hit run it tells me that: When I type any value. Including names and dates.

Yeah I was playing with the code and i got it working pretty well except I can't work out how to only get it to pop up if the box is unchecked.

I have attempted to make a form to enter the parameter values, but with the query that I need to run, does it need all the fields? Or just the three that want to search? With this said with a parameter query that has First Name, Last Name, Start Week, and End Week, how do I get it to search...

So I would just have all the fields I need and have the paramenters asking: Like [Which Last Name?] Like [Which First Name?] Between [Type the beginning date:] And [Type the ending date:]

After reading your response dfenton with the alternate code I understood the pros to doing it that way, I have made those adjustments and have tested it but found that no matter whether I hit Yes or No it clears the box, so I am trying to add a if response but I don't actually know what to put...

I have 20 or something queries that continues to grow, as every time a new driver is employed I need to do a new run sheet which is handled by the query and put into a report. But because these run sheets are done weekly I need a way to update this growing list of queries very quickly and...

Is there a way to get information from an unbound text box into a report? I have a form that has a few feilds calculated on the form through unbound text boxes but I need these values in be seen in a report. Any ideas?