Recent content by Marshall Brooks

Disregard - I ended up just trapping for error 2455 and clearing it. Crude, but since the errror only occurs when the database is shutting down anyway, it works. Not sure why Form Activate runs again when the app is shutting down - I found...

Me.subformname.Form.Scrollbars = 0 creates an odd error: If I open the form, and do a search and then close the database with the red X, I get a RT 2455 at this line with the code "You entered an expression that has an invalid reference to the property Form/Report." I suspect b/c Form Activate...

Just wanted to follow up - there is a slightly easier solution. In the main form's Form_Activate() code, specifying: Me.subformname.Form.Scrollbars = 0 works also and then I don't have to specify anything in the subform's Form_Current() event. I'm not sure why it works with Scrollbars = 0...

Solved - although the solution was weird: As I said, specifying scrollbars in the subform Form_Open event doesn't work. Specifying Me.Scrollbars = 2 or Me.Form.Scrollbars = 2 in the subforms Form Current event shows the scrollbar briefly, but then it disappears. Specifying Me.Scrollbars = 0...

@Imb - where? I.e. for me it would be HB_Sub.Form.Scrollbars = 2. In the main form would this be in the Form_Open, Form_Activate, Form_Current event or somewhere else?

@theDBguy - Thanks, that gave me an idea, but it didn't work. In the main forms Form_Activate event, I tried adding Me.Subform.SetFocus, and in the subforms Form_GotFocus event, I tried adding Me.Scrollbars = 0 and Me.ScrollBars = 2, but it didn't work. One thing I found: If I open the main...

I think I probably have this as good as I can get it, but I wanted to ask here first since it isn't working as I expected. I have a simple subform with two columns and several thousand records. I want the subform to have a vertical scrollbar and no horizontal scrollbar. I looked at these...

I know this is a really old thread, but I just wanted to post to say thanks. Somehow my database was using RegEx.TEst instead of RegEx.Test, although it still worked fine. I tried a find and replace and used MatchCase to change it and it said it make 58 changes and all of them were still .TEst...

@MajP - A bit more involved than I'd like, but that would work for what I need. Thank you!

Closer ... I found out .listindex is read only. https://www.access-programmers.co.uk/forums/threads/change-the-selected-index-of-an-access-combobox-using-vba.323060/ - Using .ItemData, when the downarrow is clicked, the status can immediately change to Review 2, and the drop-down immediately...

@MajP - Either you didn't understand where I was going, or I didn't understand what you meant. I'm already displaying a value (say Review 2 Complete) that is not shown in the drop-down. (Not sure if this is b/c VBA allows me to set values in code that aren't in the selection list, or b/c I...

Not ideal, but good thought. Let me kick that around ...

Wanted to reply back and close the loop on this. I figured out what was happening ... The database is somewhat used as an automated workflow. So the responsible user can select Review 1, Review 2, or Review 3 from the drop-down, which are the procedure steps. THEY can't select anything NOT in...

I didn't realize that was an option, but I found it and it helps a lot. If the forum had a way to award you status points I would do it! Fortunately, it is a max number - I bumped it up to 40 but it only shows the number of items there are (not 10 extra blank rows).

Is the E-mail not including the signature block at all, or is it just not including an image in the signature. I'm familiar with Outlook and not gmail, but in Oultlook, you have to modify the html for the signature to have images show. See...