Datetime picker error?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a run time error:
"The expression you entered has a field, control, or property name that
Mircosoft access can't find" , when I choose to debug, it highlighted the
following line which I have no idea what is wrong with it.

"if Me.dateEntry.Value> Me.dOrder.Value Then "

Me.dateEntry and Me.dOrder are both datetimepicker.

Any advice will be appreciated.
 
1) When you type "Me.", do you get the name of the control showing in the
Intellisense when you type the period? If you do a compile in the code
(Debug|Compile...) does the compiler find an error with these names? With
the form open in normal mode (i.e. not design view), if you go to the Debug
window (Ctrl+G) and type ?Forms!FormName!dataEntry, then press Enter, what
do you get?

2) Possibly a corrupted control. If so, delete the control, do a Compact and
Repair, then create a new control.

3) Possibly corruption in the code. To fix this, try a Decompile of the
code. For information on decompiling, see this link.
http://www.allenbrowne.com/ser-47.html This link will have information on
other types of corruption also.

4) Possibly a Library Reference problem. For information of fixing this, see
this link. http://www.allenbrowne.com/ser-38.html

Another possible thing to try is to create a new database file and import
all of the objects from your current file.
 
Might be code corruption. Cos after I've reopen the program, the error is no
longer exist.

Thanks.
 
Back
Top