Advertisement

01.06.2008 at 07:46PM PST, ID: 23062731
[x]
Attachment Details

update statement in ms access

Asked by willhebert in Visual Basic Programming

Tags: update, statement, access, ms

How do I update a table with a value selected from from a different table using sub query?
Can we update multiple columns by single update statement. Can I get syntax for these update statement?  
If I get syntax in query window of ms access, How do I  convert that statement in Visual basic.?

I used update query window, when i run the query i got the message saying use updateble query.
How do I resolve this issue?

Start Free Trial
[+][-]01.06.2008 at 08:52PM PST, ID: 20597135

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Visual Basic Programming
Tags: update, statement, access, ms
Sign Up Now!
Solution Provided By: MrBullwinkle
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628