Search results

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

Try changing: Me.txtProductCode.SetFocus To Docmd.GotoControl "txtProductCode" At the end of the procedure.

The file has been scanned on this website: https://mark0.net/onlinetrid.html and this is the result:

Hi Jason, I think there are 5 missing attached images. These are the errors in Spanish: From Pass1of5.bmp to Pass5of5.bmp ...

If I'm not mistaken this is the link: http://kallal.ca/Articles/Pdf/Merge.html

Sometimes some extrange behaviors have happened because of non printable characters on some fields. Nowadays it's common to copy and paste data from some webpages and it's common to copy non printable characters to de database and then... - Some comboboxes don't populate properly. - Some reports...

In his article ******** explained that the way to execute applications in a form is different depending on the application. The code he published allowed to execute the PowerShell ISE in an Access form, but not any application with that approach.

Jason Lee Hayes Bad news, ******** is going to step away for a bit.

@theDBguy It doesn't work for me. If I change the underlying image without changing its .Picture property executing a form .Refresh doesn't update the image on the screen.

Have you tested to reset (set again) the .Picture property? I've tested it and after reseting it the image is updated on the screen

Perhaps you could create a ACCDE database that links your BE database tables with read only access.

To completely uninstall MS Office 365 I always use: Uninstall Microsoft 365 from a PC Instead of uninstalling Office 365 with the computer uninstaller.

If you want or need to change the SYMBOL_NAME description after being selected, you have to assign the value in the Symbol_Stock AfterUpdate() event: Me.Symbol_Name = Me.Symbol_Stock.Column(1)

I think that the attached database shows the OP issue. I say it's the normal behaviour.

As far as I know, when the first column displayed in a combobox has duplicated values, it always returns the first one.