Search results

Hi all, As you will probably guess from the rest of this post, I'm a total noob compared to you guys when it comes to Access (2007) but I am able to build a very basic database and run a few queries/understand how joins work etc. Current situation:I currently download ticket data from a...

Hi everyone, I'll try to explain the best I can as I didn't write this SQL code myself, the person who did is no longer here. I have a Union query that is linked into about 10 different excel spreadsheets on our drive and it pulls back only 3 columns of data (Document Number, Date Registered...

Hi all, I'm having trouble running a file that I run weekly, when running the update query I receive error message: "Run-time error '1004': General ODBC Error When I run debug, it fails at the 2nd line of code below: Sheets("CCL").Visible = True...

Hi all, I'm a bit of an Access noob but have managed to build a very simple database. I have a main table which I need to add 4 columns onto the end of, the data for which comes from 4 tables linked to it. Below is how they are linked. Main table------> Table 1 Main table------> Table 2 Main...