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