VB Forum / Database Access / February 2004

I wanna move to forward or back the records of the a table created with ADO,
but, when i do click on the Next buttom, i can't to see in the form the netx
record. Why? I have Combobox in my form.
I use the syntax:

I am new to SQL server. I need to get a parameter back into my code, but
can't see how to do this.
All help is appreciated

I have written an application that remotely controls Microsoft Excel
2000 from VB .NET
I can successfully update cells, formulas etc. I can also select a
range of cells on the spreadsheet from Excel.

I have two stored procedures with the following results?
Stored Procedure 1
nom_book
-----------

Reading through my Programming ADO manual regarding handling conflicts on
ADO rs updates.
Talks about using rs.status constants to check each record to determine
action needed.

Iam working in VB 6 accessing Oracle data using ADO. I want to know how adUseClient is different from adUseServer
The MSDN says when adUseServer is used only the requested result set is sent to the Client where as the whole of the result set is sent when adUseClient is used. What ...

I'm in the process of creating a password form for the database. I read the
earlier posts about using a password from a Access database. But I'm doing
the "other way around". I haven't created passwords for the actual database
itself yet. But I want to put password protection on the ...

if the date in regional settings is DD/MM/YYYY (Windows XP
When attempting to insert a VB6 Date datatype into an Access 2000 database (Using INSERT INTO .......
The date is inserted as MM/DD/YYYY format
However if the same insert is used using the 'NOW' keyword the access database ...

I have attempted my first distributed .exe today and it was a dismal failure. I created it on an XP machine but am trying to run it on  school machines  (95/98).  After some research I learn that I have to have DCOM98/95 which will not extract to my XP. What should I do?  I have ...

I want to load a a record set into a datagrid without keeping the connection to the recordset open all the time
The code i currently have is shown below. It won't let me set the connection to nothing. If i leave the connection as it is and then close it, it clears the data grid
   ...

what all do I have to do?
dim dtaEnvironment as DataEnvironment
but from there, what all do I have to do?
I know that I have to connect to a database.

I am New to using data environment, but I need some help. I am using data environment to connect to an 2000 access DB. and I have a data report to show data fromt he DB. I have a vb6 app that connects to the access DB, and the user can specify the path of the database.
I wanted to ...

Hello --
I have a datagrid set up on a form.  My monitor is 1280x1024 resolution.  I
have the datagrid set to display all the fields the way I like them,
however, I would like the horizonal scroll bar to appear when the form is

I have an Access table set up and I would like for the
user to be able to select a name from a combo box,
however, my code isn't working.  So far I have
frmStats.adoCoachLink.Recordset.MoveFirst

I am new in VB,and i am using MSSQl with VB.I want to know how to fetch particular record from table and show to screen.
i have tried datagrid , How can i pass arguement to retrieve data.Which is the best method
in VB for retrieving data.Please help
Thanks in advance