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...

Thanks for the suggestions but this does not answer my question of why the way that I have it set up fails to run sometimes. I have this installed in several locations and this is the way I was told to set it up from people on this forum. I cant go back and change it at this point. I was really...

It doesn't have to be 6 AM exactly. Just anytime after midnight so it will be available by 7 AM the next morning. How would I do this? How would I have Access open and run a macro in the DB that is already open?

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...

I will need to remove customer data out and then I will post up something later. Thanks RK

Bare with me , I am not that great in Access but ,with the help from folks here I am getting better. I tried using group by in my query under the Serial number field , but that requires me to choose something for the rest of the fields in the query and nothing I selected would work. How would I...

Sorry, typo, "I meant to say there are seven"

I run a report /Chart using this query and if I select GroupBy in the row source for the percentage I end up with two or more bars for each serial number depending on how many were found in the query. See attached GroupBy and look for serial number 6-6\156 there is one for .5 and one for .965...

7, there were seven different serial numbers returned.

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...

That worked as I wanted it to. Actually, I had concerns that the message would pop up on ANY record if there were duplicates and not just any other than the first one. But it looks like it is throwing the message only on duplicate records and not the first, which is GREAT!. By the way, I do...

The same code is in the serial number box which warns the person entering the call when there is a record already open. The warning is just a little different than the Date Finished box message.

I removed a lot of stuff from my DB just so that I can upload it. It is attached. Use the form Workorders by Customer. Then click on workorder button. Check out my code under the Date_Finished Got Focus. When you click on Date Finished it runs this code and compares the serial number...

It is full of Customer data that I cannot release. I will try to import a few of the forms and tables into a new DB and upload that.

So this code works with one exception. I use it in a field under Got Focus and it pops up when your on the same ticket. I need to add a statement to my code to prevent this from running if the field named WorkorderId on this form (Workorders) matches the same field WorkordersID on the same...

Paul, I found this thread while researching my next challenge. In the link you provided , there is another link for including all records and that is what I need to use. I want to double click on a certain record in one form named "OpenAlert" and there is a field named WorkorderID in each...

That worked great. Thanks

Paul, I am open to suggestions , so I am willing to make changes as needed. So I made a new table named Cover , then I made two fields DayOfWeek and Hours. I entered Sunday-Saturday under DayOfWeek and the appropriate hours for each day under hours field. So how would I get the results...

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...