Search results for query: *

I am using a Tab Control on a form that I have in my database. On this Tab Control are 6 different tabs. I know there are ways to secure a database and make ir read only or give users read/write access, but what I am more interested in is how would I give certain users access to only tabs I...

I am trying to ad some security to an Access database I have created. What I am looking for is something along the lines of an admin screen I can add in Access that will alow me to add/delete users and asign rights to users. If anyone knows where I could find information on this sort of thing...

I am using an SQL statement to return some values to a table for me. What I have is a Master table where the info is coming from and going to a table called Position Change. This happens on the Before Update Event of a command button. All of that aside, the problem I am having is that if you...

I am going to try and explain this the besy way I know how. . . . . I have a form called Review. At the moment I have a bit of code running in the form (see below) which on January 1 of every year will clear out (4) text boxes and (3) check boxes. What I need to happen here is on January 1 of...

I have a report that when run it brings up a form that allows the user to select from a combo box what employee name; which each has thier own (EmpID: AutoNumber) they want viewed on the report. The whole thing is based off a query that when run has the criteria . . ...

The SQL below is what I am currently using. What I am wanting to do; if possible; is from the "Review" table I want to have a first name (FName) middle initial (MI) and last name (LName). When this query runs I want it to take the three and combine them into one column (Name) in the...

I have a table that I want to run a report off of. The table is called "Position Change" and the layout is as follows. Name Department Position DateStarted ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ John Maintenance Mower 5/3/00 Henry...

I am using the following basically as a backup. It is triggered by a macro that is set to run on the "Before Update" of the "Position" text box. When a person changes positions the information about thier old job, date they started etc. is dumped into another table for...

I need some help using SQL. I have two tables, Review & PositionChg. What I want to do here is take two columns of information from Review (position and position start) and move them to the positionchg table under (position & datechg). Review PositionChg Department - - - -...

I have several check boxes (Check1, Check2 etc.) and several text boxes (Text1, Text2 etc.). What I want to happen with the check boxes is on January 1st of every year I want the check boxes to clear out. For the text boxes I want them to clear out but only when I make changes to Text0 and...

I am using Access97. In one of the forms I am using a message keeps popping up at the bottom of the screen saying it is calculating and in the process of doing so it counts down from the current record I am on until it gets to #1; at which point I have to scroll back up to the record I was...

I have approximately 15-20 check boxes. They are used to check off whether an employee has finished particular training events. I would like to have the query list each employee who has check boxes not checked and then have it tell me also what training event it is that has not yet been...

I have a query that returns an employee's name, address birthday etc. What I need to do is have the query only return the birthday's of employee's in the current month or have the query ask what month they want birthday's for. Is it possible to have a combo box that lists all twelve months in...

I have a textbox (TextHours) where a user will enter in the number of hours trained over the period of a year and this will be stored in a table (Training). What I want to do is on 4-1 (April 1st) of every year I want this current balance of hours to be stored in the table and the text box to...

I reviewed the thread above where they were asking how to update this particular function. What I am having a problem with is getting this far. I am using two tables, one is Department and the other is Supervisor. What do I need to add and what needs to be done to make it so that when I...