Search results

  1. P

    Error 13 Type Mismatch

    Hi, I'm still on my quest to enter a file name for a file I will later output to my computer. This is my current test code (whithout the inputbox segment) - Function CopyQuearytoSdriveFolder() Dim MyValue As String MyValue = "mm_dd_yyyyQTMsQuery.xls" DoCmd.OutputTo "acOutputQuery"...
  2. P

    Copy a report and name the copy using an input box

    I need to run a standard report, but need to save the new results with a date-specified name. Can I use VB to request the user to enter a new name and use that name for the copied report?
  3. P

    Freeze data in a query

    I believe that whenever I open a query, the query refreshes, thus giving me new data. Can I stop a query from refreshing at open so that the data I've used in executive reports are always available?
  4. P

    Check for active records in a table

    I need to compare records in a table to a table of active records so that I can only choose actiive records from the initial table. Any help would be greatly appreciated!
  5. P

    New User

    Just joined and am looking forward to getting and sharing information.
Back
Top Bottom