Search results

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

Disregard. Can't replicate my own issue. Marking as solved.

@MajP - Similar but not exactly what I am looking for. Let me provide more info: There are approximately 30 possible statuses. So having a record on Status 25 and clicking the down arrow and having to scroll down from the top to get to item 26 is inconvenient. (And the combobox only shows 15...

Technical aspect of the thread went way beyond me, but I suspect you won't have to go too far back to find cases of uncles marrying nieces, or at least cousins marrying cousins once removed, so in that case you would have to decide if the niece was in the uncle generation (her husband) or the...

Hard to describe, but I have a combobox named Status with essentially, sequential values, e.g.: Review 1 Review 1 Complete Review 2 Review 2 Complete Review 3 Review 3 Complete This works fine, but if the status is Review 3 and I want to change it to Review 3 Complete, the drop-down opens at...

Absolutely - I would hope the company would give me some advance warning before moving the backend. Then again, I talked them out of it, but I got an E-mail from our Citrix team last Wednesday that they wanted to drop Outlook Classic and go to Outlook web app and had a test environment ready to...

No I understood what you meant, I wasn't clear on my reply. Let's say the BE is loaded on \\NetworkPath\BE_Folder. So far (knock on wood), my company hasn't been saying "In two months, we are going to change \\NetworkPath\BE_Folder" to a OneDrive file folder. They have been saying things like...

Not quite clear to me below: I gave you bad information earlier. The database uses an AutoExec macro that calls an AutoExec VBA script. The VBA script opens a hidden Down For Maintenance timer form, then it calls an AutoUpdate subroutine that checks if the user is authorized, if the database...

Directly. (Probably via a shortcut after this update, but ...) I possibly where you are coming from and it leads to a good follow-up question: @The_Doc_Man: Currently the database opens, imports an Excel file, checks if the user is authorized, and then checks if it is on the User's Desktop or...

I think I can get there with variations of @theDBguy code. Answering some other questions: @CJ_London - I don't think that we have write-access to C:\Databases. We do have write-access to C:\Users\<username> - and putting it in this subtree ensures that the logged in user is the only one...