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

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

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

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