Search results

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.

Hi Peter Good to see you here. I think a lot of people here would be interested in seeing your excellent calendar app. Perhaps you could upload it to the Sample Databases section

See post #1 The issue was with a specific Windows 10 update back in March…not all updates.

I also find CoPilot intrusive in Office apps and largely ignore it in Word etc much as I used to ignore Clippy back in the day…. However, I find the standalone CoPilot app very useful. More for factual content than assistance with coding. It’s about as powerful as ChatGPT but I prefer the...

1. Try hiding the Quick Access Toolbar (QAT) 2. As previously asked, what happens to the appearance if you sign in?

I don’t understand your screenshot. Looks like a glitch as you seem to have two rows of minimize/restore/maximize buttons. Does it change if you sign in to your MS account? What exactly do you want to remove? Ribbon? QAT? Both?

Yup. That works! Design view: However, as expected I cannot link to or import the csv file using the import text wizard due to the non-Latin character set. From past experience I know that where text files fail, using Excel files often works! I converted to .xlsx and linked to the file then...

Yes, I assumed you would include queries created in the legacy editor. I'm using 365 Version 2508 build 19119.20000 Beta Channel - Office is English (United Kingdom) I do have non-Latin keyboards installed including Arabic and Greek, but not Japanese. Anyway, I'm unable to replicate your...

Do you get errors with Japanese language Office or with Japanese characters in English Office? Please can you provide a repro database with both object and field names in non-Latin characters and including a few problem queries. No confidential data. I will test and forward to the Access team...

The new automatic expanded formatting feature was one of the most frequent requests from Access developers. It was added in version 2506 along with partial sql execution. For more details, see my article https://www.isladogs.co.uk/monaco-improvements/index.html Although the expanded format is...

That's another screenshot from my School Data Analyser app You can spread the text out to fill the lines by using Text Align = Distribute in the property sheet. However, its not often used as the results can look dreadful. For example, the 3 lines text are left aligned in this screenshot...

You can sometimes make the query updateable by specifying unique values (DISTINCTROW) PARAMETERS SpecifiedRecordID Long; UPDATE DISTINCTROW tblRecords R LEFT JOIN qryOutstanding AS Q ON R.RecordID = Q.RecordID SET R.LockID = SWITCH(Nz(Q.Outstanding,0)>0,-1,TRUE,0) WHERE R.RecordID =...

Agreed. Controls can only be placed on a tab control page and never on the tab control itself. When placed incorrectly, the added control is on the form itself behind the tab control @missinglinq explained it perfectly back in 2016 in that other referenced thread and Pat also got it right back...

Whilst I understand your point of view, I'm inclined to agree with Duane. However, if you feel strongly about it, I would suggest a better approach than the Feedback Portal As I've recently discovered, anyone can suggest edits to a MS Learn page. To do so, click on the ellipsis (...) then click...

@Gasman is correct! Not sure where you found it, but that’s a screenshot from one of my commercial apps for schools: School Data Analyser https://www.isladogs.co.uk/school-data-analyser/index.html The form and its toolbar are used to make HTML help file pages for the School Data Analyser app...