Error Message PopUp

[Bill]

Hi,

When I enter a date on the form, I got the pop message saying - - -
Format([Date],"YYYY" - - - . I create this on the queries. Is MS access 97
lower version or is there anything I should know and fix the problem?

Your helpu would be much appreciated and feeback.

 

[Mingqing Cheng [MSFT]]

Hi Bill,

From your descriptions, I understood that you will get an pop-up message
saying there is something wrong with your inputs for data field. Have I
understood you? You concerns are whether it will work in Access 97 or lower
version?

However, I am not sure how about the Form you created. Based on my test, I
create a Table with date/time, and then create a Query based on this table,
and then create a Form based on this Query. I cannot get the pop-up message
as you said. Only when I mistype the date/time format, there will be a
pop-up message saying "The value you entered isn't valid for this field."

Would you please send me some screen shot or generate a sample sending to
(e-mail address removed) (remove 'online' as it's only for SPAM)

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center

 

[Mingqing Cheng [MSFT]]

Hi Bill,

I haven't heard back from you yet and I'm just writing in to see if you
have had an opportunity to collect the information. If you could get back
to me at your earliest convenience, we will be able to go ahead. If there
was some part of my post that you didn't understand, please feel free to
post here. I look forward to hearing from you.


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center