Recent content by GPGeorge

Some people have resolved the problem by recompiling the accdb. Try that. Also make sure it's in a Trusted Location.

I've used ChaptGPT and DeepSeek. The latter only to test, really. Yesterday I tried Claude after a long fruitless session with ChatGPT. I received a working response out of the gate from Claude. ChatGPT had had me going in circles on the same task for hours. If that pattern holds, I think...

My favorite learning technique has always been. "Try it and see what happens."

You have two lines. The first one opens the report for Preview on-screen. It contains a filter: "EWNID=" & Nz(Me.EWNID, 0) The second one sends another copy of the report to PDF. This is a different copy of the report, not the one just opened for Preview on-screen. It has no filter. Add your...

Broad, open-ended questions are not good fodder for a platform like AWF, unfortunately. You can invest dozens of hours in researching the pros and cons.... Asking people here to invest that amount of time on your behalf might not garner a strong response. Let ChatGPT invest its time on your...

Yup.

Yes, if you rename a .accdt to a .ZIP extension, you can open it and examine all of the files in it.

Inasmuch as I've downloaded and installed the template multiple times, and you installing them in the same Trusted Location on your computer, I don't know what else to suggest.

"sql server has Outer Join, Access does not" Access has Left Outer Join and Right Outer Join.

I've seen comments indicating that is a good idea to fully qualify the alias, in order to be explicit and unambiguous. FROM employee AS e I'm not sure I'm convinced, but it can't be bad to be as explicit as possible, IMO.

My understanding is that VBA7 is only useful in determining whether the accd is running in a version earlier than Access 2010. I.e. VBA7 was released with A2010 IIRC. As people replace older versions of Office/Access, the VBA7 compiler directive is less and less useful. If you know users are...

One should never rely on "first" or "last" in an unordered recordset, as theDBGuy already mentioned. "Last" is a relative position, not an absolute position. Think of it this way. Each time a horse runs a race, it could be: first across the finish line for that race, or it could be the last...

This is a homework assignment for a class you are taking? If so, we can offer suggestions for you research, but it would be wrong to do it for you and cheat you out of the chance to learn by doing it. The technique you probably want is generally known as "Cascading Combo Boxes". It works with...

Thanks for the update. Good luck going forward.

I need the accdT file from which the accdb is created. When you install the template, a download file is first placed on your computer. Look for tf22238896_win32.accdt or perhaps, tf22238896_win64.accdt if you installed it with 64 Bit Access. Thank you.