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

Jumat, 19 Februari 2016

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

Thank you John. I will work on using the BeforeUpdate event in my development database. I have a small group that does my beta testing before I release to the masses.

I do have a question though...I have roughly 150 users (a.k.a. "the masses"). My cursory search of bound vs unbound forms reveals several articles that suggest unbound forms are more ideal in a large user environment. What say you?

Have a lovely weekend!

Jenn

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Jenn-

You should use bound forms - and put code in the BeforeUpdate event to validate fields before they're saved no matter what the user does - close the form, move to the next, etc. You can also issue a MsgBox in BeforeUpdate to prompt the user to confirm the save. Doing in SQL behind an unbound form is doing it the hard way.

Also, when you reply on the web, be SURE to click Show Message History so that folks like me using email can see the entire thread.

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

http://www.viescas.com/

(Paris, France)

On Feb 19, 2016, at 3:11 PM, jennylou68@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello John,

I am executing an INSERT INTO statement. I am using unbound forms to force users to consciously decide to add their submission to the database (by clicking a "Save" button). I spent to much time cleaning up records that were not complete because a user realized they were not ready and just closed out the database, leaving the partial information.

I know unbound forms are less than popular with database designers but I haven't learned any other way to do this. I have no formal training in Access so I am constantly trying to learn how to do things. My next quest will be to understand how to use bound forms more effectively.

Have a fantastic day!

Jenn