Search results

  1. H

    avoiding repetitive records in CurrentDb.Execute InsertQuery

    I have a data entry form in which there are two text boxes named "NameTxtBoxAt1" and "NamesTxtBoxAt2" . I have wrote a VBA code which gets value stored in them and then insert them into table "UnpivotedName" in column named "UserName" along side with constant value of "1403" in column Year. the...
  2. H

    How to best shape the data structure of Monthly Sales Budget

    hello. I have designed a sales budgeting system using "MS Access" in which users can assign sales Value in addition of sales price for different months along with some other functionality. Here is the schema of the main table (tbl_SalesMonthing) over which numerous forms store data. As it is...
Top Bottom