Khalid-
If you have more than one report (and I'm sure there will be others later), have a Reports button on the main menu open a new "menu" form dedicated to reports. Consider using check boxes in an Option Group to pick the form. When the user picks a report that requires parameters, unhide the controls on that form to let them enter what is needed. If you have multiple reports that require parameters, you can even overlap the parameter controls to save space on the form, and then show / hide the controls as appropriate for each selected report. A Run Report button will actually figure out which report is requested and fire off that report.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Jan 14, 2017, at 2:28 PM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi John,
A new situation has arrived to me.
On my frm "MainMenu" i have few command buttons to open certain forms/Reports.
Suppose through button "Reports" we have opened some report, on that reports On Close Event the code is:
Private Sub Report_Close()
DoCmd.Close acForm, "Dialog Invoice And Packing List"
DoCmd.OpenForm "Export Documents" <======
DoCmd.Restore
End Sub
Here at this point can i have any choice that user may be asked whether he wants to open again "Export Documents" OR go to "MainMenu".
This is because my boss has asked me to put something on Main Menu for "Frequent Inputs/Reports" for this i have put some Labels for
Frequent Inputs/Frequent Reports, and from there On Click event open the required Form/Report, the desired forms/reports by him.
For the Forms i have put two buttons:
Return To Previous Menu
Return To Main Menu
This fulfills my requirement for forms, but need help for Reports.
Regards,
Khalid
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar