The database would only be used on a "one user at a time" basis.
Maybe I've been staring at this for too long but I'm at a complete loss. So if you could at least point me in the right direction, I can maybe finish it. The cost I have above (in the main question portion of the post) copies the object and loops it with the correct file names, but I can't figure out how I would incorporate the filtering in that loop.
User Profile
Collapse
-
Could that work while using a table as the reference for the client ID's in the loop?Leave a comment:
-
Copy Report with Filter
I currently have a report that is filtered with a list of clients from a separate table, however, I need to create a a copy of that report for each client. Below is the code that I currently have:
...Code:Public Function OrgIDReports() Dim db As DAO.Database Dim rs As DAO.Recordset Dim sqlStr As String sqlStr = "SELECT * FROM [Temp Table]" Set db = CurrentDb
-
Perfect!! Thanks so much!!
One last question - When the OpenReport happens, I have the settings set-up so that it automatically prints the report to PDF (using Scansoft), however, since it's filtered from the same report, everything is saved with the same file name (ie - the report name). Would you know of a way to alter this so that it would also include the I# field that is it filtering on?Leave a comment:
-
I# is a number and the column in [Temp Table] is called I# as well.Leave a comment:
-
Neopa - I'm not quite sure I follow. Can you post an example?Leave a comment:
-
When I enter your code, I am now getting a "Type Mismatch" errorLeave a comment:
-
Filter Loop with OpenReport
With my code below, I am trying to filter the 1 report for each record set in the "Temp Table". The report is filtered from a query "Carrier Report".
...Code:Public Function OrgIDReports() Dim db As DAO.Database Dim rs As DAO.Recordset Dim sqlStr As String sqlStr = "SELECT * FROM [Temp Table]" Set db = CurrentDb Set rs = db.OpenRecordset(sqlStr)
-
My main problem is saving it with the client's ID in the the name. The OpenReport would be fine with just opening the report and filtering it on a specific client.Leave a comment:
-
Access Filter Report with Field Name
I currently have a report that summarizes my data for each client from the table (each page summarizes the information for each client). I have VBA code all set that can filter each client and print it to PDF (using ScanSoft), however, my issue is that it prints/saves it using the same name as the original file. In the end, I will need a separate file or report for each client. I am looking for a better and more efficient way of doing so rather than... -
I have used Web queries in the past and I tried with this but it tells me that the "session expired". I haven't tried logging in through the Web Query window because there are different pop-ups that you will need to get open when logging in so I figured that because of that issue, web queries wouldn't workLeave a comment:
-
Yes because it's a secure website so I wouldn't be able to access it from just entering the URLLeave a comment:
-
Well, the website will already be open since I'll be logged in and if I put the URL in the code then it will give me a "session expired" message. There is no way to switch windows to copy the data and then come back to paste it?Leave a comment:
-
Great!! Is it possible to change the constant URL to activating the open window with a specific title? I ask because the website is based off of several logins and if I try to retrieve it another way, the session will time out.Leave a comment:
-
Yes, the error is on #9. I just went searching and saw the same thing, but I was having trouble changing the registryLeave a comment:
-
-
-
How to Copy Data From Website to Excel
Hi,
I'm relatively new to VBA but I am trying to copy data from a website (this website is currently running and will be the same) and paste to defined sheet in Excel. Below is the code that I have thus far, however, I am receiving an error "Method 'ExecWB' of object 'IWebBrowser2' failed".
...Code:Public Sub csi() Dim appIE As InternetExplorer Dim xlApp As Excel.Application Dim wsData As Worksheet
-
Export from Access to Excel and Run Macro already saved
I am new to VBA writing so bear with me here. I have been searching the web but I keep finding answers in pieces which is more confusing!
What I am trying to do is export a table from Access to Excel and run a macro (it's a formatting macro). My issue is that when Access exports the table, it resaves it and I lose the macro (The spreadsheet will be accessible to anyone so I can't just save it in the Personal workbook). When I try...Last edited by Stewart Ross; Aug 14 '10, 10:28 AM. Reason: Applied the [code][/code] tags to the VBA sub
No activity results to display
Show More
Leave a comment: