Recent content by simonc1978

Update: I think I've found a solution. Will see if it works...

I have a macro that contains a few ExportWithFormatting commands. What I'd like to do is change the output path so that it doesn't reference a particular drive letter but chooses the current directory that the database is in. So instead of saying H:\{foldername}\{filename.xls} I'd like it to say...

Thanks, I used the latter option... worked perfectly.

OK, here's hoping someone can help me out... I have a form called Control Panel which opens up when I open my database. I also have a query called MaxDate which return the latest date from a table called tblSessions. How can I change the form so that it displays the result of the query MaxDate...