Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old February 8th, 2016, 12:08 PM
DeanJW2006 DeanJW2006 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2016
Posts: 1 DeanJW2006 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 36 m 47 sec
Reputation Power: 0
Passing Parameters to a QueryDef using a list box

I'm trying to figure a way to run 10 to 15 monthly reports without having to manually change four parameters for each report.

I used to print each one individually using a combo box to select the Business Line and Executive associated with each report.

Next, I created 15 little sub-routines that had the above parameters hard coded into each query/report. This works great but is not very efficient and now if I have to make a change to a report, I'm changing 15 reports/queries.

Basically, the report is the same except for four parameters. Ideally, I would use a list box with the multiple items enabled to choose which business lines get reports. Each business line has an Executive associated with the business line.

The first time through the report would select business line 1 and Executive 1. Then it would loop through and run the report with the next item(Business Line/Executive), etc. until all selected Business line/Executives have been satisfied.

The only other twist is that the Execuitve could be primary, secondary, third, fourth or fifth. In other words, the Executive might be primary for his/her business line, but may also appear in 4 other reports as secondary, third, fourth.....at present, I just pass the Business Line/Executive in a combo box. The same executive combo box field is used in a manner like: Forms!frmMyform!cboExec, ......Exec2,......Exec3 etc.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Passing Parameters to a QueryDef using a list box


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap