Recent content by KellySmith

Woohoo! It worked! Thank you for your help, Louise. After some messing around, this is what I came up with. It may not be elegant, but it works. Private Sub cmd_Save_Defect_Report_Click() On Error GoTo Err_cmd_Save_Defect_Report_Click Dim stDocName As String Dim myDate As...

My application generates several different reports which must be archived for historical purposes. Currently I create the reports manually and save each one with the following format: 012701ReportName.doc (or .rtf, .xls etc.) I have a command button on my form which will save my report, but...

Hi Chris, Thanks for your prompt response. I have already tried what you mention however, and have not been able to make it work. This is the latest piece of code I've tried to use: 'What day is the next audit scheduled for? Dim newdate As Date Next_Audit.Text = DateAdd(m, 1...

Hi, I am working in Access '97. I have several forms and reports, which have 2 date fields. The first field (a textbox - Audit_Date) pulls a date from the database. The second field (Next_Audit) uses the following: =DateAdd("m",1,Audit_Date) to automatically schedule the next audit one...

Hi Pat, Thanks for the information. You just solved a problem I've been wrestling with since yesteday!