ADODB!!



THNX!

my data report name is datareport1 suppose where i want details of an sql for example :
select * from table where id = '"& combo1.text &"'
... i need to generate for nearly 15 sql's so i want to...

thanks a lot! the problem has been solved!!

very sorry for late response!!

hi all!
my project is with VB at the front end and MS Access at the back end!...i wish to know how to connect to MS Outlook based on a mail id taken from my employee database!
please help... very...

please send me a solution for making datareports without data environment!!

thankx a loott...!!

hi all.... this is another thread on datareports... i need to know how to work if i have an sql and i wish to give it in my front end and run the report from the front end... please help!!
thanking...

hi... i did refer to the thread u directed me to...but... im really new to datareports so first i want to know hw to configure to my database... is it through data source in the properties of my...

HI ALL....all posts n posters in daniweb hv helped a lot alwayz...one more help needed...i want to know about datareports.... now i need my reports to be generated under different conditions...... it...

sorry... im using a simple combo... is there some way i can edit n change the title of my question.... i didnt know hw to edit... its a simple combo... which has fixed values displayed... user cant...

hi all... i want to know if using simlpe combo with dropdown style 2 (where you cant type ur own data) im not able to retrieve data coz its showing that its has read only property... is it possible...

hey thankx a lot... it worked great!.....
THANKX A LOOOTT!

hi the left command worked perfect.... can you please clarify my other doubt also... that is if we can select multiple fields from a dabase and show it at the VB front end???




thanx a lot...

hi... i have a small doubt in hw to check the initial charecters in text... like if the first two letters of my text is OS or TP... so based on that i should be able to select which database to...

thnkx a lot for the responses...

now i can show only distinct reasons from the table are getting shown in my front end... but i want to avoid duplication in the backend also... so i hv to give a...

thnkx a lot for the responses...

now i can show only distinct reasons from the table are getting shown in my front end... but i want to avoid duplication in the backend also... so i hv to give a...

thnx a lot for ur responses!... plz clarigy if


[QUOTE=QVeen72;728706]Hi,

Populate the ComboBox using This SQL Query:

Select Distinct Reasons From MyTable
[QUOTE]

hi... this is a small doubt in VB6... i am making a request form... in which one of the fields are reasons... now i want it such if my user send in a new reason then it should get written into my...

Thnaks a lot!... helped my requirement!...

hi all!...
i have a small doubt... incase i have a database field for ID and i want my id to be of 5 digit field length... and append with zeros incase there are less than 5 digits...
example if...

no... its showing error when only one of the two checkboxes is selected... coz its still updating in the other database....

thanx 4 all responses!!

is this solved???

they are checkboxes... the command button is common for both the types... but the updation has to happen in different databases... so they r based on these conditions....

thnxk for all the...

the right code is

Private Sub cmdOK_Click()
Set rstSchema = New adodb.Recordset
rstSchema.Open "select count(*) from Login where userid = '" & userid.Text & "' and pswd = '" & pswd.Text & "'",...

to enable different tabs use sstab1.tabenabled(0)= true/false!... this is wat i needed regarding tabs!

"frmPast.Show" will load another form of the same project on clicking the button!..
thnx for the help all!

hw to add multiple conditions in a single update statement?? my project goes code like this...



If release.Enabled = True And nonosc.Enabled = True Then
Dim rst12 As New Recordset
...

thanks a lot for the responses... but its not working... i tried each of them invidually... but it is not working...
sorry... pls do keep helping!
thnx!

just try this out...
Private FuelLevel As Double
FuelLevel = 0#
... i guess ur not suppose to assign where u r declaring....
not too good wid VB...sorry if nt much of help...

hey all!
please help me to check for validaiton such that... i hv few textboxes and combo boxes and if data is not entered in them then the submit button should be locked... and also tell me where...

thax... worked great... hv a good day!

hey actually i dont want to use auto number which in database because then a lot of them get wasted and errors occur if i delete records... that is when i make test runs and later delete those...

hey all... my project is showing some error in this code... plz help...

Dim RS As New adodb.Recordset
Dim getname As String
Dim logginname As String
getname = "SELECT E_name FROM...

hey thankx a lot for the help... but i guess this is not wat i want... wat is jet 4?? sorry but im not sure if im using that...
... thnx... do let me know if u know anyting more!

well... its smething like i hv three sstabs... one for veg another for non-veg...nw when a person selects veg/non-veg and submits the form a unique id should be generated...
but when submitted the...

i hv a vb6 form connected to the ms acess... it has multiple tabs so if a user wants to make any one of the two then a unique key should be followed... preferably the key should be followed by the...

thanks a lot... it worked great!...
' Get current date
Label1.Caption = Now
' User enters number of days in the TextBox. Lets say 8 days
Text1.Text = "8"
' Now calculate date for DateTimePicker...

hi every1...
i hv a doubt in updating my date...
i hv a textbox asking for the number of days(days1).... n a dtpicker1 that should show the date after the number of days(days1) from the date the...

thnakx a lot!... it is solved...!
its working now!
tc!
n good day!

Hi all... please help me with this code... i hv retrieved the id of the employee from the login n stored it as a lable in my form- logid but now with respect to that i want to get the employee...

THIS can be done by making an adodc connection... this can be done by adding an adodc from components to the form... in the coding start decalre the connection like this

Public CN1 As New...