Jim Lawrence (AccessD)
accessd at shaw.ca
Mon Nov 3 18:58:16 CST 2003
Hi Rusty: Thanks for your suggestions...I am looking into it now. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of rusty.hammond at cpiqpc.com Sent: Monday, November 03, 2003 7:13 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Running local file format Jim, If you're just wanting to give the ability to open a file from a list, what I've done in the past is use a continuous form listing the filename and beside the filename field, add a command button. Set the Hyperlink Address of the command button to the path and filename via code in the On Current property of the form. Then the user just clicks on the button and the file is opened by whatever program the extension is registered as. HTH Rusty -----Original Message----- From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] Sent: Monday, November 03, 2003 1:47 AM To: Access Developers discussion and problem solving Subject: [AccessD] Running local file format Hi All: This is a simple question I am sure but the life of me I can not remember or find the related code. (Advanced years and all) Can you set up Access to, under program control to run/display any file that the local computer recognizes, like a Word document, pdf file, spreadsheet or maybe a web page without writing specific code for each type. I have written procedures for Word Excel and Web pages but there must be any easier way than blocks of code for each extension. A browser web page can do this but can an Access program? Any suggestions would be greatly appreciated MTIA Jim _______________________________________________ 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