User Profile

Collapse

Profile Sidebar

Collapse
epifinygirl
epifinygirl
Last Activity: Nov 2 '11, 07:00 PM
Joined: Aug 13 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • epifinygirl
    replied to Copy Report with Filter
    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.
    See more | Go to post

    Leave a comment:


  • epifinygirl
    replied to Copy Report with Filter
    Could that work while using a table as the reference for the client ID's in the loop?
    See more | Go to post

    Leave a comment:


  • epifinygirl
    started a topic Copy Report with Filter

    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
    ...
    See more | Go to post

  • epifinygirl
    replied to Filter Loop with OpenReport
    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?
    See more | Go to post

    Leave a comment:


  • epifinygirl
    replied to Filter Loop with OpenReport
    I# is a number and the column in [Temp Table] is called I# as well.
    See more | Go to post

    Leave a comment:


  • epifinygirl
    replied to Filter Loop with OpenReport
    Neopa - I'm not quite sure I follow. Can you post an example?
    See more | Go to post

    Leave a comment:


  • epifinygirl
    replied to Filter Loop with OpenReport
    When I enter your code, I am now getting a "Type Mismatch" error
    See more | Go to post

    Leave a comment:


  • epifinygirl
    started a topic Filter Loop with OpenReport

    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)
    ...
    See more | Go to post

  • epifinygirl
    replied to Access Filter Report with Field Name
    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.
    See more | Go to post

    Leave a comment:


  • epifinygirl
    started a topic Access Filter Report with Field Name

    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...
    See more | Go to post

  • 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 work
    See more | Go to post

    Leave a comment:


  • Yes because it's a secure website so I wouldn't be able to access it from just entering the URL
    See more | Go to post

    Leave 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?
    See more | Go to post

    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.
    See more | Go to post

    Leave a comment:


  • epifinygirl
    replied to How to Copy Data From Website to Excel
    Yes, the error is on #9. I just went searching and saw the same thing, but I was having trouble changing the registry
    See more | Go to post

    Leave a comment:


  • epifinygirl
    replied to How to Copy Data From Website to Excel
    No, I get the same error as above on the same line (#9).
    See more | Go to post

    Leave a comment:


  • epifinygirl
    replied to How to Copy Data From Website to Excel
    Yes, that reference has been set
    See more | Go to post

    Leave a comment:


  • epifinygirl
    started a topic How to Copy Data From Website to Excel

    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
    ...
    See more | Go to post

  • 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...
    See more | Go to post
    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
Working...