Kamis, 21 Februari 2019

Re: [MS_AccessPros] Re: General Design Implementation Help

 

you're welcome, Jack!

Please try to remember to Keep Message history. Here are the previous messages:

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

On 2/19/2019 7:56 PM, robsonjack [MS_Access_Professionals] wrote:
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  

------------------------------------------------

On 2/21/2019 12:03 PM, JW Robson robsonjack [MS_Access_Professionals] wrote:
Thank you Crystal.  I'm off and running.

Jack

__._,_.___

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 (5)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar