Hi
I have an Access app which runs perfectly on my laptop, running Windows 11s.
I have purchased a Surface Pro 8, running Widows 11 Home.
I have copied the front end of my app to the Surface Pro and linked the tables to the Back End on my laptop.
I am now getting erratic errors in my app on the surface pro, which all appear to be related to dates (I think!)
For example, on my laptop I have a running sum query that uses a dsum on another query.
The query field is:
ThisBalance: Format(DSum("SumofDeposits","QryDailyTransBalances","ThisDate <= #" & [ThisDate] & " # ")-DSum("Payments","QryDailyTransBalances","ThisDate <= #" & [ThisDate] & " # "),"Currency")
This has always, and does still work perfectly.
On the surface pro, the first 8 days of every month are null in the query. That is 1st to 8th of each month.
There is definitely data in the underlying query and this does not occur on my laptop.
Any suggestions as to what may be causing this? Could it be system settings related?
Appreciate any advice.
Thanks
David
I have an Access app which runs perfectly on my laptop, running Windows 11s.
I have purchased a Surface Pro 8, running Widows 11 Home.
I have copied the front end of my app to the Surface Pro and linked the tables to the Back End on my laptop.
I am now getting erratic errors in my app on the surface pro, which all appear to be related to dates (I think!)
For example, on my laptop I have a running sum query that uses a dsum on another query.
The query field is:
ThisBalance: Format(DSum("SumofDeposits","QryDailyTransBalances","ThisDate <= #" & [ThisDate] & " # ")-DSum("Payments","QryDailyTransBalances","ThisDate <= #" & [ThisDate] & " # "),"Currency")
This has always, and does still work perfectly.
On the surface pro, the first 8 days of every month are null in the query. That is 1st to 8th of each month.
There is definitely data in the underlying query and this does not occur on my laptop.
Any suggestions as to what may be causing this? Could it be system settings related?
Appreciate any advice.
Thanks
David