Search results

The job table from your description would be the Weekly Payroll table I have set up, while load descriptions are too hard to organize because each truck can be carrying 6 to 7 different company loads. The same as Start Dates and Start and Finish Times, as drivers may only do a week’s work for...

I'll explain the way I have it, Basically I have a destination table, this keeps “From”, “To”, “Return” and the “kms” traveled. Then there is the Driver Details which just stores the first and last name. A Lode size which holds the load size and the rate at which they get paid for that...

Sorry with query do I include the kms, charge, hourly rate and hours worked or should I have the totals of the formulas in separate fields? For the minute the Gross is an unbound text box in only the report.

Hi all, I have basically created a report for a truck company that outlines each driver’s “Weekly Load Outline” that summarizes through a query, all the below details: Work Date Truck Number Single/Double Destination - To - Return Km Rate Kms Hourly Rate Hours Worked Gross and Allowance So...

That was a factor I never took into consideration... It raises a good point though; I would like it to come up with a message box warning that if they continue the fields would remove all the text. If I wanted something like this, how would I go about it?

I'm only new to macros so I wrote that code here: Private Sub Form_Current() Function EnableDisableCtrls() Me.Hours.Enabled = Me.Local Me.HourlyRate.Enabled = Me.Local Me.Nights.Enabled = Me.Allowance Me.Hours.Disabled = Me.Local Me.HourlyRate.Disabled = Me.Local...

Sorry if I have confused you, I do have the data stored in another table with the departure destination, the to destination and the optional return trip destination with the kms stores in the next coloum so it looks something like this: ID From To Return Kms 1...

The information supplied for the database does not specify the kms separately for each return load. And because there are so many possibilities for destinations working out each leg can be difficult.

I have a form that basically allows us to record where a driver went whether they did a return trip and how many kilometers they are charged for. So basically what I can't seem to figure out is how to the kms to automatically come up when I select the destination. It's basically set up with a...

I have a form that I want when a check box is True it allows you to fill in extra details, but if it is False it either hides these details or does not allow you to enter these details. Anyone have any ideas?

So I have a form which I want to load a certain image if the right information is entered, so my formal is this: But the problem is that I want to put this database up for download, but the location of the image then changes and stops working, is there a way where I can do something similar...

Thanks, worked like a charm :p

Hi, I also had a similar problem, and came across this forum. My issue is similar but my formula does not work, I have noticed it does not work if your text box equals a text response. I may have missed a step but this is my formula: =IIf(IsNull([text97]),"",IIf( [text97] =THE ZOMBIES ARE...