Recent content by briandavis

item solved yea that's right. I guess my vacation scrambled my brain. Thanks again! :p

Sorry, I went on vacation just after my initial post. I can run the query for true values. What I can't figure out is if the value is true how do i get it to displaythe value of a different field as well

Sorry,I just got back from vacation. I tried searching and came up empty. Any clues on the key words I should use in the search? Thanks

issue solved Sorry, I went away on vacation since I posted this question. Wanted you to know it works great! I hope yo don't get tired of hearing that you're a genius!

The form is for a daily schedule of employees. The checkboxes indicate that a certain position is being worked for overtime as well as for other calculations. I am copying the form because from day to day the schedule contains about 80 to 90 percent of the same information. This way we can save...

In an employee database two fields I have are, hiredate and seniority. Is it possible to have access automatically enter a value in the seniority field based on the hire date. For example the person with the oldest hire date will be given a seniority of 1. the second oldest hire date gets 2 and...

SHOUT! Where do I insert this [Forms].[frmReportDate].[txtReportDate]. I've done everything else but not sure where this goes.

I'm copying a form. Also, I have 40 checkboxes on the form. Is there a way to write the code so that will look for this particular type of object on the form and clear it out rather than entering a line of code for each checkbox. Thanks

From a single button I would like to print out four seperate reports. Each report if printed individually will prompt the user for a date. The user will generally need to print all four reports and will always use the same date value for all four. How can I do this? Thanks ;)

I used the tool button wizard to create a button that duplicates a form. On my form there are several checkboxes. How can I set it up so that when the user hits the button to duplicate the form that all checkboxes in the new form will be unchecked.

In my database I have a table for my daily schedule. In this table for example one of the scheduled places to work is the "frontdesk". The value for this field is a name pulled from a query on the employees table. On the form created for the schedule table I have a check box next to each area...

Wow that's a little too much like reinventing the wheel. I just made the last tip you gave me work. In my report I just changed the name that appears from Expr.. to the actual label. I used conditional formating to hide all the "0"'s. So basically I get what I wanted. But instead of an "X"...

Still no go When I changed the field line to what you said, it changed the line to read Expr1:[area1expirationdate]-Date()<=30 It did this for all of them but it gave each one a different Expr number. Also when I looked at the query it returned Only Expr and the number for the heading and...

I have several fields in a table that show the dates of expiration for training for all employees. Training is always on going as these dates are different for all employees. For example: in this table there is an employee "John" John must be recertified in 7 areas each year. In this table...