Search results

Follow-up - I did read the article. My main concern is preventing direct access to the tables. The article mentions setting them as hidden, but anyone can show hidden objects and see them. Is there a better step to prevent this?

I have code in my database autoexec that is supposed to disable the Shift Key Bypass UNLESS the database is opened from my development folder. I am getting ready to release a new update to the database (.accde) file, and I realized that I forgot to set some of the tables to hidden in this view...

I'm going to live with the two line scroll bar. I did see how the ActiveX scrollbar is supposed to work, but it's somewhat glitchy. Attached file opens, but might not be correct. I just changed everything that wouldn't open to PtrSafe and commented out anything that gave me a type mismatch...

No change putting the slider in the footer. Still flashes and doesn't do anything - but the idea is promising. I made a mistake earlier. I shouldn't have inserted the navigation subform in the footer and made the space for it the width of the form. I should have put it in the form at it's...

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