Search results

  1. K

    Sql for date problem

    [SOLVED] Sql for date problem I have the following sql statement to update some records to a table by a form: Set rs = cdb2.OpenRecordset("SELECT * FROM tblSpy WHERE ID=" & Me.cbxItems.Value & " And [SpyDate]=#" & Me.saleDate & "#", dbOpenDynaset) I believe that he problem is on Date syntax...
  2. K

    POS simple DB

    Hi all, I am trying to create a simple POS (Point of Sale) db. For this purpose I created 3 Tables (TblSales, TblProducts and TblReceive). The tables are linked (one to many) by product ID key. For sales I have a main form which contains 2 filtered combos so I can change the product from...
  3. K

    Delete multiple Records from Table by listbox

    Hi all, I have the following code for adding multiple records in a table (Tbl1), selecting by a form listbox (list0) and works fine:Private Sub BtnAddRec_Click() Dim rst As DAO.Recordset Dim VItm As Variant For Each VItm In Me!List0.ItemsSelected Set rst = CurrentDb.OpenRecordset("Tbl1"...
  4. K

    add record to table from a form using unbound list and text boxes

    Hi all, I have a form with 1 unbound listbox as drop down list (entypolst), an unbound text box(entypotxt) and a command button. The list box reads items from a table. I want to change a value (text) on listbox, input a text on textbox so pressing the button add a new record in a table (Table1...
  5. K

    Count Date from Text format field

    Hi All, I have a text format field with name “Finalized” that takes values as date format (dd/mm/yyyy) or other simple text or remains blank. I try to make a query (from query builder) counting the records with date> current date. For this I use the formula: Exp1...
Back
Top Bottom