Search results

thanks

Duplicates I want to know in order to have a field not be duplicated access forces it to be indexed is there a reason?? Rob

thanks

employee Table EmpID EmpFName EmpLName other info Hours Table EmpID this is linked to the employee tabel and first three fields Year the primary key Month Hours month is a combo box pointed to the table months which has monthid month On the combo box it doesnt use the primary key...

right now I have a table that will store this info. employee Table EmpID EmpFName EmpLName other info Then I have a Hours Table EmpID this is linked to the employee tabel and first three fields Year the primary key Month Hours then I have a month table that is a look up to the hours...

I want to run a query so on a form it will come up in order but how would I be able to keep the order of Jan Feb Mar Apr May Jun Jul etc..... Rob

is there a way to run a query that will search in 3 fields and will look to see "Em*" is located in any of them. I know in the query you can and criteria and an or to that criterial but I want it to look in any of those 3 fields and if the word "Em*" is there I want to see it. Rob

but then on the screen will I be able to have a running total of the year. For instance if I select 1999 in the box will I have a running total of that year????? Rob

I have a table that has employee information EmpId FirstName LastName Address Dob etc.... I am not sure but I was asked to create a db that will keep track of the employees hours per month to the year. For instance for example Rob 1999 Jan 10 hours Feb 10 hours...

I would but its not up to me. Its my boss :-( but I will try to push to 2000

Does anyone know of any good webpages on access 2.0. I have the code for the notinlist for 2000 which works. But I need to get it to work for an app in 2.0. Basically it checks to see if its in the list if not it allows you to add it to the table. thanks Rob

thank you so much

Hey I am working on a db. I have attached the relationshp pic and the db: Employee Table EmpFirstname EmpLastName Address Contact etc. Paperwork table PaperworkId EmpId -linked to employee Physical (date) PPD (date) Training (date) do I need to have inforce...

I know how to take out min and max on the form I want to take out the restore button on the form. AFter clicking on that link the link on that page wont open Rob

I did that when I take the border style to none. THe X goes to dim but I can still click on it. Actually now I would like to get rid of restore icon. I can only get ride of the min and max button Rob

I would like to be able to prevent a user from clicking on the X , the _ and the restore button on my form becasue I ahve error checking and sometimes this by passes it even thought it checks it. Rob

the problem with that is on the form there is a close button. on the form. I will add this code to the save button and the add new button. But what do I do if the user tries to close with the close button. also what does the with me do?? doesnt look like access 2.0 doesnt seem to recognize...

I went to the validation macro that I created and before the first test of validations I added Setwarnings No and I stilll get that extra message when I click on the close button, or save button. Thanks Rob

Ok I am starting to get the hang of access. The problem I am having is with the macors I am checking for a validation. If its is not valid to the rule I have the macro displaying a message. Then going to that control then canceling the event. This all takes place in the before update. The...

I see. I have a questoin. I have a db that is on a network and would like to compact. Is it best to automate and if so is there a way to automate them when noone is on the db. Is there a way to test to see if the db is opened on another computer. But I guess the safe way is to wait til the...