Search results

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?

Is there a way that I can move numbers calculated in a macro event into a form of some sort? I have a form that has four features calculated; these are all kept in unbound text boxes: Allowance Total Kilometer Total Local Gross and Gross I want to be able to click a button that calculates...

Oh right yes, I even learnt that in school I have used the code that was used in the video auto fill the text boxes but I found when the value was auto filled with a decimal place it didn't appear, is that becasue I need to declaire that it's not just a normal number but a decimal? I have...

With this said, is there anyway to refer to another field, then be able to use that refrence in a sum so if I wanted to create another field that times the load size (that refers with =[SingleDouble].[Column](2)) to the kms travels (=[Destination].[Column](4)) in an unbound control? Or is this...

Basically the problem is that, when I created the formular in the repoert what ever the top gross was all other loads had that number appear. I basically need a formula that can calculate unbound text boxes; but from what I have found this is impossible. The reason I need it to refer to...

On the Report that is how the drivers name appears, so I need to change the fk for the payroll to the pk in the drivers details table? With the way it's all layed out is there a way to solve the original problem of gross earned for the trip being added up into a total gross for the report...