Search Result

Collapse
4 results in 0.0279 seconds.
Keywords
Members
Tags
  •  

  • Petrol
    started a topic Outlook automation options

    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?
    See more | Go to post

  • Petrol
    started a topic Compact and Repair causing errors?

    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...
    See more | Go to post
    Last edited by NeoPa; Nov 9 '25, 06:29 PM.

  • Petrol
    started a topic Adjusting the height of a report entry in VBA

    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...
    See more | Go to post

  • 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...
    See more | Go to post
    Last edited by NeoPa; Oct 20 '25, 06:39 AM.
Working...