Recent content by melodyF

Need some advice on building a query.. I'm utilizing 2 tables: Region,AccountData The region table contains 35 regions.I'm using Prin_Bal and SScore fields from AccountData. The AccountData table contains around 50,000 accounts each containing a prin_bal and SScore. I need to sum the prin_bal...

have an Access Database trying to utilize Sequel Server as my back-end. I have set-up a odbc connection, but when a user request data, they have to enter the connection criteria(username & password). How do I code in Access to automatically pass this info. If somebody is currently doing this...

I have a form I want to close when I open another. In the form I want to close I have an ID number that is being passed to a filter query that is used in the form that should open. I have tried alot of things that don't seem to work. I know when you close a form, the code basically stops...

I hopeful there is an easy way to do the below. I'm tying to add up my employees 1/2 day Leave and full day leave to get total leave. The only I can get this to work is to write two queries then put them together. Is there any way I can get this answer in one query. I have sickdays, FMLA...

I'm trying to delete a record from mu subform. If I hightlight the record and press delete on the keyboard or highlight record and delete from menu it works fine. I can't seem to get it to work using a button on the main form. I have a relationship between the main and sub form using employeeID.

I'm trying to use Dlookup to pull a value from a query into a report: ThI want the Salary where the field section is BankPro.. =DLookUp("Salary","qryChartQtr2","Section = BankPro") The value of BankPro is text. Thanks for the help...

I'm tying to get a procedure to work in a module. I have Access Security Installed an want to supply my own error message and routine. I know I'm doing alot of things wroung. Any help would be appreciated.. Public Sub ErrorHandler() On Error GoTo ErrorHandler Dim msg As String If...

The frmSummary is the a subform that contains both the fields Salary and EmployeeID. You are correct in that I'm using the AfterUpdate Event of the Salary field. The salary is not filled in. It should be pulled from the Employee table using the EmployeeID. This allows me to update the results...

Jack, the above works to a point. The Salary will only show if I try to type something in the field, then it will pop up. Any suggestions?

Jack, it works to a point, the salary will not show in the field or be captured in the table until I type something into the field and only then does it show. Any Suggestions?

I have two tables "tblEmployees and "tblResults", the employees tables holds current salary dollars and results holds incentive points, etc. My relationship is a one(Employees) to many (Results)using EmployeeID as the key. For each new record input in the Results table I want to pull the current...

First, let me say the experst on this site are the best........ I have two tables "tblEmployees and "tblResults", the employees tables holds current salary dollars and results holds incentive points, etc. My relationship is a one(Employees) to many (Results)using EmployeeID as the key. For...

My query sums up 3 months of data (quarterly) Employee data. My problem is I have a field called Disqualifier. The Disqualifer can be null or can be a numeric 1-7. If I do not enter a disqualifier, for example in January and February, but enter one for March I get two entries for the...

Overview of problem: The query I have consist summing up employees Ind Points, Team Points, and calculating payouts and potential payouts using my month and year field for my criteria to break my data down into quarer years. Jan,Feb,March w/ year 2002 would be QTR1. I also have a field in my...

I have a select query with a calculated field, Potential Payout: ([Total Points]-50)/(200-50)*0.12. I have other fields called Actual Payout and Disqualifier in the query. My question is how do I get the Actual Payout field to = 0, if the disqualifer field is not empty.