Rocky Smolin
rockysmolin at bchacc.com
Sun Jun 7 16:22:12 CDT 2009
You don't need the passport to go there. You need it to get back in. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Sunday, June 07, 2009 9:38 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pick a file, any file Well, you stop them coming north, don't you?? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 07 June 2009 17:10 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pick a file, any file Gotta have a passport now just to go down to Tijuana for the day. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Sunday, June 07, 2009 9:05 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pick a file, any file Could be but I was concerned that new passport requirements slowed things. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Sunday, June 07, 2009 8:52 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pick a file, any file Cyberpony went lame around Calgary. Had to wait for a fresh mount. Thanks to socialized medicine, however, he'll be right as rain in a couple of months. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Sunday, June 07, 2009 8:45 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pick a file, any file I think you right... definitely simplier... It also appears that the post took a couple of days to arrive. I could have hand written it, mailed it and had it re-written out at the server. ;-) Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Friday, June 05, 2009 4:00 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pick a file, any file Jim: Thanks but I thing the followhyperlink method seems tres simple and it works. That's the point at which I usually stop programming. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, June 05, 2009 3:49 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Pick a file, any file Hi Rocky: You can set up the system so that when a particular file is identified the application associated with the file extension will initiate. I have some code to that solution if you would like. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Friday, June 05, 2009 1:42 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Pick a file, any file Dear List: I have a client who wants a list of file attachments as children to a parent table. No problem. I get the path and file names using the open file dialog box. But now he wants to be able to click the attachment text box (it contains path and file name), and open the file with whatever program should open it - .doc/.docx with word, .pdf with acrobat, .xls with Excel, .jpg with whatever he's go it associated with, and any other file regardless of extension (based perhaps on the association?). Is there a way to general case this without knowing what application should be used to open the attachment and exactly where the application is located? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- 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 -- 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com