Search results

  1. T

    DoCmd.OutputTo - Stop excel form opening

    I am saving an access table to excel, which is working however the excel opens also and I do not want it do. This is my vba DoCmd.OutputTo acOutputTable, "tbl_reduction", "ExcelWorkbook(*.xlsx)", RptName, True, "", , acExportQualityPrint Beep MsgBox """File has successfully been...
  2. T

    prevent datasheet from opening in an Openquery marco

    I have multiple OpenQuery actions in a macro. I have SetWarning = no, however the datasheets are staying opened. I just want the queries to run without the user having so close each one. I have attached a snapshot of the macro.
  3. T

    Passing Datetime stamp to file name

    I am using a savedexport in a macro. how do I pass a datetime stamp to the file name. I created the savedexport because I want a pipe delimited txt file.
  4. T

    Recordsets - one access report to multiple files

    I have parameter form that ask for state and begining date. on click it runs a query and creates a report by state that has multiple pages.. I want to create a separate pdf file for is page (which would be by delegate_name). This is the coding I have so far and am gettting the error '424'...
  5. T

    Hello

    Hello from Florida, usa. I have not used Access in about 9 yrs and recently took a job that is having me work with Access Databalse. It has been a challenge but starting to look familiar to me again! :)
Back
Top Bottom