Recent content by daveUK

Can you attach the database and I'll have a look.

x0reset gave you the correct advice. I have added an example database to show you how to do this. Once you've seen the example you should press the shift key when starting to database so you can look at the form properties.

Darno, Check out this example http://www.rogersaccesslibrary.com/download3.asp?SampleName=BackUpWithCompact.mdb HTH

It's OK, I've managed to get this sorted. For anyone else with the problem, you need to select Tools - Macro - Security and set the level to Low. Bloody annoying if you ask me as most databases will have some type of macros. :mad:

Hi, I'm using Windows 2K SP4 and have just installed Office 2003. Everytime I open Access I get a message asking if I want to block unsafe expressions (presumably macros). How can I turn this off? BTW I've downloaded all of the security updates, which are recommended by MS. Thanks

I've uploaded an example in Access 2000. The first form to load should be the 'startupform', which will check if the location of the backend database has changed. If it has, then the 'pathform' will allow the user to browse to the backend and re-link the database. In this case once the...

Do you mean linking to the backend of a database, which may change location from time to time?

Sorry Pat, I don't quite understand what you mean. If I move the page break to the header, then the data in the Details section will be displayed on the page after the name of the office.

I have a report, which lists the staff in several offices throughout the UK (the user can select which offices to include). Users want each office to be on a seperate page, so I have put a page break in the footer of the office group. I have also put a label in the footer, which displays the...

Have a look at http://www.rogersaccesslibrary.com/TableOfContents3.asp there are several examples of how to create crosstab queries and reports. HTH

Go into the code behind one of your forms. Select Tools and References from the menu bar at the top of the screen. There will be a long list of items with tick-boxes next to them. The ones which are ticked will be at the top of the list. If a reference is missing it will be ticked and say the...

Check the references, you may find that on your machine there is a reference missing. HTH

In Access try Tools - AutoCorrect Options and you can then delete (R) from the list.

You need to open Access without having a database open in order for the 'Make MDE File' to be enabled.

ravynfaire - If you mean you created a SELECT query and then deleted records from the results, then yes you will be able to delete data. The way that I read crystalda726's question was that he/she had created a query, which deleted the data, but maybe I mis-read the question.