Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: drblackard
  • Order by date
  1. drblackard

    Automate updates for billing....

    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...
  2. drblackard

    Automate updates for billing....

    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...
  3. drblackard

    Help with converting number to name...

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

    Help with converting number to name...

    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...
  5. drblackard

    Help with converting number to name...

    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...
  6. drblackard

    Help with converting number to name...

    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...
  7. drblackard

    All at once billing process.....

    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...
  8. drblackard

    Bill all members at once....

    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...
  9. drblackard

    Bill all members at once....

    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...
  10. drblackard

    Bill all members at once....

    Someone please help me...thanks...
  11. drblackard

    Bill all members at once....

    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...
  12. drblackard

    Bill all members at once....

    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...
  13. drblackard

    Create Mailing Labels from query

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

    MSAccess check box again

    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.
  15. drblackard

    MSAccess check box

    It worked .... thanks for the help
  16. drblackard

    Create Mailing Labels from query

    I have developed a database for a church and would like to create a feature to create mailing labels through a report if possible or create mailing labels in any other way if possible. If you have a suggestion on how to do this please give instructions otherwise I need a solution to use the...
  17. drblackard

    MSAccess check box

    It worked but when the database is closed the date box disappears and I have to uncheck the deceased checkbox and recheck it to make it visible again. Is there anyway to make it stay visible after you check it, until unchecked.
  18. drblackard

    MSAccess check box again

    How can I attach a word document to a check box on a form? The same church database as before but they want to attach a death article scanned into Microsoft Word (or a bitmap) to the death date check box. I guess I really need to add a button to the area to view this after you have successfully...
  19. drblackard

    MSAccess check box

    How do I use a check box to make a date text box appear when the check box is clicked on to select it. I have developed a membership database for a church but they would like a record of deceased members by clicking on a check box and having a date box appear to enter their date. The date box...
  20. drblackard

    Create a popup custom toolbar for reports...

    I have made my Access database work without the Access background, but I am having a problem with getting the previewed reports to print...no toolbar. How can I make my custom toolbar, with just a print, page setup, and close button, pop up on my reports when any of them are opened so that I can...

Part and Inventory Search

Back
Top