Recent content by isladogs

In the Access immediate window ?1/1.95 0.512820512820513 ?CDec(Round(1/1.95,16)) 0.512820512820513 ?Round(CDec(1/1.95),16) 0.512820512820513 In a textbox control with record source =1/1.95 and no formatting

Adding to the above, I'm surprised you didn't test in both Access and the Windows Calculator. FWIW, both give the same result as the online calculator. Does that mean those are the 'correct' answers? See post #2

The safe mode screen occurs when Access has failed to open on the previous two occasions in succession e.g because you tried to open an app where the lock file existed and prevented the app opening.

The lock file still exists as the file is open in the background. Open Task Manager, go to Background Processes, select Microsoft Access then End Task. You should now be able to delete the lock file in File Explorer. Next I recommend you decompile your app to remove any corrupt compilation...

As a starting point, have you considered asking Karl if he has a list (even if incomplete)? He’s not an AWF member so it’s unlikely he will get to read this thread unless prompted.

Just returning to my question in post #12, even though your default Windows printer is Print to PDF, individual reports can still have a different printer specified. That can cause problems when the specified printer isn’t available. Whether it might explain opening in report view is another...

Is the report set to open on a default printer which isn't available on that machine?

Me too!

OK as nobody else has responded, I asked CoPilot to do so. Its answer was explicitly based on this thread even though I didn't mention it! Judge for yourself whether its giving additional info or is just referencing/reinforcing earlier responses. Remember that CoPilot like all LLMs likes to...

@AHeyne Thanks. Yes I am familiar with that API but your notes are very helpful. In particular, I wasn’t aware of the timeout value of 32000. After a short break from this topic area, I am planning to write an article on adding timeouts to each of the message types already mentioned: VBA...

You've made that point several times already. That is your opinion and that's fine. However there is no benefit in repeating yourself. Excel / Word etc already have the new style Office messages but they don't have Wizhook or Eval so, unlike Access, the built-in functionality can neither be...

For info, all of that is basically equivalent to my example app linked in post #9

For info, I've now completed the second article in my series: https://www.isladogs.co.uk/eval-new-style-msgbox/index.html This also includes a comparison of the different features of the various message types in Access 365. Thanks again to @AHeyne for the info provided in post #48 which I...

You can try my example app as a starting point: https://www.isladogs.co.uk/password-login/index.html In addition, parts of the following app may also be of use: https://www.isladogs.co.uk/logged-in-users/index.html

Yes MS lost a lawsuit about this and removed the ability to edit linked Excel worksheet in A2002. However, if you set IMEX=0 in the connection string instead of the default IMEX=2, then all linked Excel worksheets become editable again. See my article...