User Profile

ChipStewart · Sep 18 '18, 07:28 PM

Okay . . . Here's what I have now:

Code:

Private Sub Export_Client_Data_Click()

On Error GoTo Err_Export_Client_Click

    Dim stDocName As String
    stDocName = "Export_Client_Data"
    DoCmd.OpenQuery stDocName, acNormal, acEdit    
    DoCmd.OutputTo ObjectType:=acOutputTable, ObjectName:="Client_Data", Outputfile:="c:\Clients\Client Data.xlsx", AutoStart:=True

...

ChipStewart · Aug 24 '18, 06:06 PM

I'm afraid I'm a bit lost here - could you dumb it down? I'm just starting out with this stuff. Any good resources you could recommend to get up to speed fast?

Thanks.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Using DoCmd.OutputTo to Export Query of the Current Record Only