Error: Type mismatch

[Frank Situmorang]

Hello,

I put the calender pop up, and formerly it worked, but now, I do not know,
if there is and VBA during the development that contradicts, and the error
now, there is a pop up that says " Error: Type mismatch
then we have to preass " OK"

I apperciate anyone's help on waht goes wrong.

 

[Arvin Meyer [MVP]]

A type mismatch occurs when you try to add the wrong type of data to a
field, like trying to add text to a numeric field.

 

[Frank Situmorang]

Arvin,

I have checked the table, the field is the date time type, I want to fill in
date using pop up celendar to facilitate typing

I f you could explain more..

 

[Linq Adams via AccessMonster.com]

Could we see the code behind your calendar that assigns the value to the
field?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Arvin Meyer [MVP]]

Use the popup calendar at:

http://www.datastrat.com/Download/Calendar2K.zip

Simply import the calendar and the accompanying module into your database,
and add:

=popCalendar()

to each textbox double click event where you'd want to use it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com