Kamis, 18 Februari 2016

Re: [MS_AccessPros] Runtime Error 3075 due to field contents


Jenny Lou-

What's the code you're using to add the data?  And why are you doing that instead of using a bound form?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)

On Feb 18, 2016, at 9:04 PM, jennylou68@verizon.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I came across an unusual problem today. I have code to add the contents of a form to a table. It works great, with one exception. If I end the entry, in a text field, with a single quotation mark (') it throws a Run-Time Error 3075. This is not a big deal but if a user accidently hits the (') button at the end of their entry (and I'm sure it is bound to happen) it will cause this error. I will add this to my error handling but I didn't know if anyone else has come across this and how they handled it... or maybe why it does this. BTW.. I am using Access 2016.


Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)



Tidak ada komentar:

Posting Komentar