p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Visual Basic 2012 General Discussion (http://p2p.wrox.com/forumdisplay.php?f=693)
-   -   VB 2012 to existing Access Update Query (http://p2p.wrox.com/showthread.php?t=92566)

KBB April 1st, 2014 11:42 AM

VB 2012 to existing Access Update Query
 
I would like to be able to reference and use a query, directly from the Access database, as the update command in my separate Visual Studio 2012 Visual Basic Windows Forms Application. My Access .mdb database (originally created with Access 2007 but current running Access 2013) contains the following update query, named Current Update Query. I wish to update the existing column and row variables in the Current Table as shown in the query sql view below. Update values would be read from the VB form combo box text and text box text controls.

What VB code would allow update of the Access Current Table values using this query and without cutting and pasting the sql from the query into the separate VB code?

Current VB project Data Sources include connection to MyDataSet and all associated Access Tables and Access Queries stored in DB.

Current Access DB includes DB update query named Current Update Query shown below.

Current Update Query:
UPDATE [Current] SET [Current].CurrentConfigName = [?], [Current].CurrentParamID = [??], [Current].CurrentParamName = [???], [Current].CurrentAlgID = [????], [Current].CurrentAlgName = [?????], [Current].CurrentReportID = [??????], [Current].CurrentReportName = [???????];

Thanks.


All times are GMT -4. The time now is 03:06 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.