Search results

The Orders.mdb sample database (comes with Access) has an example of how to do this. You can enter a customer name and all the customer information pops up on the order form. Hope this helps,

Using the combo box wizard, you can select the table that is to supply the data for the control. Open your form in design mode, click the combo box button on the toolbar, then draw the combo box on your form to invoke the wizard. Hope this helps,

Copy one of the functions from the Microsoft article into the Compact A List module, then replace the filecopy statement in the same module with the copyfile() function. Hope this helps,

Here's an example database (with source code) that will backup to a zipfile archive. http://www.peterssoftware.com/cal3.zip One thing you might want to change in it is to use copyfile() instead of the "filecopy" statement. More info...

Have you tried =sum(total1) or =sum(IIf([TYP_CHARGE1]="E",[QTY1]*[UNIT_PRICE1],[hours1]*[Unit_price])) In your form footer section?

Try putting a DoCmd.Restore in your form OnActivate event procedure Hope this helps,

This link should help: http://www.mvps.org/access/strings/str0005.htm ... a more advanced example is here: http://www.mvps.org/access/strings/str0008.htm Hope this helps,

No, you don't have to set CurrentDB to nothing, as far as I know. It's not a variable that you've declared. It's a funciton that returns a database object. Setting the function to Nothing won't do anything (again, as far as I know).

Open Access. Under "New From Template", select "Templates on Microsoft.com", then select "Personal Interests, Community, and Politics", then "Hobbies, Sports, and Collections". Finally, select the template entitled: "VHS video collection database" This should get you started.

There are third-party form scaling solutions available that might help to resolve some of the issues you are having: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm FMS has a sizer module at...

There are third-party form scaling solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm FMS has a sizer module at www.fmsinc.com. The Access Developer's...

There are third-party form scaling solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm FMS has a sizer module at www.fmsinc.com. The Access Developer's...

Try a DoCmd.Maximize in your form's OnActivate event procedure. Hope this helps,

Are you signed on to Access as a member of the Admins group? Are you using the Admin user ID? Are there network permission problems with the folder you are converting from?

Here are some links that might help: "Compact A List" is a free MS Access database that allows you to backup, repair, and compact a saved list of Access database files. It also saves the results of these actions in a table for later viewing, making it suitable for batch or scheduled execution...

Here are some links that might help: To change display settings: http://www.vbapi.com/ref/c/changedisplaysettings.html To scale your forms to fit the user's screen resolution: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site...

We have a tool at our web site that will do something similar. Moe (Mouse Over Effects) is an add-in for Microsoft Access that enhances your forms with intuitive rollover-type effects that react to the presence of the mouse cursor. http://www.peterssoftware.com/moe.htm Hope this helps,

There are third-party form rescaling solutions available that might help: A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm FMS has a sizer module at www.fmsinc.com. The Access Developer's...

Yes, OpenReport should be an option from your switchboard. Open your switchboard and click "Change Switchboard Items". Add a new item, and select OpenReport for the new item's action. Hope this helps,

You are probably having the error because you need to use the RecordsetClone property instead of Recordset. Set rst = subfrm.Recordset Should be: Set rst = subfrm.RecordsetClone But I don't think this will get you exactly what you want. It looks like your code will always delete the first...