Search results

How to refresh FormA's subform data when the FormB unload events is fired ? My current code in FormB is below

Private Sub Form_Current() If Me.NewRecord Then Me.OperatorTextboxName = UserID End If End Sub If there are some condition fail, how to undo the NewRecord method ?

Still can't find any solution :D

Base on the attachment above , all fields with numeric value . Could the problem raise up bcos of the unbound textbox? If i still want to use the unbound text box, how to proceed ?

Same error. Could the problem raise up bcos of the unbound textbox?

Same error.

Anyone can suggest this ? Total Price text box appear at Form footer with Control Source : =sum(cdbl(txtSubPrice))

I have made a mistake with above typing. However, if there are total of 3 records have been typed in, with the Form_Current event written, I can't delete the last record only. This means the earlier 2 records can be successfully deleted. See below attachment. However, record can't be smoothly...

If second user query result with different criteria but first user still holding the previous data, how this will affect the first user ?

My form is going to generate a dynamic SQL in VBA . I need the SQL to create a dynamic query so that I can use DOCMD to call the query in later part.. Anyone familiar with this kind of code ? Upon finish the execution, I need the query to be removed. How to do this ?

Thanks for the above code. However, I am wondering the code below is executed when I try to DELETE a record. How to prevent this because I have other codes go along after the OperatorTextboxName = UserID ?

I already have the below codes. Anyone know how to read the last row of MS Excel ?

I have attached a sample of form which is not executable because I have just started coding the form. All fields are bound fields. The attachment do not have other objects too. Upon successfully loading the form , the Operator text box should be filled up with the login ID from frmLogin (I do...

Look at the attachment below for the problem that I am having. Appreciate if there is any suggestion to me. TQ

How to trough VBA code to create dynamic table in MS Access 2003? Any sample code is welcome. TQ

I have a form with a query embedded into the form. Whenever there is change to the field to data via the form, i need to record the history. My question is at what form's event or etc event I need to write the VBA code ?

Through the Expression Builder, the most we can achieve to generate the code is up to the SubForm and NOT the textboxA inside the SubForm.

I have a VBA code as below. How to set a query which cannot delete, but can add and update ? Private Sub cmdEdit_Click() DoCmd.OpenQuery "V_Master_Drawing_Assembly", acViewNormal, acEdit End Sub

Have tried before. Error message: "Method 'Item' of object 'Forms' failed"

It doesn't work .