Search results

Thank you - sorry I must have missed your post. I needed to use the expiration date not the completed date but I added the SOP table to the query and it looks like this might be working! So if i have it correct now I create a second query to use this information and select only those that...

I figured out my problem. This query results in all training completed - the entire database. If I add <Date() as the criteria for the ExpDate I get all of the records for the training all employees that are before the current date BUT I need to filter this somehow so that the results are...

Yeah I get that - I will look at this again on Monday and start with a fresh query - the one I am using must be buggered. Will post back. Pam - thanks for the MAX code

I tried this but I am getting "you tried to execute a query that does not include the specified expression "SOP Number" as part of an aggregate function". Any thoughts?

Yes I have that report also an will be fixing that next. I will look up MAX and see if I can figure it out. Thanks

Sorry - I was wrong in that! I have a report that shows the current date and I need the report to show only the SOPs that have expired as of the date on the report.

My datebase is tracking employee training, Each employee is required to complete the training every 12 months (for example) The database tracks all of the info about the employee and I have a table that keeps the records of all training completed dates for all employees for all SOP numbers...

I am sure that I could but the nodata was easy!

Yep - I was putting the nodata on the form not the report. I added aDoCmd.Close acReport, "Report" to close the report and return to the form. Again I really appreciate your help

I thought that would work but the query is based on a date range from the form so I can't use the DateField on the form to compare to that in the query because there may not be a date that matches either the start or end date on the form. Going to try the nodata again - I think I had it on the...

This is exactly what I was looking for - thank you for providing the code to work with! Sue

Thanks all - just got back in - will check these suggestions and let you know what I get to work

I have a form that allows the user to select a date range, then click a button to open a report that shows the results based on the user input. I need to add VBA to check for no results in the query/report and give a message box telling there are no records available. I tried adding code to...

Thanks for your help - got this working

I know that there is a way to put the GetFolderFuncton somewhere so that it is available and can be referenced on all reports so it does not have to be included on each report but I can't remember where to put it. Module? Macro?

Sorry - I think I found the solution Here is the final excel sub as I have it now and it seems to be working Private Sub ExportExcel_Click() Dim strPath As String Dim strGoToPath As String strPath = GetFolderName() 'Debug.Print strPath strGoToPath = strPath & "\" & "SOP30DayRPT - " &...

Found a little time to poke a this. The Dim strPath As String Dim strGoToPath As String strPath = GetFolderName() Debug.Print strPath strGoToPath = "strPath\SOP30DayRPT - " & Format(Date, "mmddyyyy") & ".xls" Debug.Print strGoToPath strPath in the debug does show the correct path but I am...

Thanks will look at this when I get back - I copied the code from a website so it is the way it came to me. Appreciate the comment!

Excellent help - I am leaving for the day so will be back to this on Wednesday. Will research how to do this, nice to know what I need to look up. Have a great evening and thanks for hanging in there with me.

Yeah in testing it I am finding the path is not where I think it is! It is in a directory one level up. Dang it - Will see what I can find on outputto command, but can you give me a hint on how to check the path and file name. The Excel code has a export name within it (or at least that is...