Recent content by pnjones

Function CurrentDBDir() As String Dim strDBPath As String Dim strDBFile As String strDBPath = CurrentDb.Name strDBFile = Dir(strDBPath) CurrentDBDir = Left(strDBPath, Len(strDBPath) - Len(strDBFile)) End Function

Why do you have the variables I and S remmed out at the top they will have no value and the resulting file will not exist

I have a invoice report which totals the invoice value into the footer ensuring it is always at the end of the page. This works fine in 97 and 2000 , however when i open the database in access 2003 and print a range of invoices the page footer is displaying the values from the next page footer...

Mal formed rtf I have had the same issue with a 97 application, the user had office 2000 sbe and i had the program deployed using access runtime. The system worked fine until XP was setup on a pc with SP2 i have tried many options but have not been able to fix the problem. I notice that a...