By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,659 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,659 IT Pros & Developers. It's quick & easy.

Access Open Form Criteria

P: 9
I am new to MS Access and database. What I want to achieve is to get a form pop out every time I open a database file in Access, that the user can select the report generation date range, type of levels of the reports, etc. then the criteria will be sent to the sql server that the access tables/database are linked with to generate the specified report in access.
Dec 31 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
You've stated what you're trying to do, now you need to tell us which part(s) you're having problems with.

Welcome to TheScripts!

Linq ;0)>
Dec 31 '07 #2

P: 9
I am new to MS Access and database. What I want to achieve is to get a form pop out every time I open a database file in Access, that the user can select the report generation date range, type of levels of the reports, etc. then the criteria will be sent to the sql server that the access tables/database are linked with to generate the specified report in access.
Where I have problem is the creation part of the MS pop-up form to link with the sql server.
Dec 31 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Where I have problem is the creation part of the MS pop-up form to link with the sql server.
The report will be based on your linked tables and not linked to SQL Server directly.

Having a form open when database starts just means adding it as the Startup form in Tools - Startup.
Jan 8 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.