Recent content by qaaccess

Dear i have used this property to load values Me.ccid.Value = Me.NClst.Column(0). Now i want to update the information in fields which has been loaded by double clicking from list box. i am using following code but update is not working. If Me.ccid.Tag & "" = "" Then CurrentDb.Execute...

Dear it is one form, on same form i used visible yes no options for input and output fields.

Screenshot has been attached.

But i have only one form. there is not second form. So when i am giving the from name, error appears. the form name "Detail" is misspelled or not exit but i am giving the same form name.

Is it possible to load the data in input from by double clicking on data from list box ? I have single form on which both input form and read-only form is present. as i used visible property to display or not accordingly. User enters the data from input form. (It has been done) User go onto...

Yes................:)

Thanks Issue has been resolved. Now the next thing is. Is it possible to load the data in input from by double clicking on data from list box ? I have single form on which both input form and read-only form is present. as i used visible property to display or not accordingly. User enters...

Here is the following code. Private Sub updt_Click() If Not IsNumeric(Me.rejqty) = True Then MsgBox ("Please Enter the Rejected Quantity in Number(s)") Me.rejqty.SetFocus Exit Sub End If If (Me.ccid) = "" Then Exit Sub End If If IsNull(Me.stdate) Then Exit Sub End If...

Getting following error after using the tags. Run-time error '2465': Microsoft Access can't find the field '|1' referred to in your expression.

You mean i have to use tag as following ? [Code] With me If IsNull(Me.vdate) Then Exit Sub End If End with [\code]

I could not understand your reply ???

This is complete code. As i am new in programming. Private Sub updt_Click() If Not IsNumeric(Me.rejqty) = True Then MsgBox ("Please Enter the Rejected Quantity in Number(s)") Me.rejqty.SetFocus Exit Sub End If If (Me.ccid) = "" Then Exit Sub End If If IsNull(Me.stdate) Then...

Yes i have tried the following: it does not giving the error but at the same time it is not inserting the data into text field using this code. user wants to enter only in text field and does not want to enter the date, then text field data should be saved/insert into table, but it is not...

When user enter the data other than date field or when date field remain empty and user press the Add button, it is giving error. (Error 3075) Syntax Error in date in query expression '#'. while same code is working for text field. but it is not working for date field. If (Me.rdate) = ""...

I am trying to populate multiple text boxes from combo box using one table. First text box is getting populate on base of combo box value while 2nd text box is not getting populating. I have used the following to populate the text boxes, even row count is correct, But why is not 2nd text box...