Search results

  1. C

    Error On VBA code

    I get an error after the group by statement in my VBA code saying expected: line number or label or statement or end of statement My VBA is greyed out, after the group by clause. I suspect the error is before that. I have spent six hours on this. Can anyone out there help Sql = "INSERT INTO...
  2. C

    Filter Problem on a subform

    I have a main form that has two combo boxes, txtuser and txtqcp. My subform has revision date and revision text controls I want to filter revision date and revision based on the selection I make for a txtuser and txtqcp(i.e user BP and qcp 10000) so that on my sub form it would have the...
  3. C

    After update event

    I have a main form with a combo box, containing a list of qcps(numeric values) on that main form is a text box to add to my subform data like references or responsibilities for each qcp i.e 10000 The problem is that when I add data to the text box and I click accept, which insert the value...
  4. C

    Error on VBA Code

    I am getting an error on my select statement with this code and the if statement. Can anyone help Private Sub txtRevisedCost_LostFocus() sql = "select * FROM projectupctable WHeRE Prj_no = '" & Me.prj_No & "' AND upc = " & Me.UPC" rs.Open SQL, CurrentProject.Connection, adOpenDynamic...
  5. C

    Changing the Value of a Row in datasheet View

    I have asked this question before, but I guess I am not making myself as non of the responses work. I am attaching a copy of the database to clarify matters. My problem is when I change the value of a row in datasheet view for a particular control, the whole column (Revised cost) in datasheet...
  6. C

    Dataset

    How do I make a dataset not updataable in MS access
  7. C

    Revised field on a form in datasheet view

    I have a datasheetform that takes it value off a query. In my datasheet form there is textbox that has a value (unit cost),that it take off the query that feed the form. Then I have an unbound textbox(Revised cost) whose control source is unit cost. So I have two textboxes with the same...
  8. C

    Revised field on a Form

    I have a datasheetform that takes it value off a query. In my datasheet form there is textbox that has a value (unit cost),that it take off the query that feed the form. Then I have an unbound textbox(Revised cost) whose control source is unit cost. So I have two textboxes with the same...
  9. C

    Delete sql statement in a subform

    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...
  10. C

    VBA Delete cod

    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 & "')"...
  11. C

    automation of access form to word(code0

    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
  12. C

    No Value given for one or more required parameters

    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...
  13. C

    Wend with While error

    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)...
  14. C

    Connecting to MS word from ACCESS Forms

    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
  15. C

    Forms

    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
Back
Top Bottom