Search results

I have been reviewing all the threads concerning this subject and I got really confused because I don't understand all the code. I am trying to copy only part of a record on a form; three fields actually: Entry Date Site Operator name The site and operator name fields are cascading combo...

Thanks for all the help for creating combo boxes. Now I have come up with something I don't know how to do. I have two tables; tblAssociate which has two columns "Site" and "Associates. There are 7 different sites and I have creating cascading combo boxes after selecting the site, the...

I have a form whereby there is a yes/no check box. The box is checked if a die change was made in printing the labels. I want to be able to calculate the die change by 20 sheets of paper to come up with a waste calculation every time there is a die change. If I put in the criteria of true...

I have created a form and on the form are combo boxes from tables. One of the fields is Operator. When I click on the combo box the list of Operators are shown and the one I select appears, but when I tab down to the next field I receive an error message that I must enter a value in the...

This is the first time I have tried to create cascading combo boxes and I have been working on it all day. My problem is when I get to the dependent combo box. I use a table source for the first combo and it is working until I enter the code for updating the dependent combo box. I have...

I have a form with several fields. Two of the fields are [Machine] and [Machine Type]. Instead of typing in the machine type, the manager wants it to be automatically filled when the machine name is entered. I want to do an IIF statement in the control source, but I can't get it to work. I...

I was asked to create two new fields on a form and I don't know if it can be done. One of the fields is Client and the other is Tag Type. I was asked if when a client's name is entered in the Client field is it possible that just the tag types be listed to select in a drop down list for that...

I have a form which was created from a table. In the form I have a Date field and a Weekending Date field. I would like to automatically calculate the weekending date from the date that is entered in the date field. Should I have created the form from a query? I have searched for an answer...

It has been several years since I have I had to create a report and my memory has failed me miserably. Anyway, I am trying to create a report where several of the totals are calculated using other columns. The total is arrived at by calculating two other columns, i.e. Total waste divided by...

I have a large report that runs a six weeks average based on the last six weeks of production. Our fiscal year starts November 28th and our weeks starts on Monday. I have used the following format to start the week on Monday Week1: (DatePart("ww",[EntryDate],2)) To set up the fiscal year I...

I have a report in Access 97 which is group by employee number and has the following totals for each employee SumOfStdHrs SumOfTotalUnits Units/Hr (this is calculated SumOfTotalUnits/SumOfTotalUnits Goal (I enter this number weekly) 85% (This is calculated...

I have been reading all the threads on joining queries, right joins, left joins, etc., but I am having problems understanding. I have two queries. Query #1 Week # Dept Empl ID Name Std Hrs Earned Hrs Total Units Query #2 Week # Empl ID Total Errors The joins are Week # and Empl ID. The...

I was reading several threads on First, Last, Min & Max Functions trying to find a way to enhance a report I have. The report I have works fine, except I have to do some manual research. The report is an attendance report where I track the number of times an employee is absent. When the...

I am trying to build a query that pulls in the last six weeks production information for each one of our employees. I have been using the beginning and ending date criteria, but in a lot of cases one week will have zero information or the employee has less than 8.00 hours, which in that case...

Referring to the thread submitted by robjones23, 1/4/05, I am have a similar problem with a report. I have a report that I pull data in that is entered on a daily basis and I convert total by week number. The report then pulls in the last six weeks for an average. The report worked fine...

In setting up a new database I had to import an Excel spreadsheet with all the information which consisted of several years of load status information. I had problems with the dates as they wanted to be text fields instead of date fields. I did a Make Table query converting the dates to the...

I have been working on this on and off for a week now. I can't seem to grasp what to do. I submited a question, but alas no response. In a form can you have an cumulative total? For example, I want to enter standard hours, then have a cumulative total, Every time the standards hours would...

If you post a question and you never receive a response, does that mean: (A) The answer is unknown (B) The person asking the question is banned from the forum unknowlingly. (C) The question was too dumb to be answered? Just was wondering. Lansel

I have created a form on which information on a trainee's performance is entered. I have to add a field in the form that calculates weeks worked. Each week the employee's standard hours are entered in the form. The next week when the standard hours are entered I want it to be added to the...

I have a report that I am trying to display numbers in red if actual did not meet the guideline. I can't get just the outside the guidelines to be displayed in red. Even if the number meets the guideline, it is printed in red. If Me.[2nd Week Eff] < 0.45 Then Me.[2nd Week...