Search results

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

Actually, AWF is UK-based, but by no means UK specific. We all try to be aware of the many international issues, such as date formatting, that everyone confronts everywhere in the world. What matters primarily is the work flow you are implementing for the specific context in which it will be...

How much have you studied the process of Databasae Normalization? You have an Excel spreadsheet, which is usually not the best starting point because it is "wide" as you say. Overcoming the tendency to think in "spreadsheet" can be difficult. So you have to make a serious effort to approach the...

In that case, the SQL Monaco editor is not available and not a factor for your decision.