Search results

Hmmmn - Google wasn't much help with the ActiveX Scrollbars. Best help was several links that pointed to this thread, that is supposed to be using an Active X scrollbar, but it doesn't say anything about it, and it has to be updated for 64-bit ...

Now it opens but needs to be updated for 64-bit. I'm going to see what I can find on ActiveX Scrollbars first ...

I spoke too soon - apparently you can't set the backcolor of cmdButtons via VBA. I put the correct code in (I think), but the backcolor in design view is #FFFFFF, but the button background doesn't look white to me, and it never changed when I ran my VBA Code. I'm going to change it to a label...

@CJ_London - Thank you! I see what you are doing and it is pretty clever. I don't think I'll be the one modifying it, though. I have the buttons working using a subform, but I don't think you can position a subform with DoCmd.Move, but I'm unsure of that. That said, other than going offscreen...

Have a fairly stupid question and the correct answer might be - "you can't" and I can live with that. If you look back at the initial question, the custom buttons are in the footer, and there is a background image for the form itself (the black area to the right of the custom buttons). I would...

Figured out how to clear filters: https://www.access-programmers.co.uk/forums/threads/vba-to-apply-remove-filters.175908/ In my case, the button would refer to the parent form. I think I can modify Leban's code to do that. Not sure how to do it with the class object method - it's probably...

@CJ_London - Thank you! I truly appreciate all of the effort. I wouldn't mind seeing the code - very curious how you keep the subform from moving when the main form is scrolled. Question - Would putting the nav form in the form footer help, and would Stephan Lebans method help -...

I'm not the one to ask about this, but in the FE, the on change event and the BeforeUpdate events both fire, so it seems like the FE is seeing it as a change. I told my immediate supervisor it's something of a "If nobody hears the tree fall, did it make a sound?" If you change the database...

Been there, and when there weren't extensions like Typio, etc. Somewhat darned either way for the software developers. Nobody wants to lose 15 minutes of typing and nobody wants to not be able to "revert to Saved" and drop their changes. Access isn't only used by developers. Often, people have...

If you have the lever-style doorknobs, cats can figure out how to jump up to them and hang on them and open the doors ...

Just for info - I ran into something odd - probably due to order of events. I was troubleshooting my DM's and decided to enable GetRealUserName() in the test BE. (I had added the code previously but commented it out). I had the DM open and I went into the VBA and enabled the function. The DM...

@Pat Hartman - We are MUCH closer to being on the same page than you (or I) might have originally thought. Valid point. There are numerous places in our database where you can cancel an action. We used to use Me.Undo if you did this - which wiped out ANY fields you had changed since the last...

@Issac - The current version of Word M365 has this correct, in my opinion. It will not save unless you tell it to do so, but if you just type for 20 minutes or so, it will say "You haven't saved this document yet, would you like to do so now?" (And then it prompts you to save to OneDrive or the...

Concur with @Isaac. I've worked around it, but just about any other application let's you make changes and then when you want to exit asks "Do you want to Save?" (which is annoying if you just saved and haven't made additional changes.) Unless you add some kind of Before_Update verification...

I don't use OpenArgs. I am planning to use SQL Where clauses in the RecordSource of the form and select the recordsource to use and requery the form in the Form_Open event. Would this not be triggered if I was opening the form as a subform?

I think Docmd.openform is only on the switchboard, but there are a LOT of Forms!YourFormName in the various module codes ...

The form is not continuous - or at least datasheet view is disabled - if that helps. And we use tabbed windows, which basically gives the MDI look. Main issue is that I'm not sure how much moving the main form to a subform will affect anything with how the form works ...

As stated initially, three reasons: The "free" navigation bar will not autoscroll through the records. The custom ones will. I.e. I can hold down the Next button and go through ALL the records. I don't have to click to go to Record 2, click again to go to Record 3. I have AllowAdditions = No...

@ MajP - we are talking about different things ... I want the next record button to scroll through the records - Your demoNavigation with Scroll does that. I don't need a button to scroll the form on the screen, but I need the controls to stay visible. I don't need or want an Add New Record...

@CJ London - Both ... What I meant was that if I hold down the Next Record button, it keeps moving. The standard buttons I have to click the button repeatedly to keep going to new records. I'd prefer the scroll bar in the navigation control, but I can live with it on the detail subform also...