VB Forum / Database Access / May 2005

when i use dao if i want to make an sql update to my database (access) i use
this command
data1.database.execute "update table1 set names = 'vagelis'"
now i want to convert my dao to ado

I am using a command object with cmdType = adCmdText.
If I Insert a row using .Execute ,, adExecuteNoRecords  how can  I determine
ROWID that was just added?
I'm not using a SP at this time.

This might sound simple, but I'm stumped.
In essence I have a 2 form app that connects to an SQL db and extracts info
from it.  This works fine.  The problem is with my 2nd form.
The 'run through' is that the user can select an inv no from a combo box on

Hello, novice VB question (I posted in General Discussion then thought this
might be a more appropriate forum):
I created a module which prompts the user to choose and import a spreadsheet
into an Access table.  As the next step, I need to add a new field to the

i am wondering if it's possible to have the odd and even rows in a
datagrid look different: coloring rows, is it possible at all?
Any good (free) alternatives for the msdatgrd ?
cheers,

i have a data control which i want to connect it with one database(access)
Also i have a textbox in which i want to see my datas
here is my code
where do i make the mistake?

I am unsure how to do this but what i need to do is this:
My users have 12 forms to collect all the financial info of a client,
personal details insurance policies and other stuff.  At the moment when all
12 forms are completed the user hits a button and my stored procedures run

I have an access database with one table
After I load the table with 500000 records, I compact the database
now, when I update each record the table with VB6 and adodb.recordset, at
the end, I get an error when I execute the recordset.update around the

   I have a listview that has 6 columns:
Column1 = icon
Column2 = Path and Filename
Column3 = Servername1

I've created this app that extracts data from 1 table in an SQL DB.  The
connection and extraction works fine, its just a problem of doing loops
correctly that is causing me some grief.
In essence, the person who created the DB had an app in another IDE that

Something is removing my queries.
When I open my '97 Access database in VB using ADO/Jet4 OleDB, I lose
many of the queries. They just aren't included in the Procedures
collection.

Newbie to this group, but been doing VB for a long time and ADO in the past
2-3 years off and on.
I have a OLE connection that I set up in a UDL file which connects fine, but
when I try to Execute a query, I get Error 76 'Path not found.'  I don't

How can I add a record to a field in access that is a memo data type from an
ADODB record set in Visual Basic?

Hi everyone, I have a question regardin an application I'm working on. In
that app I have a datagrid that gets populated with the following SQL
statement. This statement basically displays the date, total purchase etc for
a customer for every day he's been to the store. But the ...

Good day to everyone!
i want to use a datagrid or flexgrid to enter data in tabular form. Use a
TAB key to navigate from one cell to another and also validating the
entered data in a given cell. i did try the code sample from microsoft