Search results

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.

A SELECT query will not affect the data in the table it will merely show the data. An APPEND, UPDATE or DELETE query will affect the data, which meets the query criteria. It sounds as if you have run a DELETE query and as far as I am aware there is no way to get that data back unless you have a...

The database is looking pretty good. Who is going to be using the database? If it is going to be several users you may not want them to have the opportunity to view the database window, as this will allow them access to change forms, etc. Are you also going to have some reports? i.e. being...

Try using code rather than a macro. On the On Open Event of the form that opens after pressing the cmd button use Private Sub Form_Open(Cancel As Integer) Me.NameOfLocationTextbox=Forms!NameOfOtherForm!NameOfLocationTextbox Me.NameOfIDTextbox=Forms!NameOfOtherForm!NameOfIDTextbox End Sub HTH

By comment do you mean annotate? If so just insert ' before the annotation and Access will ignore it. e.g. 'This code turns off warning messages DoCmd.Set Warnings False HTH

Use the dateAdd function in a query. The following code will show all the records older than 2 weeks. <DateAdd("m",-2,Date()) HTH