hi Jack,
create a table for the mailing information with its own AutoNumber Primary Key and Foreign Key MemberID (assuming MemberID is an AutoNumber in the Members table, it would be a Long Integer here with no default value). You can populate these record initially with the member information using an Append Query.
INSERT INTO MailingTable (MemberID, MailAddress1, MailAddress2, MailCity, MailState, MailZip)
SELECT MemberID, LastName, FirstName, Address1, Address2, City, State, Zip
FROM Members
WHERE whatever criteria you want
Once the table is populated, you can edit records and change what you want.
This is a very simplistic example. Ideally, information in tables would be normalized better. Have a look at the free download example here:
https://www.msAccessGurus.com/tool/MyContacts.htm
Here is a free book that can help you with Access:
Access Basics
http://www.accessmvp.com/Strive4Peace/Index.htm
Free 100-page book that covers essentials in Access
~crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
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: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar