Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2012 > Visual Basic 2012 General Discussion
| Search | Today's Posts | Mark Forums Read
Visual Basic 2012 General Discussion For any discussions about Visual Basic 2012topics which aren't related to a specific Wrox book
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2012 General Discussion section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 1st, 2014, 11:42 AM
KBB KBB is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Smile 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.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export SQL database to Excel in VB 2012/VS 2012 KLDeWitt87 Visual Basic 2012 General Discussion 2 December 4th, 2013 05:00 PM
vb 2012 access napatel2007 Visual Basic 2012 General Discussion 0 May 30th, 2013 10:10 PM
Force SQL Server 2012 to Use Visual Studio 2012 Titera BOOK: Professional Microsoft SQL Server 2012 Administration 1 May 6th, 2013 02:22 PM
Update query doesnt run when Select query does (In MS Access) rmccafferty SQL Language 3 February 11th, 2010 04:54 AM
Help with update query in Access sunny76 Access 3 January 16th, 2006 05:23 AM





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