Search results

I'm trying to select the most recent record in a query. I can't use all the Group By functions, or max, first etc because the rows have different information in the columns which seems to negate this function - in other words Access can't collapse the rows effectively because the information...

Yes, I'd considered that and it may be the route that I have to go. There are some graphical elements in the report which are useful and I'd like to retain, but I may choose to forego that in favour of putting it in a form.

Sadly I'm only on 2003! I think I may have to open and close to refresh. :(

I have a database which I keep open all day - it monitors parcels available for picking and despatch. I've just managed to sort it out so that the data in the tables is refreshed every five minutes, but now I'd like to be able to open the report, leave it open and see changes as they happen. Is...

Thanks for all your help on this Spike. In the end I had to create a user defined fucntion to get round the FileLen problem. It checks the file size, pauses for 5 seconds, then checks again and compares the two results. If they're different then it loops and starts again. Once they're the same...

Thanks Spike, I'll get on the Google for a bit!

I want to record the size of a file and have tracked down plenty of posts which suggest that 'FileLen' is the function that I need. However, whether I use it a query eg: file_len_1: FileLen("C:\test.txt") or in VBA eg: Msgbox FileLen("C:\test.txt") I get the undefined function error. How do...

Test #3 - Try renaming the file whilst it's writing - Disaster. For example, the SOP writes the filename example.csv. I was able to rename this file to example2.csv during the writing process, and the SOP just began writing again to example.csv. Which meant that I had two files at the end of the...

Good thinking - I'll try this next and see what happens.

Test #1 - Open the file for editing and try importing - This did cause a JET error, which was a good thing, as I guess you could handle the error by asking to pause for 30 thirty seconds, then try again. So, moving on to the real life scenario for Test #2... Test #2 - Start the file writing...

Thank you for all of the above responses - rest assured that I'll be tinkering with these during the course of today, so watch out for further posts asking for help! Thanks, Alex

I have an unusual problem relating to the import of files. I need to set up a database to pick up a file every few minutes from a network location. I won't profess to know exactly how to do this yet, but I'm familiar with file imports and am confident that this won't be too trick in itself...