Search results

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

@Pat Hartman posted my code, which does NOT create empty records, instead of the OP's. Commend322 does indicate at least the minimum number of controls added to the form, but not necessarily the number of controls currently on the form, but I agree, meaningful names would be helpful.

I did that already. Functionally yes. Aesthetically - no, b/c there is still the grayed out button and the screentip if you hover over it, even though it no longer does anything.

All - there is no immediacy on this. The form I have now has been in use for over 15 years. I just would like to get rid of the standard buttons. @CJ_London - To make it easier on both of us, what I ideally would like is for the navigation class module to look almost exactly like the standard...

Thanks - I didn't follow through all of the details, but @arnelgp posted a demo in Reply #6 (in your linked thread) that I can probably modify and that uses the method @isladogs mentioned. Basically, I would just need to modify his example to look like the standard navigation bar and then load...

Is there any way to keep the standard navigation buttons, but hide the Add New Blank Record button. I know I set Navigation Buttons = No and hide all the buttons, but I would prefer not to do that - it also hides the No Filter and Search buttons, but I could work around that. I have...

It depends on what is in the DM Code. In my case, the DM calls a function named GetRealUserName, which in turn calls a function named GetUserName. Yes, I could and initially did put both of those in the BE and it worked, but then the DM's didn't work from the FE (b/c I did not have the...

Try LarryE's suggestion. Was news to me, but it makes sense. Would not happen with the code in Reply #15 Your Add Record Button Code was: On Error GoTo Err_Command327_Click Me.AllowAdditions = True DoCmd.GoToRecord , , acNewRec Me.AllowAdditions = False Exit_Command327_Click: Exit...

Not much has changed since Sep 6. (The thread could use a summary, though). I'm not sure I posted the code for the original question - that would be this: Function DB_Corruption_Check() ' https://access-excel.tips/access-vba-loop-through-all-tables/ '...

Semi-old thread, but I used navigation buttons from Stephen Lebans and found it was doing the same thing and modified it slightly. I can't find the link, it is similar to this: https://www.access-programmers.co.uk/forums/threads/custom-navigation-button.164220/ - and someone else modified it and...

Thanks - just wanted to make sure I wasn't missing something obvious - which is always a possibility!!!

@jdraw - I didn't follow where you were going with Reply #121 - possibly b/c I am basically doing most of what you suggested, i.e. - Correct, development and testing of DM is done by the developer (me) and done using a (local - and under my username) copy of the backend. - Makes sense if I were...

Thanks all for the kind words and support ... StopMacro could be useful for testing instead of incrementally developing the code. However, if you move the line to the end of the macro, now you have to remember where you moved it FROM when you need to move it back. IMHO, you would be better off...

I decided to do a write-up on things I learned with data macros - hopefully it helps others: Disclaimer: I've never actually used the Allen Browne style VBA Audit Macros. Bluf: Data Macros are somewhat more versatile and generally more difficult to set up. Things that might trip up a new...

@jdraw - I haven't tested it (and it might be a while before I do ..., but ... SIMPLY AMAZING AND VERY MUCH APPRECIATED!!! THANK YOU!!! Good info and good to be aware of, but that won't be an issue. It could be if I had multiple backends, and in that case, I would probably store the text files...

Have an odd glitch which is just enough to annoy me!!! See above. When I am on the test BE, the switchboard has a light gray background for the detail pane and a maroon background for the footer. When I am on the production BE, the switchboard has a dark gray background for both. When I...

I have Reply #105 working through a combination of factors ... First off, I think this is related to working over VPN instead of hard-wired. I.e. it takes 10-20 seconds to update at home, as opposed to probably 1-2 seconds if I were in the office. Second, it's probably a perception thing, but...