Search results

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...

The only way I can replicate the OP's issue is if the Public constant vbYes is assigned to 7 somewhere in the code Const vbYes = 7 ' Text to search.

The code also works properly for me. Have you tested to create a new database with only one form with only one button with this code? Does it work?, If not upload this database.

Unless you use DoEvents , if used then several subs can run concurrently (not in parallel) as it's shown in this example: https://www.access-programmers.co.uk/forums/threads/using-concurreny-in-ms-access.331052/

This is my approach for previewing a report and not allowing to print it. I don't think it's 100% reliable, but it might be useful to someone.

I do something similar, but I also show all inactive elements appear at the end, after all the active ones.

Try disabling the Monaco editor.

Surely you know it, but just in case: https://nolongerset.com/detect-report-mode/

Well spotted.I agree with you. I've updated the code in post #45 and then I noticed that some assignments should be deleted because they are duplicated: ![ProductName] = varValue(0) ![TaxClassA] = varValue(1) ![SellingPrice] = varValue(2) ![Tax]...

I've noted that there were some issues in the OP's code because the data was being inserted into both the recordset and the form resulting in 2 records inserted for every input. (One of them blank) This is the full code I've modified: Public Sub txtProductCode_AfterUpdate() Dim lngProdID As...

Yes. This can be solved using only the .Recordset.Edit .... and .Recordset.Update property to add records. I mean: ' ![RRP] = 0 .Recordset.Update 'immediately save the record 'DoCmd.RunCommand acCmdSaveRecord If Me.Dirty = True Then...

After some tests, I think the easiest way to solve the OP's issue is what @Edgar_ has suggested: For example: Public Sub txtProductCode_AfterUpdate() ... Me.txtProductCode = Null Me.CboCancelledInvoicedata.SetFocus Me.txtProductCode.SetFocus End Sub