Search results

Have you considered exporting the data required into the Excel report?

One of the biggest hurdles for people learning how to create relational database applications with Access can be familiarity with Excel. Ironically, the more you try to replicate Excel in Access, the harder it is to produce a viable application. In other words, trying to make this Access...

I have an anecdotal story of a discussion between the head of a data extraction program and a Google Gemini engineer. Without identifying specifics, the actual conversation included the Google employee wanting to base an AI prediction on the assumption that the outcome of a particular...

@moke123 beat me to it. "Cloud" raises ugly questions about where this back end is actually deployed.

Well, I would at least look at PowerApps and the rest of the Power Platform. It has the advantage of being part of the Microsoft ecosystem. Creating a hybrid application, with an Access interface and a PA interface for mobile devices, bridges the gap to a large extent. The data can be in Azure...

Have you looked at browser-based alternatives? What do you think of any that you've tried out? I happen to think that Access developers sell themselves short by not considering additional tools--not necessarily replacements for Access.

As I said, I have skin in this book publishing game, and that makes me less likely to give the issue a wink and a nod. It makes no difference if another copy of this book is ever printed or sold. What matters is that John and Jeff, both of whom I know and consider friends, along with the...

The extra materials are distributed as a PDF. I assume they are intended for purchasers of the book, but I don't know that one way or the other. I don't know about the PDF of the whole book. If it was available to someone who also purchased the paperback, turning around and giving it away free...

Her's the part that set me off: "...there is also the full book a as PDF with the full 1,868 pages." No one has the right to give away the full book as a PDF without the Publisher's permission. My first book is available as a PDF from the original publisher, if you want to buy it in that format...

Ahem, as a book author, the thought of having someone create PDFs of one of my books and posting them anywhere so that I no longer receive royalties from sales is rather appalling to me.

The Northwind Developer Version illustrates the tables needed for invoicing as well as the invoice reports. A simpler version, Northwind Beginner, might be an easier place to get your feet wet. https://support.microsoft.com/en-us/office/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb

It's probably environmental then, and those problems are really hard to pin down. What other software is running on each computer, in addition to the Access FE? Anti-virus program? Backup program? (See my comments about OneDrive for Business.) How about the location of the FE respective to the...

Elaborate please on scanning the QR codes with a smart phone. It's not quite clear whether you are already doing so, or if you are just saying that it is possible. If it is now being done, how is that data stored when you scan it? WHERE is it stored now? In the Excel sheet? You might want to...

Are you going to account for the length of time it takes to brew a batch of beer? Are you going to account for ingredients used in different styles of beer, e.g. hops, flavorings, malt? Are you going to account for inventory of beer kegs? Are you going to account for locations of the bars where...

I received your Private Message with replies disabled so I can't respond to it in kind. At this point, everything that needs to be said has been said anyway. The best of luck to you. Fortunately, the ability to ignore threads and posters is available in this forum; I'll avail myself of that...

Self awareness goes a long way. Your very first post here included this line. "Maybe it is better to stick to programming things where you have enough studies and skills." You came to a site that has been operating successfully for a very long time, with a well established culture. And the...

I did try for a few days to modify the schedule of backups and folders included in a back up and decided it was just not worth the effort for a computer I only use once or twice a week.

FWIW. I finally isolated slow downs with 100% disk usage on my second computer to OneDrive for Business, which I have since removed. Performance is back to normal again.

That's pretty much how I see it. Each time a record gets updated by the DM, the recordset itself changes, so the listbox refreshes itself. Maybe Access has to validate whether there are changes to any of the records to do that? How that differs from a direct update in a recordset loop I don't know.

Okay, sorry about that. I think, from a few trial runs, that what you are probably experiencing is that the listbox is updating itself as each of the records in its recordsource is being updated by the VBA procedure. That suggests it's primarily down to interface overhead, rather than the...