Thanks to everyone who suggested a solution. Think I've cracked it. Needed a call to SQL to get the correct record in the first place.
blnFound = False
strSQL = "SELECT [BOOKING REF], end_odo, start_odo, status, total_days_hired, hire_cost, sys_date_returned " & _...
Thanks Ace.
I tried your code but got the following message:
"Operation is not supported for this type of object"
Any other suggestions would be appreciated.
Deakin69
Hi can anyone help with the following problem please...
I have added a couple of fields (START_ODE & END_ODO BOTH NUMBER FIELDS FOR ENTERING MILEAGE) to a table (REQBOOK).
The table gets updated via a DO...LOOP statement ie.
-------------------------------------------------------
Do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.