Search results

Depending on your environment, writing down passwords isn't the end of the world. Nobody comes into my home office except my 3 year old granddaughter looking for scissors and paper and pencils. I have maybe 3 years before I have to worry about her stealing my passwords, I hope. She, could, on...

This is highly indicative of the problem of a lack of a persistent connection when multiple users are connecting to a back end on the network. Albert, for one, has already explained this extensively.

"The key word here is ‘format’. SQL uses the underlying value ( what it is) not the formatted value (what you see), which is why you should never format fields at the table level." I know. My bias is showing.

There is a basic example of invoicing in the Northwind Developers Edition template. Consult it for ideas on creating invoices. https://support.microsoft.com/en-us/office/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb As a general rule, one does not need to store totals as...

It was inspiring to see an approach that eventually will result in a Monaco query editor in a form where maintenance or enhancements to an existing database can be handled without having to launch the SQL editor or shell out to another application. Moreover, Ben provides a really solid look...

The video is now live on YouTube.

@KitaYama While I can't share the accdb, I can confirm that with the legacy browser control I used to be able to log in to a site. I asked Claude AI for a version that would use JS to log in with the Edge browser control, but I failed to get it to work. Fortunately, it's not that big of a deal...

The one feature which I believe might be a problem would be support for Large Numbers and Date Time Extended, which alter the accdb irreversibly, IIRC.

Although the color looks more pink than red to me, it is the case that the calculations are done as Bob indicates.

If this process is repeated during the day, it might be wise to move the temporary, local cached tables to a throw-away accdb to avoid bloating your main accdb. There are multiple examples of that technique available.

BTW, Colin. Claude cites you as a resource. (y)

Claude reports no such official confirmation from Microsoft. I suspect Chatty of conflating the known delay problem with your reported problem of never loading at all. Here's the full prompt and response: I am seeing a report that the SQL Monaco editor in Access is not working correctly in...

Under the covers, I'm convinced Quicken actually stores the data this way. I've completed enough transactions involving "accounts" and "categories" to be comfortable with that assumption at any rate.

I regularly used this approach for client work. Column 1 (index 0) is the Access-friendly name. Column 2 (index 1) is the human-friendly name. Win-Win!

I agree with Ron. It's all about supporting the user. If you force the user to a) remember the EXACT name of the report, and b) type it correctly, you provide two failure points. If you allow the user to a) scroll a list of available reports and b) click on the one they want, you eliminate...

Yes, we missed you. I should have the video uploaded by next Saturday.

Confirmed. I have Windows 11, version 25H2. 2026-01 Preview Update (KB5074105) (26200.7705) installed. Microsoft® Access® for Microsoft 365 MSO (Version 2601 Build 16.0.19628.20166 Click-to-run) , updated just now. The same PDF now opens in both the IE webbrowser and the new Edge...

I can't quite get my head around this. Yesterday or the day before, I updated Windows 11 and M365. After that I saw the failure to load the pdf in the web browser control. Today, it loads again. I am now updating M365 yet again and will follow that with a check on Windows 11. However, it is...

It might help to show us the code that tries to send the email. That would allow us to examine the process and identify potential issues in it.

Thursday, February, 5th, 6:30pm Pacific This is a rare chance to watch a work in progress. Join Ben for an intriguing chronicle of his AI assisted journey so far. Ben will describe the anticipated outcome of the project and the progress made to date. He’ll share the insights, frustrations, and...