Search results

There are 3 procedures named "Private Sub print_Click()" in the forms' modue. 2 are the first 2 procedures in the forms module and the other is the last procedure (bottom of module page). 1 of these is the correct procedure and the other 2 have been "orphaned" from other attempts to use the...

Just import the one offending form into a new empty database the zip it up and attach it. Or ... copy and paste all the code in the offending forms' module in a reply for us to see. RDH

Depends on the version of Access you are using .... In Access 97 got to Tools/Options in main menu. Choose "Module" tab ... change "Tab Width" to 2. If using Access 2000/2002 go to VBA Code Window. Choose "Tools/Options" in the VBA Window. Choose the "Editor" tab ... change "Tab Width" to 2...

The form named "Form3" must be open when the value is referenced ..... I don't know why you are using the "On Click" event of a label to do this .. but maybe this will give you direction. You may instead want to use the Open Args of the DoCmd.OpenForm method to do this. In the code that opens...

If the form is bound to a query or table then clearing the data will clear the record .... Is this what you want to do ??? If .. Yes ... then use the "Undo" method to clear the record. If you just want to go to a new record .. execute: DoCmd.GoToRecord , , acNewRec HTH RDH

That error means you have more than one Sub Procedure in the forms' module that has the same name (Ambiguous) .... Search the forms' module and locate the correct one and delete any others that have the same name. HTH RDH

If "x" and "y" are fields in the table then try: Between Date() And DateAdd("d",[x]*[y],Date()) HTH RDH

You need to validate using the Before Update event of the control .... You then use the "Cancel" argument of that event to stop the control from loosing focus. HTH RDH

Follow the link below for complete instructions to backup the backend file from the frontend. BackUp BackEnd Database (Split DB only) HTH RDH

Here is a simple example that includes the code I posted. It only opens and close the CD drawer.

Here is a free utility that you can remotely set the property. I wrote this several years ago. Here is the Access 97 version: ByPass Shift Key Utility 97 Here is the Access 2000/2002 version: ByPass Shift Key Utility 2000/2002 Trick is do not allow access to this app to anyone but you...

Strange .... I don't know why you are getting the error .. but maybe this sample on creating navigation buttons will help you. Navigation Buttons Example HTH RDH

Use: DoCmd.RunCommand acCmdPrint This will open the Print Dialog Box. If the Report is to be sent directly to the printer and you want the Print Dialog Box to open ... go to the location below for instructions: Make Print Dialog Box appear when printing a Report HTH RDH

Create a small sample and add the code ... if does not work .. attach a zipped copy for us to check and see if if works on other machines. HTH RDH

Use these API calls to do this: Private Declare Function mciSendString Lib "Winmm.dll" Alias "mciSendStringA" _ (ByVal lpstrCommand As String, ByVal lpstrReturnString As String, _ ByVal uReturnLength As Long, ByVal hwndCallback As Long) As Long Public Sub SetCDState(pbState As Boolean) If...

This should be a simple "field expression" in your query to calculate the needed result: Price: Format([CostField]+([CostField]*[MarkupField]),"$#,##0.00") But .... do not store this result .. calculate the result dynamically when needed. HTH RDH

LOL ... I agree. You never know why someone alters these types of things ... sometime alterations improve an app and sometime they just create problems. But that "Blue" form really looks terrible ... LOL I haven't looked to see if any code had been altered or added and don't intend to ... I...

The examples posted was originally authored by me although all have been altered for some reason or other. If you open each of the examples and click on File/Database Properties .... it will show "me" as the Author .. except for the "Bypass Commander" thing that is an obvious copy of my...

If you would use the "Execute" method to execute your queries ... you would not receive the confimation messages. You can find informtion on this method in Access help files. HTH RDH

What Pat was trying to say is that you can have "many customers with many orders" ... this means you need a "many to many" relationship between the two tables. Access does not directly support "many to many" relationships so to get by this ... you need a "Junction Table" to place between the...