I've been away from Access since I retired 10 years ago but foolishly said I'd help automate a mailing list process for a group I do volunteer work for. So I need the general steps to do the following.
Using Access 2013 (can get 2016)
Create a table of members [Member table],containing addresses, phone, join date, dues paid date (Import spreadsheet from Excel and created Member Number [PK], LName, FName, MName, Street, City, State, ZIp, etc fields as appropriate types -[DONE]
Creat query to load form with appropriate sorting of LName, etc. [DONE]
Creat Split Form (Member Form) with datasheet on bottom (bound form) . Top of form contains a search function for member's LName, and FName. Datasheet (bottom of form) lists all members and all info. When searching one or more member's LName info is filtered and a short list of members shows in the datasheet (bottom of form) [DONE]
--------------------------Everything above is done---------------------------------------
Need to create a "Mailing Form" The mailing form (at this time another bound form) will open when the user double-clicks the member's "Member Number" field on the filtered datasheet portion of the Split form.
Help I need - I am populating one set of fields on the Mailing Form from the same query as the Member form. Basically the same member info found on the Member form [bound source fields]. In addition I want to have new fields - Ticket Ordered, Ticket Mailed, and [here is where I need the help] a set of name and address fields [Mailed To fields] that will load that info from the basic query. But if the user begins to enter a different address it will clear all the Mailed To fields except Member Number and allow entering the 'mailed to" data. The "mailed to" data and Member Number will be stored in a different table and will not replace the data in the Member table. How do I load the Mailed To and then clear them without affecting the basic table fields?
I've hunted around and cannot find anything that gets me going in the right direction. A link or the general steps needed would be greatly appreciated
Posted by: robsonjack@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar