By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,835 Members | 984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,835 IT Pros & Developers. It's quick & easy.

Is this an error message? Do I need to try and "fix" it? HOW?!?

P: 1
Hi. I've been using Access for a couple of years now, but everything I know about it is self-taught. This makes me a little self-conscious/worried - I feel like I know how to do a lot, but I could have glaring gaping holes in my knowledge base that I don't even realize....ANYWAY, I'm working in Windows XP, with Access 2003. I've made this report that was fine until just recently. It doesn't have any error indicators, everything is doing exactly what I am telling it to, but every time I open it up or switch from page to page I get a popup window that says

Microsoft Office Access
"The value you entered isn't valid for this field.
For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits."

I don't have any idea why it started, but it didn't occur until I switched the datasource from the main table to a new query... When I run the query, everything works fine - the only thing I could take a stab at being the reason (but I have no idea the possible why's or how's) is because one of the values in the query is listed in a separate lookup table. But like I said, everything is doing what I want it to do! It's just annoying as HECK - it pops up when I print too, so printing the stupid thing, I had to press the OK button as many times as there were pages in the report. UGH!

I've searched through the troubleshoot/help section and also the MS Access online stuff--- I think my main problem is that I have no idea what it is referring to, and everything else seems to be fine, so I have no idea what to try and adjust even...

Any hints on why it suddenly started doing this would be very VERY appreciated!
May 18 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,923
[font=Verdana][size=2]That message is a warning message alerting you of a potential problem. It is not an error message. Try running the query by itself to see if you can identify which field is causing the warning. In the meantime, you can stop the warning message by sandwiching the openReport code line between 2 set warnings commands as shown:[/size][/font]
DoCmd.SetWarnings False
Your openReport code line
DoCmd.SetWarnings True
May 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.