Datetime picker error?

C

Candy

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.
 
W

Wayne Morgan

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.
 
C

Candy

Might be code corruption. Cos after I've reopen the program, the error is no
longer exist.

Thanks.
 

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

Top