You are here:

Using MS Access/Access user-friendly interface

Advertisement


Question
I have an ACCESS databse with 8 data tables. Wrote about 12 SQL script that generate some report.

Need a way to have a user-friendly interface that takes a couple user input then execute some of the above scripts and display result to be copied or viewed by the user. What is my option. Is VBA the right thing? How can I pass the user input to the SQL script and get executed? Never did user interface for ACCESS, need some direction.
Thank you.   Mort Hashemi

Answer
While you may need some VBA, you can do this simply with Forms.

I'm not clear what you mean by SQL script. Within Access there are query objects that are SQL statements that can be run or used as the source of reports. If all you currently do is generate reports, well that is all you need to run the SQL behind the reports.

To get the data into your tables or edit the data, simple use the Form wizard to create your forms. You can use mainform/subform combinations depending on your data structures.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

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

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

©2016 About.com. All rights reserved.