Search results

To list the names of the available printers, save this procedure to a standard module, and run it from the Immediate window: Public Sub DumpPrinters() Dim p As Access.Printer For Each p In Access.Printers Debug.Print p.DeviceName, p.DriverName, p.Port Next p End Sub

What phone system are you using? If a business class phone system, I may have a possible solution.

It is not recommended to use Reserved Words like Type and Group for object names. https://learn.microsoft.com/en-us/office/troubleshoot/access/reserved-words

Amen to that. Do not fall in the trap of temporary solutions. They may be around for a long while. I agree: keep the local cache in place. It works. Don't mess with it. The new-ish Cache settings in Options form are not for your scenario. Leave it alone.

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.