By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

13 databases on one control

Ali Rizwan
100+
P: 927
Hi
I want to fetch databases according to class no using one control.
I have done it but sometimes an error has occured. I have used this code in change property of txtbox

adodc1.commandstring=Jet Provider + database name ...

is there anyone better
Thanx
Sep 4 '07 #1
Share this Question
Share on Google+
4 Replies


QVeen72
Expert 100+
P: 1,445
Hi,

Write the Code in txtClass_Validate or txtClass_LostFocus Event of the Text Box. If u write in Change Event, It keeps on Opening the DB for every key press.. better Give a ListBox of All the available Classes, and write code in LostFocus of ListBox

Regards
Veena
Sep 4 '07 #2

Ali Rizwan
100+
P: 927
Hi,

Write the Code in txtClass_Validate or txtClass_LostFocus Event of the Text Box. If u write in Change Event, It keeps on Opening the DB for every key press.. better Give a ListBox of All the available Classes, and write code in LostFocus of ListBox

Regards
Veena
Thanx for reply.
I m using combo box also but the problem is in updating data. It occurs an error of
"Multiple steps occurs errors" some thing like this.
otherwise databses are opening properly.
Sep 4 '07 #3

QVeen72
Expert 100+
P: 1,445
Hi,

"Multiple Step Generation Error" is usually due to the Change in Datatypes in DB and front end, It can occur in such Conditions:

IN DB Text Length is 10 and u r trying to save string Length >10
In DB, Field is a Date Field, u r trysing to save a Non-date Field
OR it is of Integer and u r trying to store value>32k
Or else, there is a Violation of Foreign/Primary Key

Regards
Veena
Sep 4 '07 #4

Ali Rizwan
100+
P: 927
Hi,

"Multiple Step Generation Error" is usually due to the Change in Datatypes in DB and front end, It can occur in such Conditions:

IN DB Text Length is 10 and u r trying to save string Length >10
In DB, Field is a Date Field, u r trysing to save a Non-date Field
OR it is of Integer and u r trying to store value>32k
Or else, there is a Violation of Foreign/Primary Key

Regards
Veena
Thanks Veena
I checked and foun i am trying to enter string in integer format field.
Thanx again
Sep 4 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.