Recent content by June7

Arnel, am guessing inclusion of word "and" with each expression was typo.

Why would record not show if field is Null?

What indicates a record is not a Revision? =Count(IIf(fieldname = "Original", 1, Null)) Or =Sum(IIf(fieldname = "Original", 1, 0))

I don't see "Recent Posts" either, there is a "New Posts". No delay for me.

Just to nitpick, you are already learning SQL. SQL is a language and Access uses it to build queries. When you use query designer to create a query, it generates SQL. Switch to SQL view to see the statement. SQLServer is a database application. And yes, there is a bit of a learning curve but I...

Two offices in same org, same network? What does "100% similar" mean? If same table structure why not 1 BE and apply filters appropriate for user? Can even have multiple instances of a form open with different sets of data for side-by-side viewing. Controlling user options for data interaction...

Which doesn't explain why posted TEST db, even with code adjustment, still fails. However, as long as you have a working file, all is good.

That command was already in code for UsersReport. I added to other report. No change, still fails. Also, as I said, I tried C&R and that did not help. Something wrong with posted file.

File does not close properly at all when windows are hidden, not even when reports are not run. Why is file size so large for so little data and few objects (download was 18MB)? Zip file is still over 15MB. C&R didn't help. I've never seen any real benefit to hiding app window. Implementing...

I bought MS Office Pro 2021 couple years ago from Flixeasy for $20. I had no issues. Here is what Bing search said about Flixeasy:

I went from 2010 to 2021 and there were a few changes, most of which didn't matter to me. Let's see what I can remember: 1. pivot table/form/chart removed 2. Collect Data removed 3. Modern Chart added (can still create old MSGraph chart object) 4. changes with Outlook means I can no longer use...

Bing search returns: It shows DevHut.net as source but I can't find that statement in the referenced page https://www.devhut.net/everything-you-never-wanted-to-know-about-the-access-modern-web-browser-control/ Regardless, empirical evidence shows it is not supported.

Note for future postings: please post code between CODE tags to retain indentation and readability - use </> icon on edit toolbar.

Not seeing HTML tags. That's the string need to see - the concatenated string, not executed result showing in textbox. Use a variable to hold it then Debug.Print. Or Debug.Print Me.txtSQL might show it.

What's the </i> tag for - italic? Should there be <i> at the beginning? Regardless, I still get color. Would have to see your compiled string.