Search results for query: *

Can you not call the BeforeClose Sub before you run the close command? Call Workbook_BeforeClose(True) ActiceWorkbook.Close SaveChanges:=True

Skip and combo, Thank you very much for your time. I really appreciate your help. I look forward to learning more and helping others.

combo, Great minds thing alike! I've been stepping through my code using break points. I love them its the fastest way I've found to debug my code. skip, I tried defining the "RptAvg" to a varient, then I tried making both the RptAvg and ReportAverage Double. Neither worked. What I did was...

fnj6, I have to agree with MajP. your backend database should be designed in such as way to make YOUR life as a programmer easier. You design your forms (frontend) to make your user's life easier. You can also reuse the same form for different views for different users, by redefining the...

First, Thank you very much for responding so quickly! Next, I apologize I should have explained in better detail. 1. I am programming for MS Access 2010. 2. For the reports I am averaging there are a predetermined value for each of the letters. (I did not define the values, they were...

Greeting all, Thank you all very much for taking the time to look at this question. BACKGROUND: I am new to VBA but, not to programming. I am working on a way of tracking and evaluating fitness reports. The fitness reports have 14 different points of evaluations. Each point is given a score...