Search results

Calendar or Date Picker? Either way, many to choose from. For example: https://www.isladogs.co.uk/better-date-picker/index.html

REMINDER Access Europe meeting led by Neil Sargent is TODAY - less than 1 hour from now. Be there . . . or be square!

That’s an entirely different matter. Both of those are still perfectly possible 😉

You didn't imagine seeing something about opening the Edge browser directly in Access Back in October, AWF member @MsAccessNL posted this thread: https://www.access-programmers.co.uk/forums/threads/webbrowser-in-form-without-control-years-to-late.334741 However, he never actually posted any...

I agree with @theDBguy that you approached this in the wrong order I can now see why you asked the original question though its from a complete misunderstanding of how linking to an encrypted DB works With regard to the suggested next steps from post #10, there is no need to delete and...

No problem. That's definitely not my example. The person who I think may have provided that is no longer an AWF member. In case it helps, I have different code based on the undocumented SortStringArray function which is part of the Wizhook library and which you may be able to adapt...

You may be interested in the forthcoming presentation for the Access Europe User Group by Aleksander Wojtasz on Wed 4 Feb https://isladogs.co.uk/aeu-48/index.html Although its a month from now, Aleksander will be giving a brief outline of the session at the end of tomorrow's Access Europe...

@MattBaldry I do have code to move items up/down in a listbox using up/down button clicks. However, I don't think I supplied the code in post #1. A quick forum search gave me a link to this post where I did post example code...

I agree with @DHookom. I am not sure of your reasons for using code to open the BE. When applying security to an Access DB, you need to decide who or what you are trying to protect your database from. I provide a number of options to choose from. Most of the steps available are simple to...

The first Access Europe User Group meeting for 2026 will be on Wednesday 7 Jan starting at 18:00 UK time (6PM UTC) and finishing by 19:30 (7.30PM). Please note that the UK has now reverted to winter time. For local times, please check World Time Buddy In this session, we are very pleased to...

Version 5: Fixed an issue from version 4 if the end user manually sorted by AuthDateEntered DESC To do so, I removed the report sort from design view again and reordered the code in Report_Open. SortedBy textbox control source on report changed back to " = [TempVars]![OrderBy]" I also added...

True - but that's nothing to do with my changes - this would also have been the case in the original database you uploaded. By default, reports ignore any sorting in the data source - whether form or query However they have their own very powerful sorting and grouping feature which is applied in...

You're welcome. I tried to comment the main changes I made but ask if anything is unclear. I recommend one further change: Your form has so many columns that it could be hard for users to keep track of sorts & filters. I've made a further tweak so users can see the details about any filters or...

Done! I've updated it as follows: a) Added Remove Filters & Remove Sorts buttons to your form - both are hidden when the form is first opened and become visible when the end user adds a sort or a filter: b) The report now opens in report view with the same record source as on the form...

Sorry but I've no idea what 'all hell is loose' and 'no matter what I lose control' actually mean. However, if your users are going to sort / filter on the form, then I agree that you do need the code in the Report_Open event In that case, I would suggest removing it in the property sheet. I...

I'm a bit late to the party and am aware that @xavier.batlle found the solution to your main problem. The DoCmd.Restore line is necessary due to the API arguments used in the HideAppWindow function (BTW - its a function - not a module) If you want to hide the application interface, you need to...

For a list of all changes in each version of Access, see my article https://isladogs.co.uk/memory-lane/index.html

Had to think about this . . . Presumably you are referring to adding the line 127.0.0.1 msaccess to the hosts file to speed up loading of local files in the Edge browser control?

All of that is valid criticism. I didn't post the entire CoPilot answer as I knew that significant parts of it were incorrect. However, I failed to state that in my post for which I apologise unreservedly. I did state that your function appeared to always give the right answer in my own tests...

As stated above, both the code in post #2 and that in post #7 appear to give correct results in my tests However, here is the CoPilot critique of Philipp's simple function from post #7 EDIT: There are a lot of incorrect statements in the CoPilot summary above - See @posts #11 & #13 for details...