Recent content by ckeezer

Sorry for taking so long Ok, I am going to change the way my inventory is housed. I used to house it by Product number vice barcode number, but it seems that it would be much easier to find the complete barcode number that I am looking for rather than part of any one of them. I need them to...

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...

I should have been more specific, The field names all have the control identifier at the begining: txtName txtDate cmbTech_Name memIssue cmbResolved txtResolved_Date cmbIn cmbOut sorry about that.

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...

read the article he has on enabling/disabling controls, based on User Security.... I am getting all sorts of errors... with regards to the first line of code: If mainswtich board form has buttons to add, edit and report on records,you may set up a workgroup of accounts that may only report...

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...

No it is and unbound combo box.

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...

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...

Tried but failed Here is what I have in the Where Clause now: Month([tblVolunteers]![Date])=[Forms]![frmMnthSelect]![Date1] Date1 is an Unbound Text box and the forms controll source is TblVolunteers, my main tbl. I keep getting error: Enter Parameter Value: Forms!frmMnthSelect!Date1 When I...

Ok, How can I pull the records for multiple years then? Will I need to setup a Month and Year selection? Also, since I obviously am not doing to well with the code, can you get me going. All I need is a hint or two I do not want anyone to write the code for me. Thanks Chuck

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...

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...