Search results

Deleting a a control field in a subform Hello bob, Here is the database, the form is frmqcplist2 The steps are 1) select a qcp document from the combo box i.e 12010 2) click display 3) subform populated with references and responsibilities 4) sub form has command9 button. click on command9...

I still have the same result bob, tries to delete all the references for the particular qcp

I have a main form that has a combo box for quality control categories. When I select a category i.e 10000 My subform get populated with references and responsibilites for this category. I have a delete button on the subform, next to each of the references or responsibilites. when I click the...

Delete a text box in a subform(can anyone help please) I have a main form that has a combo box for quality control categories. When I select a category i.e 10000 My subform get populated with references and responsibilites for this category. I have a delete button on the subform, next to...

Hello Bob, Thanks for the tip. Now it is saying method or data member not found. Can I share the database with you Captain Love

Dim rs as recordset

hello code master I am a getting an error message, it is saying user defined type not defined

Hello Code master, Thanks for the code, it is giving an error message saying user defined type, not defined. Am a bit lost

Deleting a a control field in a subform Thanks Bob, I am still getting an error message in the sql statement in my vba. This is how my VBA reads Dim sql As String sql1 = " find the references for Me.ID" rs.Open sql While rs.EOF = False (sql = "Delete * from tblreflink where refID = " &...

I have a mainform with a combo box to select quality control procedures i.e 10000 when I do select with the combo box the subform is populated with references and responsibilites. I have a text box to insert new references . I am trying to create a command button to delete references I want...

Does anyone know the delete version of this code. The code below insert values into a table. Private Sub Command8_Click() Dim sql As String sql = "INSERT INTO tblQcpList(qcpList,qcpID,comment) VALUES ('" & Me.txtList & "', " & _ Me.Combo6 & ",'" & Me.txtComment & "')"...

Error Message on database Hi bob and adam What I am trying to do is get frmqcplist should be displayed for that user/qcp combination with the comments and listitems I have added in frmfilter Errors message steps on frmfilter I add select a qcp, from the combo box 1) select qcp 50000...

I have an a form in access, that I am trying to put a command button on. At the click of the command button. Data in the form which comes from a table is transfered to a word template doc. Can anyone give me the code here. I have searched previous questions and nobody has really given an answer

Can I share the database

I have a table, tblqcplist, which I have just added a field qcpcomment and a table tbltemp which I have just added a comment field . Access is given an error no value for one or more required parameters Here is the old code Private Sub cmdDisplay_Click() On Error GoTo Err_cmdDisplay_Click...

Thank you boblarson and ajetrumpet. I am new to access and new here. That was really precise and helpful, now the error is saying no value given for one or more required parameters

Does anyone know what is wrong with this code, it is giving me a wend without while error Private Sub cmdDisplay_Click() On Error GoTo Err_cmdDisplay_Click Dim sql As String DoCmd.SetWarnings off sql = "DELETE * from tblTemp" DoCmd.RunSQL sql If Len(Me.txtQcp)...

Can anybody give me the code to connect to a word template from an access form and write a step by step instruction what I am trying to do is to have a command button on an access form, click on that form and it goes to the word template I created I can share the database

How do I filter information in my subform. My form and my subform are based on the same table. The fields are revision date, revisionid, qcpid