Word 2010 VBA - Run a stored procedure that returns 1 row of data

		Microsoft Office Forums > Microsoft Word > Word VBA
Word 2010 VBA - Run a stored procedure that returns 1 row of data

FAQ

Thread Tools

Display Modes

03-13-2014, 09:30 PM

macropod

Windows 7 32bit Word 2010 VBA - Run a stored procedure that returns 1 row of data

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

It's not something I've used, but this code http://www.ozgrid.com/forum/showthread.php?t=78325 shows how to obtain the query results. In particular, see the 'myReturn = rst.Fields("myVariable").value' line near the end.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

ado recordset

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to release hard returns?	markg2	Word	13	05-08-2023 01:38 PM
Word 2010 cannot find data source	wsdb	Mail Merge	7	09-05-2012 03:16 PM
Easy send/save Excel data to Database Table or Stored Procedure	TonyHarvard	Excel	3	07-11-2012 12:43 PM
Word 2010 discard editing data not working	Ravenant211	Word	3	02-16-2012 07:25 PM
excel where is procedure being called from	davids67	Excel Programming	1	11-18-2011 06:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.