Results 1 to 4 of 4

Run-time error '3044'

  1. #1
    niacin is offline Novice
    Windows Vista Access 2003
    Join Date
    Mar 2012
    Posts
    2

    Run-time error '3044'

    Hi,

    When I run the following code I get a Run-time error '3044':

    Private Sub Command0_Click()
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "qry_cost_01_update_month", acViewNormal, acEdit
    DoCmd.OpenQuery "qry_cost_02_update_WL_categories", acViewNormal, acEdit
    DoCmd.OpenQuery "qry_cost_03_update_wouldbe_W_category", acViewNormal, acEdit
    DoCmd.OpenQuery "qry_cost_04_update_invoice_W_category", acViewNormal, acEdit
    DoCmd.OpenQuery "qry_cost_05_wouldbe_cost", acViewNormal, acEdit
    DoCmd.Close acQuery, "qry_cost_05_wouldbe_cost"
    DoCmd.OpenQuery "qry_cost_06_invoice_cost", acViewNormal, acEdit
    DoCmd.Close acQuery, "qry_cost_06_invoice_cost"
    DoCmd.OpenQuery "qry_cost_07_update_savings_master", acViewNormal, acEdit
    DoCmd.OpenQuery "qry_cost_08_breanne_report", acViewNormal, acEdit
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_cost_08_breanne_report", "U:\Logistics Savings\Savings", True
    DoCmd.SetWarnings True
    End Sub

    In the debugger, the bolded line is highlighted. "Logistics Savings" is a folder in my U Drive. If I make the path "U:\Logistics Savings" the spreadsheet exports directly to my U Drive with the name "Logistics Savings.xls". I need to export the spreadsheet to my U Drive, Logistics Savings folder, and name the spreadsheet "Savings.xls".

  2. #2
    Jester0001 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Location
    Indiana
    Posts
    69
    Does it save correctly if you substitute ".xls" or ".xlsx" at the end of the file path? Like this:

    Code:
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_cost_08_breanne_report", "U:\Logistics Savings\Savings.xls", True
    
    or
    
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_cost_08_breanne_report", "U:\Logistics Savings\Savings.xlsx", True

  3. #3
    niacin is offline Novice
    Windows Vista Access 2003
    Join Date
    Mar 2012
    Posts
    2
    Negative, if I put .xls or .xlsx, it still does not save correctly.

  4. #4
    Jester0001 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Location
    Indiana
    Posts
    69
    I know this sounds simple, but double-check to ensure that there is a folder on your U:\ drive called "U:\Logistics Savings". Be sure the the spelling is 100% correct, along with a space between 'Logistics' and 'Savings' in the folder name.

    I tried your code (using Win7 and Access 2010) using my C:\ drive, and it worked (see image). I'm not too sure about external or networked drives.
    Click image for larger version. 

Name:	Logistics Savings 1.jpg 
Views:	7 
Size:	110.6 KB 
ID:	6962

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 03-27-2012, 12:40 PM
  2. Run-Time Error 3044 - Invalid Path?
    By KrenzyRyan in forum Import/Export Data
    Replies: 8
    Last Post: 01-19-2011, 08:03 AM
  3. Replies: 2
    Last Post: 12-23-2010, 07:11 AM
  4. Replies: 2
    Last Post: 12-02-2010, 12:35 AM
  5. Run time error
    By vaikz in forum Import/Export Data
    Replies: 1
    Last Post: 02-18-2010, 09:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums