Recent content by rob0r

You sir are a legend! Brilliant advice and it works perfectly! Thank you very much. Rob

Hello, I’m basically attempting to lookup values from one table (from multiple records) and insert them into one record in another table. I’ve attempted to do this with dlookups and dmaxs (which pick up exactly what I want) and using an SQL statement to insert them into another table. My code...

Thanks for the information, could you be a bit more specific as to how I would do this? I have a working knowledge of various parts of VBA, but I haven't really touched recordsets before. Many thanks to anyone who can help me.

Hello, I’m currently trying to create a function that will look at each record from a single column database table and the record will be copied and distributed into another table depending on the content. I probably haven’t explained myself very well so I’ll demonstrate. The single column...

Hello, I'm trying to run some code that references the last entry made in a seperate table to the one that the form is assigned to. The form writes to a table called "log" and the seperate table is "Userlog". Userlog contains a time and date that I want to use in my records that the form...

Oh, just for the record, the specification was setup using the .txt file since the import wizard didn't recognise the .log file, hence why I think this might not be fixable.

Hello, I was wondering if anyone could help me with a problem I've been having, and one I'm not sure can be fixed. I have a machine that produces user activity logs that are a flat text file, but with the extension ".log" . The code below will work if I change the extension to .txt, but will...