Search results

I'm sorry. I am afraid you're missing the point, apparently. To help you understand, let's take an analogy of two warehouses, each constructed of concrete walls, two feet thick. Ceiling and floor also thick concrete. One warehouse has a single entrance. It's a door made of 3 inch steel plate...

I guess the word "context" means nothing to you.

Against whom should it be secured? Who, exactly, are you worried about? Your users? External actors? Others in your organization? Again, the point is that a blanket assertion does not make sense because the context determines the relative degree of security required. If your database...

PMFJI at a late point, but there's a key factor that you need to revisit, as theDBGuy said. While you can do a great deal to secure an accdb, you can't get to 100% security with Access. Colin is widely recognized as an authority on Access security and has written articles that can help you get...

I invested in a good desktop microphone to avoid the problems with headset microphones. It still requires me to be careful about where I place it in order to pick up my voice properly. https://samsontech.com/products/microphones/usb-microphones/q2u/

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.