Recent content by spikebears

Thanks Ann, it works after I change the default system locale. Thanks again for saving a person from hell!! Spikebears

srossbach, Did you get any error message? if yes, then what it says? "Me" is a reserve word for current form, Me.Recalc means putting a command to recalculate every field in the current form. Spikebears

it produces error or just displays nothing? if the input box is in a subform, the syntax will be: = [Forms]![myform]![mysubform]![myfield] or you can do the other way round, add an AfterUpdate event onto the user input text box to post the input value to your display text box. Private Sub...

tried! but still getting same error message.

I see! Thank you! I try this and will let you know my results.

Thanks again! I checked this issue also. The reference is Microsoft Access 9.0 Object Library and is already installed.

Thanks for your help! Those machines do not have Norton AntiVirus installed but the McAfee. I don't think McAfee includes the script blocking funtionality. Any other suggestions?

did you try the GoToControl command? syntax: DoCmd.GoToControl "your form name"

go to Expression Builder in the Properties of your text box and input (assume name of your form is Myform and name of the user input field is Myfield) =[Forms]![Myform]![Myfield]

Try using the Me.Recalc upon the After Update event for your cboUnit Combo Box. Private Sub cboUnit_AfterUpdate() Me.Recalc End Sub

I have an access 2000 program that does not work properly in some PCs (but do work well in some machines). I got the following error message: The Expression After Update you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was...