Search results

  1. U

    Loop for DoCmd.RunSQL ("INSERT INTO tbl

    Hi All Below is one days transactions input for one day of my timesheet. There are 14 days in my timesheet (see image attached) so I would have to repeat this code 14 times, not only hard to manage, but hard to maintain. Here is the code, below, and further down my attempt at a loop. There are...
  2. U

    Timesheet Access DB templete wanted

    Hi All I am writing a Access Timesheet system, but finding too many issues to overcome. Things working A) data entry form (fortnight cycle) B) SQL to push data into table C) Error control D) Templates for certain types of trades. However still so much to do like; Approvals process and...
  3. U

    Access VBA loop, with escalating field names

    Hello All I am writing a Timesheet Access app. about 20% into it because I could not find a good sample online. (if anyone has a good one let me know). Anyway I have the data entry screen going and it collects and populates the data into a table using SQL vb script. (see screen shot below)...
  4. U

    Form: 2 Tables Reading sum of field in second table

    Hi All I have two tables 1. tblBudgets and 2 tblMaterial_Purchase_Request and one form "frmBudgets" The tblbudgets is a single record table which contains the 2019 budgets. example ID Fin_Year Insurance Stationary When the form opens using the about table, i put the budgets in the single...
Top Bottom