Search results

The larger databse may just need compacting. >Tools>Databse utilities>Compact Databse The larger databse may also have hidden objects. >Tools > Options > Uncheck Hidden objects

If you set the report to print to your default printer in design view, it should print to the default printer on any computer.

Stupid Question: Are you sure it's freezing and not just taking a very long time to run?

Try this link, should do what you require: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q174542

Not sure if this is what you are after but..... If you put the sum calculations on your report in an immediate if. For example: IIF([Enter Date:]>date(),Sum Calculation in here,"") Hope this helps. Look up IIF in Access Help.

Try looking up SendObject in the help in Access. You could try clicking on the search button on this forum, typing something like 'email' and you will see the same question has been asked hundreds of times before.

Try deleting your search button and the code behind it. Redraw it and then put the code back into the on click event. If that doesn't work look up Invalid Outside Procedure in Access help.

I've never used it. But a quick look in the Help section of Access seems to explain everything you should need to know...

Start here. i haven't read it all but it looks like it may be what you need, or at least the start of it: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q290500

To stop Excel from prompting you to save the changes use: APPeXCEL.DisplayAlerts = False Then save your workbook, then: APPeXCEL.DisplayAlerts = True To close Excel use: If Not (APPeXCEL Is Nothing) Then APPeXCEL.Quit End If Set APPeXCEL = Nothing This hopefully helps.

Try looking in the detals section of the GPF/IPF and look error message up on Microsofts wesite. Access may need installing again.

This message appears because you have the Outlook security patch installed on your pc. It may also prevent you from receiving EXE files and various other file types. The only way I know of getting rid of the message is to unistall the patch. Look in Add/Remove programs. You should find it...

docmd.setwarnings = false Put your code in here docmd.setwarnings = true

Shell "Your path name in here" Put the above into the on click event, there are other options for Shell if required.....

Thank you for your answers. I wanted to know if this was an acknowledged bug. I have lots of 'answers' to this but, I just want it to do what it says on the tin! Thank you Microsoft!

Close Form Button [Resolved...ish!] I have disabled the close button on a form, but left the maximise and minimise buttons. If I maximise the form the close button is enabled. Why does Access do this? Is there a way to stop this happening? Thanking You.

Do you mean you want a message box to be displayed stating "Enter Name.", then the user enters their name. Then another one appears saying "Enter Address"? If this is what you want I wouldn't do it this way as you'll get message boxes popping up all over the place, which will/could be very...

In my experience Access and Excel don't get on that well because they both think they know best! But they may just be me. If it needs to be automated, then there is no reason why you can't use a third table. Write the query then have a form with a command button on it. Under this command...

Can you change the field in the all tables to a number? If not you could have a third table. Then append the Excel spreadsheet to this table and have the field set as text.

Not sure if you can, easier to write it in code, at it's most basic level: Dim sFileLocation as string sFileLocation = InputBox("Enter File Location:") DoCmd.TransferText acImportDelim, "Spec Name", "Table Name", sFileLocation The transfertext line would depend on what you were trying to...