Search results

Whilst I agree with June7 about shrinking the form / subform heights, the described behaviour doesn't happen for popup forms as they are independent of the Access application interface. As the form supplied already is a popup form, it doesn't shift upwards when the subform gets focus.

Perhaps the tables were hidden in the original database and so are hidden now as linked tables. Try making hidden objects visible in the nav pane.

That’s great. Glad you have a solution that works for you. The thread triggered some interesting viewpoints and suggested approaches

I can't really see what you mean from the screenshot so don't know whether my automatic form resizing will help. This is the link to the first article in a series of four: https://www.isladogs.co.uk/automatic-form-resizing-1/index.html

One of the reasons for me starting this thread was also to remind me of things I had forgotten e.g. the button icon editor. Another is to hopefully find out new things that I never know about. I have to admit that I wasn't expecting the significant interest in user forms but clearly that has...

You're welcome. I've also just uploaded the same bug fix for the standalone version of this app. Now at version 2.32 https://www.isladogs.co.uk/nav-pane-helper/index.html

One more item from me for today. You can use the VBE to do bitwise operations. For example: If that looks like nonsense to you, see https://dev.to/stephengade/mastering-bitwise-operations-a-simplified-guide-2031

Thanks! I'd forgotten about the button editor! Another couple of fairly obscure things: Some developers will be aware that you can drag database objects from the nav pane either onto the desktop (to create a shortcut for dropping into another database later) or drop them into the navigation...

From your earlier comments, I assumed you knew some answers to my question. As I said, I very rarely use ActiveX controls or almost never create user forms. As for bar codes I just use a textbox with a barcode font on a standard form. Anyway, I think its time to move on.

As discussed in another current thread, you should avoid hard coding form controls into queries where possible Personally, I would use the PARAMETERS declaration approach already suggested by @theDBguy However, another more convoluted method would be to assign the form value to a public...

I rarely work with user forms or ActiveX controls in Access which is why I was asking for examples. All the MS Forms2 controls can be used with standard forms. The reference is added automatically. As far as I am aware, exactly the same functionality is available for these controls whichever...

Can you give examples?

Agreed. However I thought the OP wanted to analyze an old database to identify existing references to a specific form in queries in order to then modify the query SQL

With standard forms, controls can only be created in design view. However, you can give the illusion of doing so by showing / hiding controls at runtime. You can indeed create user form controls on the fly but AFAIAA any new controls created only exist during runtime. They do not persist User...

You need to add the UserForm item to the Insert menu manually Right click on an empty space in the toolbar area and click Customize Select Insert on the dialog box and drag the UserForm item to the Insert menu The same process can be done to add /rearrange or remove items to/from the...

With a bit of work, the built in Object Dependencies tool will do what you want but it doesn't work with macros, modules or subqueries The free AccessDependencyChecker handles all object types and works well. As for commercial tools, these will also find unused objects but also do additional...

No problem. Assumed you had missed those posts.

Prompted by an old thread at Stackoverflow, I thought it might be interesting for members to share features that are not widely known in VBA. Here's a couple to get started. If the thread gains traction, I may add some more .... 1. Adding Option Private Module in the declarations section is...

Not quite true. Ctrl+' (apostrophe) will copy the cell above in a spreadsheet and the above field in a datasheet Ctrl+; (semicolon) enters today's date in a spreadsheet cell and the selected field in a datasheet Ctrl+: (colon) enters the current time in a spreadsheet cell and the selected field...

Already explained in posts 4/5/6