Okay, jdraw i switched to Chrome and was able to down load it. I will look it over and and get back to you tomorrow. Thank you very much. Hey, is Chrome better than IE?
Wow, jdraw that is totally awesome. How would you build that normally? Okay, now with that in place, is it possible to just show the reports for that client? Right now it shows all reports including the graphs that do not need to be shown. Also, can I put a pull down menu for each client, so that I have 15 clients and each one would have their own pull down to see their reports, and can this be on the same form you have sent me? But this is so cool.
Would I use that instead of what you have sent me?? Markk, I would create a table that I would name the reports, and have a link to them, then create a form then put a combo box on it that would link to that table?? How would I be able to choose either print or preview as in yours?
You create a table to contain the names of the reports you want for your selection list.
Use that table or a query based on that table as the rowsource of your combobox.
Okay, I made a table and called it tblClientReport. The fields are, ClientReportID, ClientID (which is linked to the customers and lets me chose the client), and ReportName. Here is an example of what I have so far:
Yangfeng - Cluster C489 , another Yangfeng - Cluster C489 Molding 1 shift, and etc. So now how do I make it work. I will have more clients and more report for those clients. So how do I put this together to work where I can chose a report to either view or print? Would I be able to use jdraws set up?
Do I put that into the form that I downloaded from you jdraw? Or am I creating a new form with new all new comboboxes? Also I did put in my table the following: ClientReportID, ClientID and ReportName.
Thank you jdraw for the site on combo box, cool site. I think I get the idea. I first need to get my table to work right. What I mean is that I had set it up like we discussed, but where the report name is at, I do I get it to link to my reports? The only hyperlink I found anything on was to set up emails and web pages. If the person goes to my combo box, I will need that to link to my report.
Open the form in design view, click on the button and review the Click Event Procedure.
That is the code that was changed.
I adjusted the Rowsource of the combobox to supply all Report names in your database except those beginning "rpt".
Rowsource sql is
Code:
SELECT MsysObjects.Name, 'report' AS objtyp FROM MsysObjects
WHERE ((((MsysObjects.Name) Like '~*' Or
(MsysObjects.Name) Like 'rpt*')=False) And
((MsysObjects.Type)=-32764))
ORDER BY MsysObjects.Name;