Search results

The OP is speaking about 64-bit *Office*.

Zero code needed. Read up on the command line switches for msaccess.exe, especially the /x switch.

Not easily. You can use a non-proportional font; that will make it easier to line things up. You can experiment with Rich Text setting for the textbox (and underlying field, if any) and format the list using HTML. Me, I would use 1 small textbox, and only display the text from the selected row...

> So I opened the A2019 version in A2010 Software is rarely forward-compatible, R&C notwithstanding. A2010 is no exception. Development should always be done in the lowest version you need to support. Btw, did you know you can run the full version of Access with the /runtime switch to simulate...

Seems to me you want the path to be: Environ("USERPROFILE") & "\" & "yourdatabasename.accde"

Open a command prompt (cmd.exe). Type: SET The list contains all available environment variables. Note the one called USERPROFILE. Use the VBA function Environ("USERPROFILE") to return this string.

One thought is to create a Catalog report, similar to the one in Northwind 2 Developer Edition template, and run it in Report View (rather than Print Preview). That makes the report sensitive to mouse clicks on the various controls. The code-behind can then find out the PK of the record you...

I sympathize with this dilemma, but trying to hide the tables in Access is not the way to protect your intellectual property. Maybe you can open a new thread: "How to protect my intellectual property residing in Access tables" and we can suggest some options.

I was not clear enough. What you call "hiding", Excel calls "bah humbug" and ignores the Hidden attribute. That is not really hiding then, is it? That is what I meant with my comment "Hiding tables is not really possible in Access".

Hiding tables is not really possible in Access. You'll need to look at a server-class database engine like SQL Server if that is your requirement. Also, your "tblQ*" tables seem in conflict with a proper relational database design, so maybe Excel is a better environment for you. Make sure you...

The join line between two tables indicates that the values in the joined fields must be the same. Looking at your Grade and Student tables for example, you are saying that GradeID and StudentID must match up. But that is wrong. The join line should be between Grade.StudentID and Student.StudentID.

Here is the video with the Inventory presentation:

What are those? Do you have a link?

The version number is displayed in the application title bar, and is also a constant in modGlobal.

I have seen this behavior as well, if the db was saved to a non-trusted location. For me it helped to decompile the application. Search online for "Access Decompile" and you will find plenty of leads on how to do that.

The loop eventually arrives at cmb_Client. You then set focus to it, and hide it. Kaboom! One idea is to create a 1x1 pixel command button, transparent, and set focus to it before entering the loop.

To silence all timers, I use this code: Sub silenceTimers() Dim frm As Form Dim ctl As Control For Each frm In Forms If frm.TimerInterval <> 0 Then Debug.Print frm.name, frm.TimerInterval frm.TimerInterval = 0...

Do you see the same behavior in another database, say one of the templates (File > New)?

I doubt many potential customers see that as a good thing. You become the single-point-of-failure. If you get hit by a bus, or (hopefully) by the winning lottery ticket, POOF, you and their investment are gone. Compare that to someone who answers: "I use mainstream coding style and tools from...