Search results for query: *

I have the following in a range of statements but the form isn't evaluating it correctly and is grabbing the wrong number. I am sure it is the way I am putting it together and would appreciate some help in getting it to work. The ranges should be clear of what I am looking for. The code...

In building a new database I have run into a form level problem that I just cannot figure out. The form has a subform for quote details in it and I am getting a quote record for every record in the details area. 3 details records; 3 quote records and all 3 quote records have the same detail...

Thanks for opening. I have a form with several controls set to default values when a new record is generated to help the users enter as little as possible. I believe this is what is causing the problem when a user "accidentally" hits the "Add record" button and then tries to go back to the...

I have a form with several calculated fields. Until information is entered around them they display these errors. I simply want these sweet little notes to hide until valid numbers are entered into the various fields of the form. Any idea how? Sometimes the view is perfect right where you are...

I have a report which calculates averages for productivity by shift for any date requested. This works fine but when trying to come up with a total average for the day the calculations come up to impossible numbers. I have tried various grouping levels and functions but cannot seem to get a...

I have a yearly attendance database built for our plant. Each year we put out a new clean copy and save the old ones for reference should we need them. I have a report that calculates an employees points for absences and credits for good attendance. The problem is each year we have to...

I have a label printing form that includes two check boxes. If one box is checked it will disable the other check box, enable the Print button and print all the labels for all the Carriers in the Carrier table when the print button is clicked. The other check box when selected disables the...

I have searched for this but cannot find exactly what I am trying to do. I have a (Complaintfrm) which I use to log various complaints. On occasion I need to file a claim relating to the complaint. I want to add a command button to the complaint form that will open the claimfrm and add a new...

I built an attendance database for my company. It worked fine without problems (with some help of some of you) for several months. We had a new employee hired into HR and they did not train her properly. Consequently, she would look up an employee using the filter by selection button I had...

I am trying to open a new form (Claimfrm) and set two of the fields from the original form (Complaintfrm). I used the command button wizard and Access generated the following code: (Copied directly from the window) Private Sub Command28_Click() On Error GoTo Err_Command28_Click Dim...