[AccessD] Event Invites

rockysmolin at bchacc.com rockysmolin at bchacc.com
Tue Aug 11 08:30:09 CDT 2009


What's your deadline for this? I'm out of town with the family until
Thursday but after that could help you offline.  Does this require an input
form or is the input coming from some other source?

Rocky


Original Message:
-----------------
From: Martin Reid mwp.reid at qub.ac.uk
Date: Tue, 11 Aug 2009 14:09:57 +0100
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Event Invites


Rocky

Just trying that now

Susan

yip all this "quick" jobs turn out to be so much more (<:

Martin


Martin WP Reid
Information Services
The Library at Queen's
Tel : 02890976174
Email : mwp.reid at qub.ac.uk
________________________________________
From: accessd-bounces at databaseadvisors.com
[accessd-bounces at databaseadvisors.com] On Behalf Of rockysmolin at bchacc.com
[rockysmolin at bchacc.com]
Sent: 11 August 2009 13:56
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Event Invites

Martin:

How about a second table with two fields - the Main Guest PK and the
associated guest PK?  Then you could use a simple query to draw the data
you need to push into Word from the Guest table.

Rocky


Original Message:
-----------------
From: Martin Reid mwp.reid at qub.ac.uk
Date: Tue, 11 Aug 2009 13:46:11 +0100
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Event Invites


The word part is Ok. I have that done for the main guest. In Access I need
to

Select the main guest.
Select their partners/s for the event

Create the Invite record containing

Main guest and multiple associated guests.

I need a simple way to associate the main guest with the additional guest/s
they would like to bring and then write this data back to a table. I then
use this data for the merge.

So Main Guest A could also bring B and C

At the moment I am using a multi select list box to allow them to select
several main guests. This I think could be the problem. If they select
several main guests how do I then associate the additional guests?

Maritn



Martin WP Reid
Information Services
The Library at Queen's
Tel : 02890976174
Email : mwp.reid at qub.ac.uk
________________________________________
From: accessd-bounces at databaseadvisors.com
[accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
[ssharkins at gmail.com]
Sent: 11 August 2009 13:27
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Event Invites

> I am struggling with how to create the invite
>
> Once the invite is done I then create the invitations using Word
> templates. This bit is also done but at the moment only for the main
> guest.

=======It sounds to me like you're really just collecting information
right -- the "invite" is really just a collection of data that you then push
out to Word. Is this correct?

Susan H.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--------------------------------------------------------------------
mail2web.com – Enhanced email for the mobile individual based on Microsoft®
Exchange - http://link.mail2web.com/Personal/EnhancedEmail



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--------------------------------------------------------------------
mail2web.com - Microsoft® Exchange solutions from a leading provider -
http://link.mail2web.com/Business/Exchange






More information about the AccessD mailing list