Search results

Each field should only contain one item of data. So you should split Customer Name into LastName and FirstName fields and only store that in one table. Similarly split the CustomerAddress into several fields e.g. AddressLine1, AddressLine2, Town, Postcode and only store in 1 table. Add an extra...

You're right. My previous suggestion only worked when Example was called from another procedure. I tried a different approach to strip out the unwanted line(s) which works whether the Example procedure is called from: the immediate window as part of another procedure which has been stopped...

The line .0_#ImmMod#_._ImmedProc is nothing to do with the immediate window being used. It is caused by a simple error in your Example sub - you forgot that Frames is zero based To get rid of that unwanted line, your loop should be: For i = 0 To UBound(Frames) -1 Example output:

As the lawsuit was almost 25 years ago, its quite possible that it has now expired.

@CJ_London The image feature doesn't appear to work correctly either for local or online image paths. I just see a placeholder in each case.

@Moosak Bear in mind that isn't full HTML. You are just showing the PlainText version of the RichText data in the right textbox. I do exactly the same in my rich text editor app https://www.isladogs.co.uk/rich-text-editor/index.html If you try and enter HTML features not supported by RichText...

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

When rich text was first made available with (from memory) A2003, it was buggy and got a bad reputation at that time. The early issues were fixed long ago and it is both usable and very stable. RTF is indeed a subset of HTML but it has all the text formatting features you are likely to want in...

Its good to see further development of this concept since I first floated the idea back in 2017 I had completely forgotten the thread linked in post #3 which also includes Mike Wolfe and Steve Halder's variation from 2022 using toggle buttons...

This is the link to Gustav's article; https://github.com/GustavBrock/VBA.Round

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...