Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2012 > Visual Basic 2012 General Discussion
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old April 1st, 2014, 12:42 PM
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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 11:10 PM
Force SQL Server 2012 to Use Visual Studio 2012 Titera BOOK: Professional Microsoft SQL Server 2012 Administration 1 May 6th, 2013 03: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



All times are GMT -4. The time now is 08:07 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.