Search results

Hi, Many apologies, we're on access 2010. However that sounds like exactly what I was looking for. I shall give it a shot and report back if I have any issues. Many Thanks

Hi there, Our local radio station has a [relatively simple but complex for me!] database that records which user plays which track and when, manually entered. I'm looking into making a query that can tell them the top 5 most played tracks this month. So basically I need a query that returns...

Ok I'll give that a go thanks. And thanks for all your help so far - much appreciated. If you're free Friday 4pm-6pm be sure to tune into radionovanewport.co.uk :) Adam

Success! After having a bit of a fiddle, I have another database which, when opens, automatically runs that and exports the file perfectly and then closes itself :D However, now I have to work out how to open the database at midnight automatically. Hmmmmmm??

Sure: Behind the button I have Private Sub Command0_Click() DoCmd.OutputTo acOutputReport, "TodayReport", "PDFFormat(*.pdf)", strPathAndFile = "C:\Users\Adam\Desktop\Test.pdf", True, acExportQualityScreen End Sub and as a module named AutoExec I have Option Compare Database...

You've lost me sorry :( I took the combination of your code and put it into a class module but nothing happened. So I put the code behind a button and clicked it - nothing. I then took the date bit out and just gave it a fixed file name and all it does it output a file called 0 to the specified...

Great thanks :) How do I get this to run by itself at midnight every night and dynamically change the file name?

Hi there, before I start please note I have little/no VBA experience so please be kind Relatively speaking, I've got a pretty simple database. The presenters at our community radio station fill out a form of what song they play and this (along with the system time) is stored in a table. I...