Search results

You added the new field. You just need to change the controlsource for the Total textbox in the subform to the new field. The data in your table didn't match the format you said it should be.

edit reading fail you need to remove the criteria and paste into the field row

I see. I've never used macros. The where condition with 2 equals looks odd. Naming a form rpt_ looks odd. If you post the converted vba that might help. Better yet a stripped copy of the db.

You have put the string function in the criteria row. Criteria is used for filtering. Instead of Total you need to type what I wrote above. TrimmedValue: right([total],7) Where TrimmedValue is the name you want to give the calculated field. Right gets the right of the string you pass in, in...

Well, your doubleclick event isn't doing anything so the error is either in the click event or your form is corrupt. You also need to look at the actual doubleclick property for the control. If doesn't say [event procedure] and isn't blank it's probably running some other macro not the code you...

The event isn't doing anything. Remove it. You really shouldn't be using click events on text boxes. As said in your other thread, that's what buttons are for.

If you keep the original value... You would put that in the control source of a textbox or a field in query TrimmedValue: right(total,7) which is the source for a control. You didn't answer the first question. If you paste the value into a control you would strip out the unneeded part in...

Where does the value come from? Do you need to keep the original value or just the trimmed result? If you store and need to keep the whole string you can just use a calculated value in a field or control. =right(total,7)

Yeah, I know what it is. I know XML so no need to learn something else that does the same thing. Glad you got it sorted. :)

If it's the only value in brackets value = Split(Replace("062963340006 003 B003SEP2191558BA0423 2 (300)", ")", "("), "(")(1)

I don't know JSON. I guess a group within a group would need a name, so if a name isn't given for the container group ask if it should have one?

A form can only be opened once. DoCmd.OpenForm "frmPurchase" DoCmd.OpenForm "frmPurchase", , strWhere The second openform will be ignored. That's why you have code in there to make sure it's not already open.

If you want to see the workbook replace appXL.Quit with appXL.visible=true

Who are you asking?

You can make an Access form function like a datagrid by creating your own recordset or using a disconnected rs Dim adors As New ADODB.Recordset Private Sub Form_Load() 'create rs Set adors = New ADODB.Recordset With adors .CursorLocation = adUseClient...

Double clicking fires these events: MouseDown MouseUp Click DblClick MouseUp Only one mousedown but two mouseups? And you can't have both a double and single click event because they both get fired. Double clicking on text selects the clicked word - which Access does after the user event...

I'm not talking about mistimed clicks. I'm talking about the way Access handles double clicks can be a bit bugged.

I don't know what you mean. Double click doesn't work, the code I posted does. In my code the double click is used but only to identify that the user double clicked. It doesn't 'trigger' anything.

Access doesn't have a proper double click event. It times two single clicks, so it doesn't always work the way you want. Dim goend As Boolean Private Sub Task_Update_DblClick(Cancel As Integer) goend = True End Sub Private Sub Task_Update_MouseUp(Button As Integer, Shift As Integer, X As...

5-10 minutes to add a record means a badly designed database and a slow network. There is nothing you can do in Access to speed up the network.