Search results

Ah it seems I misunderstood your previous post. Yes I agree with all of that which is why I previously said I was baffled. At one point I did get your query to auto expand after modifying that one field. I then renamed the query and it compacted again. No idea why.

There is nothing wrong with using an IIf statement in a query though there is a problem with it here You have another circular reference in the latest query: Sum(DetallePedido.QAsignada) AS QAsignada The expression field should have a different name to the field it is based on You have also...

I tried disabling all fields that involved an expression and reinstated them one at a time. The problem field in design view is: PrecMedCompra: IIf(IsNull(Productos!PrecMedCompra),Productos!PrecioUnidad,IIf(Productos!PrecMedCompra=0,0,Productos!PrecMedCompra)) With that disabled, it auto...

I'm equally baffled. Just expanded it with my add-in but as soon as I saved it, it reverted to the compact version. Just sent it to the A-team to see if they can explain

If you want to send me the query SQL together with the related table structures, I can try to work out why it won't expand. Or if its correct SQL, I can ask the Access team why its not expanding properly You are in fact on Current Channel Preview version 2507 build 19029.20076 In this case...

Version 2506 included the new expanded SQL format It should happen automatically. However, if you import SQL from another source, you can trigger the expanded formatting by clicking Ctrl+K. See section 2 of my article: https://www.isladogs.co.uk/monaco-improvements/index.html NOTE: If Ctrl+K...

The shutdown of UA was nothing to do with any other forum such as AWF or Discord.

I have been using SamLogic Visual Installer Pro to distribute Access projects and other files for over 10 years. Unlike SageKey and SSE, VIP is not restricted to Access only, which in my view makes it more useful. There are several articles about its use on the company website. In my experience...

Hi Ron Good to see you here

@Pat Hartman I dropped out of this thread some time ago and only rejoined to respond to incorrect statements you made. It would appear you missed the whole point of my last post even though I put the most important part in bold type. Whilst you say you hear what people have been saying...

Both of those statements are completely incorrect. Nobody has stated that behaviour is OK and in fact it does not happen as you describe. Once the form is in design view it will close without running any code Steps to reproduce: 1. With your flawed code, attempt to close the form in form view...

I had this a couple of times recently due to doing it wrong. When it happened to me, I had pasted the code then selected it and clicked the code tag button. Just the first line appeared. To do it correctly, click the code tags then paste / type the code into the code window (not the other way...

The video of Pete Poppe's outstanding presentation to the Access Europe User Group on Wed 2 July is now available on YouTube: I hope you enjoy it. Next month on Wed 6 Aug, I will be leading a presentation on New and Forthcoming Features of Access including: • VBA support for modern charts...

Hi Ken Good to see a fellow UK resident joining here. I've also looked at quite a few of your example apps from your repository

Not quite accurate. it seems to load in the background whether or not there are any forms (open or otherwise). See my example in post #12

Not directly. Access won't allow you to remove any query that is in use, either from the References dialog or using code For example, you cannot remove the built-in VBA reference automatically included in any new database by either method The MSForms reference behaves as though it is in use...

Sorry about that. I was out earlier when @DickyP posted and uploaded working code on my return Thanks for the correction. Just removed the unwanted 's' at the end of post #15 Other related reference code available here: https://isladogs.co.uk/references-code/index.html

You can remove it using code either from an external db or the current db as its not actually in use despite the message shown earlier. This is the code I use to remove references from the current database Error handling manages the situation where the reference is actually in use. Sub...

I use API code similar to that @arnelgp got from ChatGPT though with fewer APIs. For example, see my example app: https://www.isladogs.co.uk/sql-to-vba-back-again/index.html Coming back to my earlier point, if you ever load the MSForms reference, you cannot delete it again even if its never...

Whilst it works, I'd suggest avoiding the use of the MSForms reference library if possible. Its not listed as it isn't intended for use in Access The link in post #5 gives one such alternative.