Search results for query: *

Thanks for the help. I got the code to work. I think it had something to do with the references. The problem I am having now is that if there are multiple records that need to be in the subform, the code only adds the first one. Does anyone know how to get it to look at the next record...

I have a main form with several subforms. The main form has the client info. One of the subforms has the diagnosis for this client and the other subform has the problems that relate to the diagnosis. What I want to do is automatically fill in the problems for a particular client based on...

Ok. I have looked almost all day for a solution to this question on this boards, but I can't seem to find it so I am begging now for help from the Experts. I have a form with a continuous subform. What I want to do is automatically fill in the subform based on the current record the main form...

I would appreciate any help at all on this. I have a multi select list box that lists categories. In each category there are multiple classes. I want to be able to populate the subform based on what is selected in the category section. Then based on the categories selected I want it to add...

I have a spreadsheet with two columns(A & B). Column A contains a random number that is entered if there is data in Column B. Column B contains the name of a person. I can give you an example of what I don't want to happen... Column A Column B 1 John Doe 2 John...

That's the interesting part. You can go up to 500 rows, but it can be as little as 10. The cell that I want to compare is in Column B and starts in B2. Dawn Nelson Everett www.marykay.com/djeverett

I understnad what you are saying, but I don't have a clue where to start. I can do some programming in VBA, but I think this may be over my head. Any advice? Dawn Nelson Everett www.marykay.com/djeverett

I have a spreadsheet where I enter a random number(column A) and a name(Column B).Once I have all of my names entered I then have some code that radomly sorts the names and places them into numerical order. This is for a competition so we know who will go in what order. Once I have the run...

IT WORKS GREAT!!!! THANKS FOR THE HELP!!!

I have a spreadsheet with two columns, A & B. In one(A) I want a random number and in the second(B) I want some data. What I am trying to do is if the second column(B) contains data then I want to add a random number to the first column(A). Is this possible. If so, does anyone know how to do...

I am currently working on a database that sends out invoices for utility services. What I am trying to do may be simple, but I am stuck. I want the person to be able to click on the address for the service then in a subform or in the main form I want it to populate the previous months meter...

I am trying to do a report and I have a chk box names Negotiable and then I have the Minimum Salary for a job. If the chk box is checked and the minimum Salary is 0 then I want the report to say Negotiable otherwise I want the Salary to show up. I am currently using this code...

This is what I want to do, I want to click a button and when I click the button one of two reports will print. I have two different reports one that lists all the jobs to be posted and one that when there are no postings it simply prints no postings. I need to know if I can make it where when...

I need to print letters to our employees, but I only need to print the letter once. I placed a checkbox on the form of the employees to send the letter to. This will print the letter, but what i need to do next is update a field showing the letter the date was printed and then clear all of the...

I am working on a project that keeps track of all open positions, applicants, selectee, and other info about a position. What I need to do is be able to archive the position when the hire date of the selectee has been filled. The only problem that I see is that all of the information is in...

I am trying to figure out if there is a way to print a form letter only once. Is there some kind of way to mark the letter as being printed so Access will recognize not to print it again? Please help. What we do is send out letters to our employees and we only want to send one letter to each...