No results for specific value.

[Homegrownandy]

TimesheetTest.zip

Ive attached a sample database. I have removed most of the data but it still shows the problem.

If you open the TSEntries form (you can get to this from the menu form by clicking Payroll).

This form will show a sum of hours worked per person for that week.

There is a button next to it which, when clicked will display a breakdown of those hours.

It works fine except for anything with a date of 07/10/2018. Ive tried remaking every form, changing dates... I've even remade the whole database....

What am I missing here? If anyone could take a look i would appreciate it.

Andy.

[Minty]

You need to format your date - Access is chnaging your UK date to US format.

Change this line to this;

DoCmd.OpenForm "TSEntries1", , , "[TS_Week_Ending]=" & "#" & Format([TSWeek_Ending], "mm/dd/yyyy") & "#"

[Homegrownandy]

Well I never. That simple. I spent about two days trying to fix it before I "broke" and came here.

Thanks a lot.

[ssanfu]

Allen Browne has a function for that.

See http://www.allenbrowne.com/ser-30.html

Look for the "Dates in Strings" section

[Homegrownandy]

Something is wrong with my formatting here, I dont often use functions to be honest.

It has the error, "expected end of statement" on the SQLDate part.

DoCmd.OpenForm "Payroll_Breakdown", , , "[TS_Week_Ending]=" SQLDate [TSWeek_Ending]

Ill keep changing things around and looking but can you see anything obvious?

[Minty]

It should be something like

& SQLDate(Me.TSWeek_Ending)

Note the brackets and the & to concatenate the string

Assuming the controls on your form is called TSWeek_Ending

Helpful Hint of the day : In the immediate VBA editor window type the following

?SQLDate(DAte())

And hit return -
? will print the results of a typed expression.

[Homegrownandy]

Brilliant. Also that is a good hint. Works a treat!