Search results

Forms will always open where they were last saved UNLESS the AutoCenter property is set to Yes (or code is used to centre it in Form_Load event.) This is true for both standard forms and popups.

Sorry. My bad! The comment about always being a text field does only apply to value list MVFs created by the wizard. If you are using a lookup table, the MVF field datatype will indeed be whatever the datatype is for the lookup table field. The two articles I linked in post #7 provide...

The new expanded SQL format is just one of the three major improvements added to Monaco recently. The other two are: a) partial query execution b) speedy (pre-) loading (version 2507) See my article on these features: https://www.isladogs.co.uk/monaco-improvements/index.html I will indeed be...

Just for info, the truncation issue I mentioned in post #9 was fixed a couple of weeks ago (at least in the beta channel).

Fact …. but only if a) it’s an ACCDE file b) you add the line Option Private Module in the declarations section. This makes all procedures completely invisible but is only allowed in standard/class modules. See my article: https://www.isladogs.co.uk/vbe-option-statements/index.html

Too late as there have been several replies.

Agreed that hardcoding can at times be appropriate but that doesn't explain why you asked a question that you say you already knew the answer to

So why ask the question if you already know it works? It has also been explained in another thread why hardcoding the values is often not the best solution

@DakotaRidge The specified limit of 1000 code modules is one of several that should be treated as a sensible guideline rather than a hard limit. In fact the actual limit is 5450, but performance will become abysmal long before reaching that limit. See my article for more details on this and...

With hindsight I agree that text values would have been better. However, its worth stressing that a standard MVF field created using the wizard is always a short text field even if all values are numbers. You can see that from the sort order in the examples I provided. Although rarely used, it...

@MajP Many thanks for the links to my article. I agree that how to query MVF fields was one of the main parts of that article. It can be done but the techniques needed are not always intuitive. Just wondering why you wrote the second sentence in the quote below Happy to answer any questions...

Hi I agree completely with you regarding how well MajP explains concepts in his presentations. That's why we invited him back recently. I also agree that Aleksander is an excellent programmer but, in my opinion, he also explains concepts clearly despite English not being his first language (he...

The next Access Europe User Group meeting will be on Wednesday 6August 2025 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). For local times, please check World Time Buddy I will be the presenter for this session and will be demonstrating several recently released new...

That option has existed since at least A97 (i.e. before the Office VBE was integrated into Access) and has always been on by default. As mentioned in post #9, Require Variable Declaration was also on by default in A97 The VBE was added in A2000 and its Options menu looked almost identical to...

Although that is the default, it depends on the VBE settings From the VBE Options help: Compile On Demand: Determines whether a project is fully compiled before it starts, or whether code is compiled as needed, allowing the application to start sooner. Background Compile: Determines whether...

Sorry but no - Aleksander isn't an AWF member as far as I am aware

Me too. Unfortunately backwards compatibility means it won’t ever be changed

I asked this some years ago. Its not set as default as VBE settings such as Option Explicit apply across all Office apps (as you can easily check) I just asked CoPilot: Q: Remind me why Option Explicit isn't set as default in Access A: Great question, Colin — and one that’s sparked more than...

That’s it! Mainly for reporting spam or other ‘problem posts’ but also to alert mods for any reason.

Create a new thread in Ssmple Databases and attach your file when you are ready. That area is moderated so your thread won’t appear until it is approved. I recommend reporting your own thread to alert the moderators.