Search results

  1. C

    Barcodes and VBA

    Here is the scene: DB1.mdb contains two very simple forms and a table frm1, frm2 and tbl1 tbl1 contains these fields: ID#, Name, Type frm1 is a Tabular form that has three objects: ID#, Name, Type frm2 is a Justified form with two objects: Text0 and btn1 What I need to do is use my barcode...
  2. C

    Counting Dates

    Here is my table: tbl_tc Name Date Tech_Name Issue Resolved Resolved_Date In Out I need a query that will do the following: Total Number of: Tickets Open (IE, Date field is populated, but Resolved_Date is not) Tickets Closed (both Date fields are populated) Total In Total Out Total By...
  3. C

    A little help

    Here is the skinny: tbl_tc contains these fields: id (linked to tbl_tcadmin.id) user name user id site location tag # tag #2 equip type date of call issue tbl_tcadmin contains these fields: id (linked to tbl_tc.id) tech name trouble shooting resolution date of resolution frm_tc all of the...
  4. C

    Brain Dump

    I have a lookup form that is basically one combo box that holds my user names (Combo0). I need to use the afterupdate event to open my form (frm_tc1) and filter that users records. If no records are found I need it to prompt me to add a record. If yes is selected I need it to open frm_tc1 in add...
  5. C

    Multi-Select Form

    I would like to create a form that my users can select multiple check boxes from and have only those records that meet the criteria come up in a search. See attachment for a look at the form. I need to be able to let the user have the ability to put in a name and then select any of the check...
  6. C

    Date Calculation

    Here is the scenerio: I have two tables: tblDate: Contains on Months (i.e.Jan, Feb, Mar, etc) tblActivities: Contains 4 fields Name, date, activity and hours I have greated a form that allows me to select what month I want to see. It has a simple combo box in it that point back to tblDate.date...
  7. C

    Query Date and Hours Fields

    Ok I have a tbl with the following fields: Name Date Activity Hours I have a form with these fields on it and two additional fields: Total Hours Hours this Month Those fields need to do just what they say, calculate the total hours and calculate total hours for the current month only. Here is...
Back
Top Bottom