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

Jumat, 19 Februari 2016

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

Your Building book? Are you referring to Building Microsoft Access Applications listed on your website? I will need to order that soon!

Thank you so much for your advice!

Jenn

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

Jenn-

If all 150 users are in the app at the same time and all doing heavy updates, then yes, unbound forms may be necessary. I present such an option in one of the sample databases in my Building book.

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 4:19 PM, jennylou68@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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