VB Forum / Database Access / November 2003

can someone help me in clearing the following doubt.
i have two tables table a and table b
table a has the fields empno,empname,sex,age.
table b has the fields experience,salary,qualification.

I need to populate my textbox with the password that matches the username.
I"m not very sure on how exactly I can do that with ADO. Can someone help me
pls?
I'm using MySQL, VB6. This is what I have come up with so far...

I'm developing an application in VB 6.0 using ADO 2.7 and SQL Server.
When I execute begin transaction and
open a recordset inside the transaction with its cursor located in the
server, I can't execute an insert sql command. However, if I change

I have a populated DataGrid and want to retrive data from
the DataGrid but I can't manage to do it.
I have added a the event DataGrid1_MouseDown and are able
to retrive which row is selected. How do I retrive data

Anyone can suggest me a good DB design tool which can show ER diagram with
column name, description, data type, index info. etc...
Thanks
Douglas

I just got back into Visual Basic programming with MS Access 2000 and can't
seem to get past this problem.  Part of the problem is my Help file for MS
Basic is incomplete.  I've reloaded it and reloaded it, it shows loaded, but
some of the files aren't there.  Here is the code...

Im new to Vb.net and am trying to create my first
practice project. The problem iv encountered is to do
with SQL queries issued against my access DB iv created.
i want to wright a query that will pull all the caravan

I need HELP here.
I'm quite new to VB, I'm doing a login form here, whereby the records are
stored in MySQL database. Can anyone show me how do I do a connection to a
MySQL server to verify the usernames and password pls?

I have the following doubts ,
1) how do i transfer the data's from Access to Excel based
on users condition using Vb as front end?
2) How do i display the fields to the end user from a ms

Please help
I created an environmental object with 3 command objects
inside it.
One of the command object required a parameter for input.

First of all, please accept my apologies if this post if slightly OT - this
seemed like a reasonable place to post this, however, I may (probably have)
missed other groups that may be more suitable.
My question is, I have a stored procedure in an SQL Server database linked

I am new to ADO. Trying to append field to an access table in vb without
success. I have gone through MSDN on-line help files and found the sample
codes are on command.append XXXX
Tried to use fields.append XXXX with the required configurations as

I have there a small problem.
I would like to open a xls file over ADO. (1)
Which works well. I can select it and print it with DEBUG.PRINT .
Only If i try to write I get a "beautiful" error message (2).

Does any body knows why the below code will rise
error "Error Number: 265946.  Description: Multiple-step
operation completed with one or more errors. Check each
status value."? Thanks.

Any ideas?