Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Question on updating using VB

Posted on 2001-06-26
2
Medium Priority
?
134 Views
Last Modified: 2010-05-02
Hi All,

I am working on VB,MS-Access2000.when i try to update i am getting error "Expression is too complex".Do you know how max fields we can update at once.Here i am updating more than 120 fields at a time.

thanks...

pnc
0
Comment
Question by:pnc
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 400 total points
ID: 6228991
You may want to take a look at the following article on MSDN (Q192716):

HOWTO: Update More Than 40 fields in an Access (Jet) Database
0
 

Author Comment

by:pnc
ID: 6229009
Hi acperkins,

just now i read Same article you mensioned above.Any way you gave me a correct answer.

Thanks...

pnc
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question