Search results

Thank you GumbyD. I understand your reply, however, I think I have been asking the wrong question. Basically I need to prevent duplicate records. If this department has been run for a day then I need to prevent that department from being run again. I need to test and see if there are...

Well, I tried the allow edits, deletions, additions, properties but that is not giving the needed results. I will try to be clearer. The date on the form is defualt to current day, and the supervisor selects their name from a drop down to bring up a list of employees in their department on...

I have an application to track employee attendance. On one main form a supervisor picks his name from a dropdown, and they enter the date. On the subform, all of his/her employees show up in datasheet view and the date is included in each record on the subform. There are a couple other...

Well the three fields that are unbound are not in the query that provides the employee name and number. That is all that query is for. It lists all the employees in the department. But then I want to enter data in the other 3 textboxes and save all five as a record in another table. But...

We needed a way for supervisors to enter attendance for their departments. So a I have a main form with a drop down list of sups. They pick and hit the command button to view a list of the employees they have. This command button on main form runs query of Employees table. Query has 3 fields...

thanks Thank You Very Much Jon K!!! It works great! Just for future reference, what does the Nz mean/do?

That worked great. Until I run into that person who took no LOA days. Then they are not returned in the QueryLOA so then there is no link between the tables and they are not included in the report. How do I tell the Query to include all employees even those who had no LOA days? Here is are...

tried... The criteria I have for Date field is: >(Now()-365) And the criteria for other fields already eliminates those coded as LOA. But I need to exclude those days that were coded LOA from the 365 criteria for the date field somehow. I need to go back 365 days skipping those code as LOA...

I have an application that tracks attendance for about 400 employees. And if they have a certain # of tardies, missed days, in a last 12 month period then there are certain levels of disciplinary action that are enforced. So I have a query that goes back 365 days. Everythings great. Until...

What is the easiest way to fill in a month textbox based on a date entered in a date textbox? For instance, if the date entered is 1/15/03 then the month textbox should fill with January, if date is 2/7/03 then month = February etc. etc. Should I use if statements or select case or something...

I have run into an unforseen problem I had two tables, one for the main form and one for the subform. A field that was the primary key in main table, had relatiohship to same field in sub table. Turns out that field can sometimes be duplicated in main table. Can I add a "Now" to the field or a...

i think I got it.. On the field that was the relationship between the two tables, there were some duplicate records in the main table, where there usually isn't but occasionally could need to be dups. So do I need a new relationship?

I have a query that returns a duplicate record for each record it is supposed to return. I have checked the tables over and over and there is only one record, but the subforms that are fed by the query show 2 exact copies of each record they are supposed to show. But even out of the subforms I...

I have a form with a subform, these are used for data entry. When a user does a filter by form on a field in the main form it brings up that record fine, but it brings up all records that have been entered on the subform regardless. So for each record on main form it brings up hundreds of...

I have a button that opens another form and has been working fine for weeks, now when you click on the button you don't see anything but a blank gray screen. This form had about three text boxes on it along with a subform. They are all still present in design view but then when I switch they...

still stuck I have the properties set to no locks. And IT guys moved Db to a new drive and set same permissions for all the users. But still get the error "couldn't update locked by user on machine...." Any other ideas?

I have an application that multiple users are entering data into. It is a split DB. On one pc I will get an error: "Couldn't update, record is locked by Admin on machine LKWTHN025909" WHY. I could understand if the user was trying to go back to a record that another user already had up on...

I have a table where audit info is stored. If something is found incoorect in a shipment, it needs to go back to inventory. Well, we log eveything and management would like to track how long it takes to get back to stock. Well, the return to stock is kept in Excel. So I import the log into a...

I have an application that auditors enter error information into. Well this information needs to go to another person in EXCEL that tracks this information and corrects the mistakes and enters the time and day the corrections are made on a spreadsheet. I was wondering if there is a way to set...

increment idea I have a report that prints on a button. Each report has a unique and incrementing number, like an invoice number. It is a textbox that is linked to a table with only 1 field and always only has one record. Each time a user (I have multiple users also) clicks the print report...