Search results

Currently I have a timer set on a form that runs in VBa and it looks to see if it is 6:00AM and if it is then it runs a DoCmd. I want to change it to run every Monday at 6:00 AM and not everyday at 6:00AM . What do I need to add? This is my current code: Private Sub Form_Timer() If...

I have an On Timer event on my main form set to run every day at 6:00 AM. It runs a macro that generates a report and saves it in PDF in a folder. It works most of the time but for some reason when the customer comes in at 7AM and checks the folder the report is missing. This fails to run maybe...

My query shows all records within a date range and other criteria. See below. Currently it list each serial number (machine) on a separate line and then shows downtime for that incident and it also shows availability by percentage based off of coverage hours. Example if serial number 123 has...

Excel 2003 I have a macro that opens a CSV file and removes a few columns and rows and then saves the new file as an .XLS . At least that is what I want it to do. It continues to fail on the save part of the macro. If I run this macro on a PC with excel 2013 it works fine. And I can take a...

I have a table that has seven fields . each field is the name of the day of the week starting with Sunday. Each field has a different value of time covered. Example , Sunday has 8 hours , Monday - Thursday has 24 and the rest of the days have 10 hours. I need to get a result in a query of...

I am trying to use DCount in a query as an expression to return a value of a count in a table. My table name is SerialTest and the field name is ModelID. My table has three fields, SerialID, Serial Number and ModelID. The SerialID is the primary key , the Serial Number is a field that the...

I have a form with several tables. One table (SerialTest) has a field (SerialNumber) that the operators select a serial number from a list. I need to check another field (Serial_Number) on a different table (OpenAlert) to make sure that the serial number is not in that field. If it is in the...

I have a field in a query that shows amount of hours a site is covered. This field name is Coverage hours and it changes depending on the number of work days in a month. This part is working correctly but some times addtional hours may be requested by the customer. I want to add a another field...

MS Office 2003 I have 7 queries that I use to export data to one excel workbook. Inside the workbook are 7 worksheets, one for each query. I have it working but I dont know how to save the exports steps like I did in AC2010. I export the data by right clicking on each query and select export...

I have a query that has a field that reads DateReceived By Month: Format$([Workorders].[DateReceived],'mmmm yyyy') The criteria line is Like "*" & [Enter Month & Year (Leave Blank for all)] & "*" And this works when I run the query. If I enter october 2013 it shows only records for this date...