Recent content by dspinner

I have created a table where people enter dates that they are "booked". I want to create a query to find those who are NOT booked on a certain date. Please help

So far so good... If I use the wizard to create a form/sub form..no problem If i use the wizard to create a from - joined form...the employeeID does not go to the "job" form...????? I want to be able to open the main form for Employee A, and when clicking on the "Jobs" button, show the jobs...

STRUCTURE: MAIN TABLE EmployeeID Lstname Frstname MI Prefix Address ZIp County Phone JOBS EmployeeID JobID Department Position Supervisor Office Phone One employee may have more than one job. So where is the link made?

The record source is a lookup query. The control source is "employeeid" from the "jobs" table

I am working in an HR data base linking two tables with a one to many relationship. In the "Main" table i have the field "EmployeeID" which is a number assigned by the HR Department. IN a "Positions" table, I have a jobID and and EmployeeID field, with the two employee ID fields joined...

It does go to the nearest 100. But we are getting closer ANd I want it to always round UP There is a function in EXCEL called CEILING, which does this, but i cannot find it in Acess....

I am in a HR data base and I want to round everyone's salary (Field name [rate]) up to the nearest 500. I use this formula Round([rate],500) But it does NOTHING. I use a rate such as 23,555 and that is the product Any suggestions?

I created a switchboard with the switchboard manager and it appeared in the list of forms. I then deleted it. Now i cannot get it back, even though it still appears in under switchboard manager in Database Utilities. Can you tell me how to recover the default switchboard?

In a database with a list of periodicals, i have a table for categories. I have a query the allows the user to type in what category they are searching for. Is there a way in that query to provide a drop down box when it is launched rather than the "fill in the blank"?

In a database with a list of periodicals, i have a table for categories. I have a query the allows the user to type in what category they are searching for. Is there a way in that query to provide a drop down box when it is launched rather than the "fill in the blank"?

I want to enable or disable fields on a form based on information in the table. The second form opens from a button on the primary form. I have tried using a macro that runs when the secondary form opens, but have had no luck. I use this under criteria: [Forms]![Employees]![Status]="Student"...

How do you disable a field in a from based on data in another field. Example: If the Employee is "part time" i want certain fields to be disabled, so an entry cannot be made.

how do you enter a calculation (such as age) into a table field rather than just a form? I want the calculation to become an entry in the table so that I may query an age range. Hope that makes sense!!:confused:

This is a simple question from a relative newbie... What is the best method to calculate someone's age based on their birthdate? It seems i get a fraction it rounds UP :confused:

This is a simple question from a relative newbie... What is the best method to calculate someone's age based on their birthdate? It seems i get a fraction it rounds UP :confused: