Search results

  1. B

    Adding queries to groups using VBA

    I have a number of groups in a particular database. These are based on the month that they relate to, but they are also split into four separate groups for each month. So for example, I will have four groups for November 2014: November 2014 Raw Data (which contains linked tables in another...
  2. B

    Subform issue

    Hi I have a database that I am struggling with that I was wondering if someone could help with please. The problem I have relates to a subform that I have created in the database. It works fine on it's own (i.e. as a separate form), but when I have it set up on as a subform on another form...
  3. B

    SQL Delete Record - Adds a new record!

    Ok, here is my code: Private Sub cmdRemove_Click() On Error GoTo Err_cmdRemove_Click Dim SQL As String Dim stLinkCriteria As String SQL = "DELETE * FROM Suppliers WHERE ((Suppliers.[Supplier Name])= '" & txtSupplierName & "') AND (Suppliers.[Supplier Code]='" & txtSupplierCode & "' );"...
  4. B

    For... ...Next Loop relating to Query

    Hi Here is my problem - I am trying to assign record values within a query (only about 30 records) to an array in order to automatically insert a debit note number. Currently I have a list of suppliers that I am going to raise debit notes on each month, and each debit note for each supplier...
Back
Top Bottom