Recent content by makewise

Ok, I need some help. When I run through the routine I am trying to automate manually, I get no errors on my import. When I automate the routine using a macro, I am getting an error table with errors. My macro looks like this: Private Sub cmdImport_Click() On Error GoTo Err_cmdImport_Click...

Is there a way to prompt a user for the new table name using the CopyObject in a macro. We import data every day and need a backup of the table for auditing purposes. We rename the table when copying it using the date as the table name. Thanks!

Well, I tried using DateSerial and could not get it to work, but you sent me in the right direction! I used: Between DateValue("1/1/" & Year([Forms]![frmReportDateRange]![txtBeginDate])) And [Forms]![frmReportDateRange]![txtEndDate] And it worked. (IT alos helped that I fixed a field name that...

I am using this as a criteria for a Query that is pulling the 2 dates from a form - Report Date Range. The reason I am trying to do this is I have a cumulative report that needs to run for the fiscal year (1/1/xx to 12/31/xx). It will always use 1/1/xx as the base date for the range. I am trying...