Using MS Access/Expert Profile


Ask A Question

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience in the area

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials

Brooklyn College BA


This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Carleton02/20/17101010 
Oleg02/12/17101010I agree but the situation is even .....
Oleg02/02/17101010Thank you very much!
Oleg01/27/17101010Thank you very much.
OB01/20/17101010Thanks a lot.

Recent Answers from Scottgem

2017-02-15 Sequential Numbering:

Ok, Are you sure that is form?     Try it like this:    Forms!formname!controlname = Nz(DMax(“[Claim Reference]”,”tblWarrantyClaims”),0)+1    Use the actual form and control names.    it is not a good

2017-02-10 Securing BackEnd file:

Read my blog on Securing the Back End    But frankly, if you have people who will try to get past the front end, then you have a bigger problem. I have well over 100 Access apps and I don't use extraordinary

2017-02-02 Passing value between forms:

I would do it differently.     DoCmd.OpenForm "frmTimEntry",,,,acAdd    Then, on frmTimeentry I would set the default value for txtValue2 to Forms!frmLogin.txtValue1.    The problem is likely that the

2017-02-02 Passing value between forms:

You can open the form in Add Mode and then assign values to the controls. Or you could set the default value to read from the referenced control.    

2017-01-27 Log User Activity:

Don't use .Value. first it its the default value when referencing a control on a form and that's not what you are doing. You are referencing a variable passed to the procedure.     You should be using:

 

Ask A Question

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2017 About.com. All rights reserved.