Search Result
Collapse
4 results in 0.0279 seconds.
Keywords
Members
Tags
-
Outlook automation options
When I create an email directly in Outlook, it gives me options to select the email account to use (the 'From' dropdown) and the address to direct replies to ('Delivery options'). I can't find any way to implement these options uning Mailitem.Send. Is it possible? -
Compact and Repair causing errors?
My Access database appears to run correctly, and it recompiles without error. However, if I run a Compact and Repair, when the database reopens I get the error message "Invalid databse object reference" - without, unfortunately, mentioning which object it is referring to. See attached screenshot. Then it says either "The expression contains an ambiguous name" or "The expression you entered has a function name that EmmausDBMS...Last edited by NeoPa; Nov 9 '25, 06:29 PM. -
Adjusting the height of a report entry in VBA
I have an Access report whose records in the Detail section usually require two lines, but occassionally a message needs to be displayed for a particular record. This message is in the form of a label in the third line, which is made either visible or invisible, depending on a flag within the record. To avoid wasting space, I want to adjust the height of the entry to accommodate the third line only when required. The flag is checked, the label.Visible... -
How to trigger the Format event for a report section
Does anyone know the magic trick to make the Format event fire for a report section? I have a simple event procedure linked to the On Format property of the Detail section, but it doesn't work.
learn.microsoft .com assures me "For report detail sections, the Format event occurs for each record in the section just before Microsoft Access formats the data in the record"; but setting a breakpoint confirms that in my case the event procedure...Last edited by NeoPa; Oct 20 '25, 06:39 AM.