Error -2147352567 (80020009), Access 2007

Jan 22, 2016
Reaction score
Hi All,

I have main form and subform in the subform i have quary of the time and date to calculate the Difference of the time between two times and two dates it's appear in the unbounded txtbox named timediff1, so to save the time difference i create txtbox named timediff and i use these code in the setfocus event:


the problem that i have that when i enter the data starttime "1:00 pm", startdate "20/1/2016", endtime "2:00 pm", endate "21/1/2016" the end date in the next day these error is appear focusing to the code me.timediff=me.timediff1, how can i solve these problem.

i attach some pictures please help


  • صورة جديدة (35).jpg
    صورة جديدة (35).jpg
    67 KB · Views: 248
  • صورة جديدة (36).jpg
    صورة جديدة (36).jpg
    105.5 KB · Views: 246
  • صورة جديدة (37).jpg
    صورة جديدة (37).jpg
    83.9 KB · Views: 367
  • صورة جديدة (38).jpg
    صورة جديدة (38).jpg
    66.3 KB · Views: 244

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question