Search results

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...

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...