Recent content by ecupirate

I have the below SQL Statement behind my form. I want my txtAugust field to show 0 if I don't have any entries in the table for the selected employee. I will use the zero for other equations. My problem is if there is not an entry I'm can't get a zero returned.. strSQL = "SELECT...

I would, but I display the text values in the calander and on some reports. I'm just learning SQL and thought there might be a way to code in the statement.. Thanks..

In a module, I'm trying to count 1/2 Sick Days and Sick Days(which would be a full day). The below statement will count Sick Days in the table. How do I change to count 1/2 sickdays as 1/2 and sick days as 1. Example in the table I have: tblInput Table InputText field : Sick Day 1/2 Sick Day...

How do I code a Date/Time field in a select statement to say: IsNull or < #3/11/2002. I keep getting a criteria expression on the IsNull. I want to display the data if my table field is empty or is < the the above date.. Thanks in Advance...

I"m trying to lookup a value in an Employee's table and when a new record is added and put that vaule in my Results table. The value I'm looking up is a Yes/No field called active. I have used Dlookup before and it works. I'm not sure what I need to do different for a yes/No field. Below is...

Yes, I don't know where to put a routine to catch the 2063 Acess permission error. And I'm not sure how I should write it. Petty new at this...

I have Access Security set-up on my db. Question: How and where do I code to set-up a custom Error message procedure? You really can't understand the ones Access provides.. Thanks

Form Coding Help I would like a suggestion of how to do the below. My database consist of eight different departments with their salary information. I have built 8 reports & 8 Queries that contain the exact same info except the department, my goal is just to build one report and one query...

I'm kinda new at setting-up reports... The fields I am using are EmployeeID,Employee, IndPoints, TeamPoints and Month, Year,PotentialPercent,and ActualPercent. Each month is a diferent entry in the table/Query consisting of IndPoints,TeamPoints, etc. I want my report to look like the below...

I have two combobox(fields) Period and Year I want to keep any duplicate combinations out of my tblResults table. I do not want the same employee to have 2 entries for March 2002, etc.. My relationship from my tblEmplyees is EmployeeID and my primary key in the tblResults is ResultCount. I...

Figured it out.Thanks

I have a combox (cboDept) which filters another(cboEmployee) on my form. On AfterUpdate of my "cboDept" I have Forms!frmEdit!cboSelect.Requery which works and gives me my employees for the Dept selected. My problem is that the first employee listed after requery remains even if I select...

I have a query pulling from two tables. Both tables have a salary field, not good design, but built this way for a reason. Question in my query how do I make the salary field in table 2 = the salary in table 1. When I run my select query. Really don't want to use an Update query.. Thanks

I have a ComboBox with a value list of the months, January,February,etc.. I want to set the default to be the current date plus one month. For this month, I would like the default to be May.. Thanks for any help