Brad Marks
BradM at blackforestltd.com
Wed Mar 16 16:27:32 CDT 2011
John, I might be misunderstanding things (like a good Minnesotian I will apologize up front) but I thought that I would reply with info that might be useful. We use Access 2007 Runtime quite a bit. While it is true that a person cannot modify objects via the "user interface", we have applications that change Query-Defs (using VBA code) in the Runtime environment. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, March 16, 2011 5:49 AM To: Access Developers discussion and problem solving Subject: [AccessD] Harnessing SQL Server with runtime http://www.tek-tips.com/viewthread.cfm?qid=1296308&page=269 Using runtime means that you cannot do the typical "open the qdf, modify and use" because you can't modify objects in the runtime environment. For that reason I am going to have to become proficient in stored procedures and passing parameters to them. I found the thread above which discusses this for the form itself. Can the same kind of thing be done for the combos and reports. This project is has already taught me a ton of things that I never had to use before. Working with parameterized stored procedures from Access is another such area that I have always wanted to learn. Any tips and tricks are always appreciated. -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.