Search results

Hi all, everything is cool now and my database now runs great, so thanks for all of your help. My final thing is i want to back up the database and know that I can use the 'Backup' task from the Main menu, but the database is being used by office staff so I'd like to make it automatic. One task...

Hey, brilliant guys, another problem solved.....:):D

I have a some Queries, that modify / delete data in a couple of tables. When I run them in 2007, I get the 'you are about to delete x records'. As these have been used successfully for a while now, I'd like to suppress them for these queries, I know I can turn off the warnings globally through...

Thanks Guys, that's got it all sorted out.

Thanks Guys, Size isn't the problem :) the table holds payment data which is used in all manner of reports. Every year, the club club will write off payments over 2 years old, so the easiest thing is to move this data to a different table. I've added a couple of screen shots, the first 1 is...

I'm trying to do a simple task which is to transfer all data from 1 table to an archive table, based on a specific data field in the table. Is there any easy way of doing this, I have created 3 queries, that selects the data, transfer's it to the new table and then deletes it from the original...