Search results

Hi @Moosak I've done some quick tests and it now appears to work perfectly in English GB Access 365. I've not tested the disabled sections of the form Thank you for making the changes - it should help a lot of people - especially those new to Access Two things: 1. I realise that Arabic is...

Clearly in your original question, it assumed a string. Adding ‘the number’ was necessary to do what you wanted

What happens if you ask ChatGPT "Is the number 9.11 bigger than 9.9"?

Various solutions are possible. For example: https://www.isladogs.co.uk/highlight-current-record-transparency/index.html https://www.isladogs.co.uk/highlight-current-record/index.html

Yes indeed! That gives one of each artist! 😏

Or just use SELECT DISTINCT omitting the Record_ID field

See my article and free example app: https://www.isladogs.co.uk/table-analyzer/index.html

It’s not as simple as adding PtrSafe and converting Long to LongPtr. Not all Longs should be converted. You need to know the correct code for each API and Type statement. There are various free and paid tools to help do this including Peter Cole’s converter and the VBE_Extras add-in. For...

REMINDER: The next Access Europe User Group meeting is TODAY (Wednesday 1 Oct 2025) starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). The session will led by Marcus Dieterle For more details, see post #1

Agree with the previous comments. You need to restructure your tables using proper normalization techniques before you spend time trying to optimize this query. Once you have done that, study the techniques explained in my article and related app / video...

OK but as Theme Blue isn't a standard theme, I've no idea what it looks like! For info, I've just published my article: https://www.isladogs.co.uk/aptos-font-issues/index.html Feedback welcomed

I'm still unclear why doing that would put the BE into read only mode Whilst still a good idea for stability and other reasons, I don't believe SQL Server will solve that issue

Just add an unbound text box to the report and set the properties below Control Source: =1 Running Sum: Over Group That’s all. The unbounded text box will automatically give a sequential number for each record For queries & forms, my preferred solution is to use the Serialize...

That's what I assumed. I would suggest both moving the BE to SQL server and setting up a system to automatically close the FE after a specified period of inactivity e.g. 20 minutes. However, as far as I am aware, neither of those will help manage them just closing the laptop lid as the system...

1. Setting up an inactivity shutdown is a good idea for other reasons but i won't help with this specific issue. When the laptop lid is closed Access (and all other open apps) will remain in the state they were left in and should restore automatically when the laptop is next opened. Is that...

In addition to the various methods of adding row numbers to queries and forms, Access does have a built-in system for row numbering in reports

No need if you made both changes to the default theme that I described in post #10. Doing that will make Calibri the default in all new databases.

Yes I agree that the Form Datasheet ribbon is a more logical place for the text formatting group items and have just done the same as you. Your post has prompted me to get on & finish an article about the Aptos font which I began a few months ago It should be ready in a day or so under the...

As already stated, all the examples are supplied free as fully working ACCDB files with all code They have been downloaded and used by many people.

@arnelgp Just for once why don’t you check rather than make incorrect, negative comments. The files are ACCDB