Search results

You can use a third-party form rescaling module or add-in to resize your forms for you, or write the code yourself, but it is quite involved. A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm...

Try putting a DoCmd.Maximize in your form OnActivate event procedure, instead of your OnOpen event procedure. Hope this helps, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

To include an attachment with your e-mail, you need to use automation because SendObject won't do this. Here's how to use automation to send an e-mail attachment: http://support.microsoft.com/support/kb/articles/q209/9/48.asp Hope this helps, Peter De Baets Peter's Software - MS Access Tools...

Here are some form rescaling solutions: 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 Handbook has form resizing code...

First, use dim dbs as DAO.database You'll have to do the same with recordset objects. dim rst as DAO.recordset Then, make sure that "Microsoft DAO 3.x Object Library" is in your references list. Hope this helps, Peter De Baets Peter's Software - MS Access Shareware and Freeware...

You can use the control properties "Tab Stop", and "Tab Index" to control how the cursor skips from field to field. If you set Tab Stop to No, the cursor will not stop on that control. Tab Index is the tab stop order, so after creating the form, it's usually a good idea to go back and make...

Try putting a "DoCmd.Restore" in your form OnActivate event procedure. Hope this helps, Peter De Baets Peter's Software - MS Access tools for developers http://www.peterssoftware.com

Here you go: http://www.mvps.org/access/strings/str0005.htm http://www.mvps.org/access/strings/str0008.htm Hope this helps, Peter De Baets Peter's Software - MS Access tools http://www.peterssoftware.com

A "DoCmd.Restore" in your form OnOpen, or OnActivate event procedure may help. Peter De Baets Peter's Software - MS Access Shareware and Freeware http://www.peterssoftware.com

I agree with Rich that putting the code in the OnClose event of a hidden form is a good solution, but it's not perfect because the user may close the database window and leave Access open. In this case, the code would execute. Just FYI. Peter De Baets Peter's Software - MS Access tools...

I don't think he's sending the code anymore. Here's some more information about form rescaling: 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...

You can use the TSI SOON utility to close a database, compact it, and then open it again: http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8 Hope this helps, -- Peter De Baets Peter's Software - MS Access Tools - http://www.peterssoftware.com

I use instyler smartsetup to make install files: http://www.instyler.com Peter De Baets Peter's Software - MS Access tools http://www.peterssoftware.com

My Window Manipulation Examples database at http://www.peterssoftware.com/winmanip.htm can help you with changing the form position. Hope this helps, Peter De baets Peter's Software - MS Access Tools for developers http://www.peterssoftware.com

You can use a third-party form rescaling module or add-in to do this for you, or write the code yourself, but it is quite involved. 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...

Try setting the editmessage parameter to "False". Ex.: DoCmd.SendObject ,,,"ToJohn@doe.com",,,"Subject","Message",False Hope this helps, Peter De Baets Peter's Software - MS Access tools for developers http://www.peterssoftware.com

I'm curious about this popular code! Please send me a copy, too! pddxxx@yahoo.com

Here's something that might help: In Access 2000 you can check the "Compact on close" option. Also... "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...

Here's something 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's something that might help: You can use the TSI SOON utility to close a database, compact it, and then (optionally) open it again: http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8 Here's some more information about reducing database size...