Recent content by xavier.batlle

I've tested the arnelgp code indexing on the Region field and it's surprising how some Dcount() improve their performance and others don't. === Withoud indexing============== DCount("*", "SalesRecord", "Region='Europe'") Result: 271901 in 0,14453125s DCount("Country", "SalesRecord"...

I'd like to add that if there are Null values in the column you are counting you may get unexpected or unwanted values. DCount("*", "SalesRecord") Result: 1048575 in 0,015625s DCount("Country", "SalesRecord") Result: 1048570 in 0,125s DCount("1", "SalesRecord") Result: 1048575 in 0s

C&R means Compact and Repair. I'd also suggest to decompile the database.

You have to unlock the subform on the Private Sub cmdAddNewRecord_Click() event Me.sfr_PcsSetBOM.Locked = False

If you wnat to achieve something similar like this: There are several ways to achieve it. This is my approach

Wait! It works for me if I assign a letter to the shared folder:

You are right! It doesn't work on a shared folder!:(

If by "remote directories" you mean, shared folders on the server, sure! I haven't tried it yet, but I'm sure it will work.

Perhaps another approach could be, to create an asynchronous File System Watcher using WMI Events. If the SQL Server is able to create a file in a folder that MS Access is monitoring then the MS Access Application can do some stuff when files are created in this folder I've never used it but I...

According chatGPT it's possible, you'll have to research the topic. This is some of the information I've found: A) Start MS Access remotely via PowerShell Remoting (background) 1. Enable remoting on the remote PC (once) On the remote computer (as Administrator): Enable-PSRemoting -Force...

After some research, I came across that it would be possible to execute a remote instance of MS Access Using PowerShell, so you could execute that instance using /cmd command to execute whatever task you wanted. It's not a piece of cake, but it seems it's a real possibility (I've never tried it)

And also the Mask (Textbox Property) that's used when you enter data in the textbox.

Can you upload this database with only this form or part of it to see the issue?

BlueSpruce, Out of curiosity, only for testing, have you tried to delete all the database objects the except the form with the button with that issue? or Import only this form in a new database? (I know you've said if you import all the objects in a new database the behaviour is the same)

I don't know if this will help: https://learn.microsoft.com/es-es/office/vba/api/access.printer.printquality Private Sub Report_Open(Cancel As Integer) ' VBA constants 'acPRPQDraft 'acPRPQLow 'acPRPQMedium 'acPRPQHigh Me.Printer.PrintQuality = acPRPQDraft ' Draft...