Recent content by drblackard

yes this is but if you would read the other threads nothing was noted...there is nothing to follow because nothing was listed...I have asked three times for some help and you have twice tried to direct me away from this site...I would appreciate it if you would either give me some help or leave...

I have created a form with members name (firstname, middlename, and lastname), membership dues amount, membership dues type, paid date, and paid membership dues for(year)....now I would like to update the membership dues amount annually without having to do all of them one by one, maybe a batch...

I went another route and figured something out...it's working now...Thanks

It is a query but the lookup box is in the table created for the membership...this way I can get the same spelling everytime for the members...Maybe this is where my problem is because it selects contactID, Lastname, middlename, and firstname...the reason I did the names individually (Lastname...

I don't think I made myself clear, my fault...when I open the report, instead of having a name under the name heading, I have a contactID number and only my first name...I know there is a way of converting the contactID on the report to the persons name but it's been a while since I've done...

I have a table with contactID, LastName, MiddleName, FirstName, and Membership Dues Paid (check box) on it. When I use the query to separate the paid from the unpaid, all works well. But when I print the report I only get the contactIDs on the report, no names. So I went back and made a lookup...

I have created a form with lifetime membership and annually membership, these are check boxes ... when the check boxes are true, another box appears to record payment information....I also have the amounts paid (Which are different for each person)...now, how can I update all of these amounts...

I have created a form with lifetime membership and annually membership, these are check boxes ... when the check boxes are true, another box appears to record payment information....I also have the amounts paid (Which are different for each person)...now, how can I update all of these amounts...

I don't know where to start or how to design such a feature...point me in the direction...I have not built something like this before and was wondering if anyone had insite but it seems instead of helping, people assume you are not trying...I am trying, I just don't know what/how to start this...

Someone please help me...thanks...

I have seached and found one other forum about Membership All at ONce update...but it never finished explaining how to do this procedure...It said use a query to update each year which is kinda like what I need but did not give instructions or steps to create it...I am pretty good with MSAccess...

I have created a database for my softball team and the year has ended...I was wondering how I could create a process to bill all the players (which are different charges) by using a query or a command button referring to this command to update at the end of each year. Please give details when...

Dumb Me...I figured it out...use the wizard in the Reports.....

Hi, Thanks for your prompt attention. Hyperlink would probably be the best way, am I correct? Less space in the database and storage on the hard drive. Correct me if I'm wrong but this makes more since.

It worked .... thanks for the help