rockysmolin at bchacc.com
rockysmolin at bchacc.com
Tue Aug 11 10:36:05 CDT 2009
Sounds like you're on the right path. I'll try to give you a call Thursday. Right now we're going mountain biking - we're in Mammoth Lakes Cal. Where does the contact information for the main and partners come from? And are both being stored in the same table? Rocky Original Message: ----------------- From: Martin Reid mwp.reid at qub.ac.uk Date: Tue, 11 Aug 2009 14:35:04 +0100 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Event Invites Rocky No rush I can stall em,! What I am trying is as you said a new table. The input for will have two combos. One displaying the event which filters the second which will display the main guests already invited. Select the main guest in combo 2 and then view a list of names from which the user can select one or more partners. I then write the lot back to a table to be used for the merge. My concern is that if this a large event there's a lot of clicking to be done to add the additional guests. 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 14:30 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Event Invites 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 -- 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 - Check your email from the web at http://link.mail2web.com/mail2web