Search results

  1. C

    Update Query On External Table Without Linking

    Thanks for your help good buddy.
  2. C

    Update Query On External Table Without Linking

    Hi, Using the IN clause I have compiled the following code: Private Sub Btn_UpdateExternal_Click() Dim dbPath As String dbPath = "C:\Documents and Settings\cvgch220\My Documents\db2.mdb" DoCmd.RunSQL "UPDATE Tbl_ChildName SET Tbl_ChildName.ChildName = ' A ', Tbl_ChildName.SchoolName = ' A...
  3. C

    Update Query On External Table Without Linking

    Is there any way of updating an external db table without using file-get external data - link table? Thanks GC
  4. C

    Error When Inserting Null Value Into Numeric field

    I have used the nz function in my query and that seems to have done the job. :0)
  5. C

    Error When Inserting Null Value Into Numeric field

    I have several text boxes which hold numeric values. Using an INSERT INTO query (which is activated on a button click) the numeric values are inserted into a number fields within a table. If one or more of the textboxes are empty and the button is clicked an error is returned. I have set the...
  6. C

    Run Time error with Update Query

    I have changed the where clause to: "' WHERE Tbl_Section_1.UniqueID = '" & Me.Tb_UniqueId & "'" and it works fine. Thanks C
  7. C

    Run Time error with Update Query

    I have the following piece of code that updates a field in a table with a selected value from a list box Dim varItm As Variant If IsNull(Me.tb_Other1) Then DoCmd.RunSQL "UPDATE Tbl_Section_1 SET Tbl_Section_1.ProgUsed =" & Me.Lb_Programmes.ItemData(varItm) & _...
  8. C

    Displaying all records in a form from an open recordset

    I have the following piece of code that returns data based on the value of ComboBox1 Combobox1 contains a list of numeric values that also include operators. the list is as follows: <=100 <90 <80 <70 <60 Dim Rs As ADODB.Recordset Set Rs = New ADODB.Recordset Rs.Open "SELECT Table1.* FROM...
  9. C

    Error when concatenating combobox value to SELECT query when opening recordset

    Thank you for your help. I am fairly new to this method of programming, but it is all starting to make sense.
  10. C

    Error when concatenating combobox value to SELECT query when opening recordset

    I have the following piece of code behind a combobox on a form in Access 2003: Dim RS As ADODB.Recordset Set RS = New ADODB.Recordset RS.Open "SELECT field1, field2, FROM table1 " & _ "WHERE field1 =" & Me.combo1, _ Application.CodeProject.Connection, adOpenStatic...
  11. C

    Drop down list data for query criteria

    JZWP22 thanks for your help.
  12. C

    Drop down list data for query criteria

    Thanks, that clarifies why my original method did not work. Do you have an alternative solution? Thanks C
  13. C

    Drop down list data for query criteria

    Hi Thanks for your reply. The example DB you have attached is not recognised by my PC. I have Access 2003 running on this machine. Could you please reattach. Thanks C
  14. C

    Drop down list data for query criteria

    I have a drop down menu within a form that lists operators that will be used as criteria for a query. The list is as follows: <=100 <90 <80 <70 I have a query with a field called score. Using the expression builder the query looks at the selected value in the drop down list and filters the...
  15. C

    Opening Continuous Form as Report

    I have a continuous form set up that returns data on over 100 records. I have set up a command button that opens the form in a report template. The following code triggers the report: DoCmd.OpenReport "Rpt_Test", acViewPreview, , "[cohort] = [Forms]![frm_pupil_dets_ndcArea]![NCY]" The...
View older results
Back
Top Bottom