Search results

Thanks Modest, any input is greatfully recieved. I still need to find out how to establich how many records are returned and store it in a variable.

Bingo, cheers mate. I really need to learn what I'm doing :)

Thanks Doc Man, appreciate it.

This is driving me mental!! I'm trying to find the last record in a database so I can increment the next record by 1. I use the code rs.MoveLast but it only moves to the second last one and doesn't seem to see that there's another one after it. What am I doing wrong? Please help for the sake of...

Is it possible to run an update query which is part of another database? I have an update query that I would like to run but it's in a different database than the current one. I know I can import queries etc but I just need to run it as it updates tables in that database. I don't think I'm...

Anyone Can anyone tell me what's wrong with the sql statement? Is this actually possible or not?

Speed issue Thanks for the reply. The reason I'm doing it like this is because I'll have a small number of people across europe using this and it's really slow (unusable) if I leave everything on the L drive. Hence moving the copies to the C drive to refer to, before updating the L drive with...

Hi, I'm new to this Access ,SQL and VBA world so would appreciate some help. I have a database currently sitting on a shared drive, and I am accessing it from a local version on my c drive. I need to create a table on startup that takes data from the main database for use on the local version...