Search results

I will give that a try. Thanks!

I have an access db that runs an autoexec macro upon opening. The macro imports a csv file into a table, opens a report, then prints the report to the set printer for said report. Currently for each location this db is being used, the db is exactly the same but the printer for the report is...

I edited my above comment to show what each line in my code does

Function AutoExec() On Error GoTo AutoExec_Err DoCmd.TransferText acImportDelim, "DynamicsPartsLabels Import Specification1", "DynamicsPartsLabels", "\\~\DynamicsPartsLabels.csv", True, "" //Imports data from csv into table DoCmd.OpenReport "Labels LabelTemplate", acViewReport, "", ""...

I have tried adding a step to "Quit Access" after the other steps, but the "Quit Access" step causes MS Access to exit without showing the user the print dialog screen.

I have made a macro in Access that import the data from a CSV into a table that is connected to a report. It then deletes the records in the table (to clear it out), then it brings up the print dialog screen so the user can select a printer to print the report onto. After the user selects the...

I would hardcode the interval but most records have a different interval number, that is why I am trying to set the ActualNext date = Date() + [Tasks].[Frequency] using the Frequency field from a separate table.

Hello, I have two tables: Records, and Tasks. I am trying to make an append query that adds a new record to the Records table where the dates of the records in the Record table equals today. I am adding a new record with most of the same information of the selected record and appending two...

Hello, I have a table that has three fields. ActualNext(DateTime), CompletedDate(DateTime), OnTime(Calculated : either 1 for being on time or 0 for being late) The expression that I am using in the OnTime field is : IIF([CompletedDate]<=[ActualNext],"1","0") This is working for some of the...

I have a query that is getting a count of all records of a certain field from another query. I am trying to only count the number of records where that field is equal to a certain value. Example : [OnTime] 1 1 1 0 1 0 0 1 Count(8 records for that table) Below is the sql that gets the count...