Search results

Thanks. I can now replicate the issue Setting the Sort Order to Ascending or Descending when the Sort By option is Remove Automatic Sorts makes no sense & triggers that error Amazing that nobody has mentioned that issue in the last 3 years! I've updated the add-in to v2.42 and fixed it by...

Thanks @MarkK I was on my phone for my previous answer Now I'm back at my computer, I can provide a bit more detail All you need from the MSysQueries table is the Expression field for Attributes 8 & 10 (WHERE & HAVING clauses respectively) So I suggest the following SQL SELECT O.Name...

You could also query the MSysQueries system table once you understand its structure.

The Object Dependencies feature under Database Tools will allow you to see which queries depend on your MainForm. You can then view the SQL for each of those queries. Or there are various database analyzer tools available (including my own) that can do that for you

Sorry but its not clear what error you are experiencing The code works without error as an add-in. Its not intended that you add the code to a form load event in another app The error handling you added isn't going to work as you intend If there is an error, the code will never reach the Resume...

Probably so. However you still need to store the data if you want to reuse it e.g. to change the form/control design.

Have a look at my coding modern charts example app demonstrated at the start of last weeks Access Europe meeting In that example I use a collection to store values for each chart series as they are changed on the form. When the form is closed, by default the changes are discarded. Or you can...

Thanks @MarkK Having now tried this on both 64-bit & 32-bit Access, I can confirm that: a) it runs without error on 64-bit b) on 32-bit, it triggers error 438 on the line wmp_Theme.URL = CurrentProject.Path & "\" & txtTheme as already mentioned by @June7 who also stated that disabling the WMP...

I’m not completely clear what you are doing. Can you upload a cut down version of your database to look at.

Version 2509 Build 19204.20004 64-bit Beta Channel. No errors experienced though not tested thoroughly. Looks like this may possibly be another example of the 32-bit bug though very different to others examples seen so far. @MarkK / @murray83 - can you please confirm whether you have 32-bit or...

Version 2507 appears to have some bugs specific to 32-bit only. Suggest that all who are testing this app state the bitness as well as version and build number

Just for info, I tried adjusting the heights of the different sections to see if that had any effect First of all I tried removing all the empty space thinking that would help and the overflow occurred sooner (page 107) rather than 138. So I restored the original spacing & removed the unused...

The video of my presentation on New & Forthcoming Features in Access from Wed 6 Aug to the Access Europe User Group is now available on YouTube: For more details on the topics covered, see post #1 Links to all slides, articles and example apps referenced in the session can be found at...

The thread at AccessForums is at https://www.accessforums.net/showthread.php?t=91059

Hi Mark Great. I'd love to see you at future meetings and indeed hopefully have you as a potential presenter for AEU As you are GMT-9 it sounds like you are a similar time zone to George (or further west - Alaska / Hawaii?) so you should find his meeting times work well for you The Access...

Hi Mark Whilst I would love to see you at one of our live sessions, all Access User Group chapter meetings are recorded and uploaded to YouTube. The link provided in post #4 shows all the videos for each chapter going back over several years. There are several hundred videos available. There...

Are those split? 😉

Yes. As already explained by both myself and @MajP

Depends on whether its a simple or extended multiselect listbox. https://learn.microsoft.com/en-gb/office/vba/api/Access.ListBox.MultiSelect

The two types of chart are managed in a totally different way. For many years I preferred classic charts but modern charts have been significantly improved over the past year & I now use these instead. There are many things that can be done in both chart types but each type has certain features...