Search results for query: *

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

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

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

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

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

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

Thank you :)

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

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

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

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

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

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

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.

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

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

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

Thank you for the help :)

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