Search results

You may have a problem with your library references. Open any module in design mode and click Tools > References. Are any checked libraries in the list "MISSING:"? If so, you must resolve these before continuing. Either remove or fix (click browse and find the library) the missing references. If...

Here's the code to do it: http://www.mvps.org/access/api/api0001.htm Hope this helps, Peter De Baets Peter's Software - MS Access tools for developers - http://www.peterssoftware.com

You may want to consider toggling the subform control visible property from true to false, rather than resizing the subform. You can use the Docmd.runcommand acCmdSizeToFit to size the form window to fit the form. Hope this helps, Peter De Baets Peter's Software - MS Access Tools for...

This may help: http://www.mvps.org/access/api/api0011.htm Regards, Peter De Baets Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

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 included: http://www.amazon.com/exec/obidos/ISBN%3D0782119417/107-8064361-7403703 For more informmation...

Here are some tools that may help when trying to compact an open database: The TSI SOON utility will close a database, compact it, and then open it again (it also copies NT file permissions to the new file): http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8 Another utility is...

You can use the Report grouplevel, controlsource, and sortorder properties to build a sorting/grouping string for a text box. Reports!MyReport.grouplevel(0).ControlSource returns the name of first field you sort or group on Reports!MyReport.grouplevel(1).ControlSource returns the name of...

Check your references. Open any module in design mode and click Tools > References. Is anything checked and marked "MISSING:"? If so, you'll have to resolve these before continuing. Either find the missing library and reference it, or remove the missing reference. Hope this helps, Peter De...

Also check your references. The module may be in a referenced library. Open any module in design mode and click Tools > References to see a list of your referenced libraries. Hope this helps, Peter De Baets - Peter's Software - http://www.peterssoftware.com

Well, first of all, it's not the size of the screen, it is the display resolution that is causing your forms to appear bigger, or smaller on the different computers. Is changing your users' screen resolutions an option? Try right clicking on the desktop, then go to properties > settings to...

Use the reports query on this page: http://www.mvps.org/access/queries/qry0002.htm to get your list of reports for your listbox (use the reports query as your listbox recordsource) Next, create a function to run a report using criteria from a form like so: function MyFunction(strReportName...

My suggestion would be to change the reference on your development machine to JRO version 2.1 so you do not have the discrepancy when porting to the user machines. If this doesn't work, then reference manipulation (using the references collection) is possible, but it seems like the above...

I might need more information in order to help you out. Which form resizing solution did you implement? If you are using ShrinkerStretcher, there is a minimum font size constant that will keep fonts from resizing to very small, un-readable sizes. Also, sometimes a form has empty space to the...

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...

>Where do I put this code? In a command button OnClick event procedure (not in the OnClick property). Click the build button "..." next to the OnClick property to create an event procedure. Hope this helps, Peter De Baets Peter's Software - MS Access shareware and freeware for developers...

Sure! Use the SendObject method: SEND AN E-MAIL MESSAGE FROM ACCESS You need an e-mail program that uses MAPI, like Outlook Express: DoCmd.SendObject ,,,"ToJohn@doe.com",,,"Subject","Message",False The above example will put an e-mail message to "ToJohn@doe.com" into your outbox. To have...

You can find the relevant thread here: http://www.access-programmers.co.uk/ubb/Forum4/HTML/002191.html 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 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...

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...

Include references to both DAO, and ADO. Then in your DIM statements, specify which common objects (recordsets, fields, etc) belong to DAO like so: DAO.recordset, and which belong to ADO like so: ADODB.recordset. Ex.: Dim rst as DAO.recordset dim rst2 as ADODB.recordset Hope this helps...