Invalid Datatype Check

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

Guest

I have developed an Access application that gathers data from a data entry
staff; it then generates and sends reports to management. Occasionally,
invalid entries (text instead of number etc.), cause data type mismatches
preventing the reporting. How can I programmatically check for these errors
and delete the bad records before the reports are generated?

Thanks

Alex
 
Use the BeforeUpdate event of the textbox to control to validate the data
entered.
 

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

Similar Threads

Invalid Argument 1
import from excel with data validation 6
Windows 10 Insufficient disk space to fix volume bitmap. 5
SendKeys in Access2003 and Vista 2
persistent "invalid reference" error message 2
Dynamic Report Design 3
Append data and then delete original record 1
ActiveX/COM - invalid entries? 3

Back
Top