Search results for query: *

I have an option group with 4 toggle buttons on a form, which the user selects personnel type to show their respective records on a tabbed form. Each toggle button on the After Update, shows their respective list box listing the personnel (either Salary, Hourly, All or Terminated). When an...

I have a number of different reports each asking for certain information via parameters set up within different forms. What I would like to know, is, can one form handle all the queries for a number of reports, utilizing the visible of certain fields l and if so, how can this be called on via...

I have a report that asks the user to state a year via a input box. Everything is fine. On the report, this year must be displayed in another area of the report. Is there anyway, that this field - after update via the input box can copy the results and place the year in the other field...

I have a query which has a DateTerminated field (date format) and I would like to restrict the records to show all employees that are not terminated before a certain time. Right now if I put "Is Null" in the criteria line, it gives all employees who are not terminated. If I combine...

I have the following set up in a query to determine the Years of Service of Employees: YearsService: DateDiff("y",[YearHired],[Year]) [Year] contains the years 2000 through to 2005. This query will automate the vacation allowance of each employee. Everything calculates correctly...

I have the following code: Private Sub Employee_AfterUpdate() ctYear1.ClearDays Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim prm As DAO.Parameter Dim rst As DAO.Recordset Dim Image As String Set db = CurrentDb Set qdf =...

I have a query - see coding below that saves not only new records, but also the existing records, which results in duplicate entries to the underlying table. Is there a way that I can show the existing entries, but only save the new entries. Private Sub Save_Click() Dim cKeyID As Long...

Using the following code to populate with unique records, but I am receiving a Compile Error - Argument not Optional at the SQLOutput line, with the following code: Private Sub Employee_AfterUpdate() Dim dbs As Database Dim qdfdef As QueryDef Dim qdfTemp As QueryDef Dim rst...

I have an ActiveX Calendar (ctCalendar1) on a form - both unbound which holds text and images. I have modified this calendar to be a personnel attendance calendar, in which I have a combo box of the employees and I would like to select 1 employee and have just those records pertaining to that...