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!

Register Log in
  • Congratulations Chriss 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: PeggyBall
  • Order by date
  1. PeggyBall

    Query if/or check boxes are blank

    PH - Works GREAT! Thank you for all the help! PeggyBall
  2. PeggyBall

    Query if/or check boxes are blank

    I think I'm still missing something...I'm getting 290 records returned but should only get 29. In my table I have the following: LastName FirstName Status - can either be "Expected" or "Census" BirthCertificate - Check box (if checked they've turned it in) VAHealthForm - dropdown - can be...
  3. PeggyBall

    Query if/or check boxes are blank

    I have a form with a command button to open the query below. The records I want to see are those "Expected" students who are missing any one or more of the registration requirements. Here is the SQL - SELECT tblNewStudents.Status, tblNewStudents.LastName, tblNewStudents.FirstName...
  4. PeggyBall

    Multiselect list box to open table

    To edit one record I have a form with a combo box and by selecting one name I can go directly to that form but it becomes cumbersome. Can I make a multiselect list box to select multiple records, open the same form as above but filtered to show only those selected records to scroll through and...
  5. PeggyBall

    Multiselect list box to open table

    Hello, I would like to create a form with a multiselect listbox where the user can select one or several names to open either a table or another form showing only certain fields so they can update records. Main table: tblStudents LastName FirstName Address City State Zip HomeRoom Teacher...
  6. PeggyBall

    Query if/or check boxes are blank

    Hello - I have a student registration database which has the following fields (among other fields) in a table: LastName (text) FirstName (text) BirthCertificate (check box - checked if Yes) Physical (check box - checked if Yes) ProofOfResidency (check box - checked if Yes) Registration (check...
  7. PeggyBall

    Make a check box larger and print in draft

    Thank you :)
  8. PeggyBall

    Make a check box larger and print in draft

    Hello - a few frustrating but I'm sure easy to fix problems. This is a directory showing names, spouses, address/phone info, awards won (if any) and a few check boxes (fees deducted, etc.) Is there a way to make the check box larger? (size 14+ font size) When printing the report on a...
  9. PeggyBall

    Form to enter contact name to open coantacts' form to edit info

    Remou - I finally got it working!!! You deserve 10 stars for helping me. Thanks :)
  10. PeggyBall

    Form to enter contact name to open coantacts' form to edit info

    No, from the frmSearch, I want to click on member name form the combo box, click on cmdOpenMembersForm button and go directly to that persons frmMemberDataEntry so I can update information such as address or phone numbers. Currently, when in the frmMemberDataEntry, I must scroll through each...
  11. PeggyBall

    Form to enter contact name to open coantacts' form to edit info

    Hi Remou- Ok - I have 2 forms: a Member Data Entry tabbed form and a search form which has a combo box and command button (following above direction.) When I choose the name from the combo box then click "Open Form" the form opens blank and shows 1 of 1 record (filtered) at the bottom. I want...
  12. PeggyBall

    Form to enter contact name to open coantacts' form to edit info

    Well, I attached the above a macro to the command button (which is probably why this isn't working) so I'm guessing I need a module and I'm very lost. This seemed like an easy task but I'm over my head...
  13. PeggyBall

    Form to enter contact name to open coantacts' form to edit info

    [unbound]=[Forms]![frmSearch]![LastName] I think my problem might be the "unbound" but... Thank you for your help:)
  14. PeggyBall

    Form to enter contact name to open coantacts' form to edit info

    Thanks. Yes, I see your point. I set up a form with a combo box and command button. Choose member name (from tblMembers) then click cmdOpenMemberForm but the form opens blank (indicating 1 filtered). I want the user to select the name and click to open the members form to edit data.
  15. PeggyBall

    Form to enter contact name to open coantacts' form to edit info

    Hello - I am almost finished working on my first database which will contain information about 300-400 members :) For the user to edit information (change of address, awards received, etc) from the switchboard, I would like for the user to be able to search for one or more records then open...
  16. PeggyBall

    How do I make cursor move to first field in second tab page

    I got it to work :) Thanks for your help.
  17. PeggyBall

    How do I make cursor move to first field in second tab page

    Hello - I have a tabbed form (2 tabs - Member Info and Membership Status) for data entry. Tab page 1 includes member demographic info (name, address)and below are two sub forms where service position and awards info can be added if applicable. Tab page 2 contains date joined, and a couple...
  18. PeggyBall

    Relating 3 tables

    Thank you for the help :)
  19. PeggyBall

    Relating 3 tables

    Hello, I am new to Access and creating a database which includes personal information (name, address, phone, etc), officer position held and year, and awards earned and when. I have the following tables: tblContact Name Address Spouse Email Phone tblAwards AwardName (one row for each award -...

Part and Inventory Search

Back
Top