VB Forum / Database Access / November 2005

I'm trying to display some financial results in a form, which actually works
fine. However, what I would like is to be able to display the result in
order (month by month) from the start of the financial year (which the user
can set in the application). Although I can select the ...

I got a strange problem while using VB6 and using stored procedures with a
result set.
I´am using this code to execute a simple sp on a IBM I5 machine:
...

I tryed execute a simple query in Visual Basic using ADODC Control on
MSDataBase, the query include the 'Round' function, but i get this error:
Run-time error '-2147217900 (80040e14)':
Undefined function 'Round' in expression

Anybody can help me...plz. I want made database application where I need
to copy any of record Personel table in MasterFile Database to History
personel in BckPersonel Database. both of  table  have same structure, I
have been try with INSERT  INTO...IN statement but there is ...

Hi, Im trying to make a switchboard in VB that will connetc to my access
databse. I already have my database all up and running even with a
switchboard, but im wanting to have a form in vb which could acces my
quierires adn reports and all those other things that my switchboard does

Hi,  I've got duplicate table structures that exist in two seperate SQL
databases in different server registrations.  I want to copy the data from
all of the tables in one database to the other database.  I'm going to try to
be as thorough as possible in describing what I've done ...

What is wrong with the following code to update a datagrid?
Data1 is the data control and DBGrid1 is the grid.  The grid works
fine with the parameters I have given it at design time.
The error occurs on this line:

My VB6 app uses ADO and MS Access.  When run with a guest account it can not
write to the database, and generates an error that says "Operation must use
an updateable query."  In that line of code I was simply doing an update
after adding a new record.  It appears as if I cannot ...

How do I set the application name for an ADO connection to SQL Server?
Tia,
Martin

I'm using Windows 2000 Pro, SQL Server 2000, Visual Basic 6 with ADO 2.5
(ADODB library)
The problem I have is when attempting to connect to SQL Server from my VB6
app using ADO, the user ID and password I specify in the connection string

I am working on a payroll portion of a program for a client.  I have used the
week of the year (calculated based on the date of payroll entry) to determine
whether the hours worked were regular or overtime.  Basically checking the
total hours for the week.  I believe I used a ...

I write a backup programm that checks what files are open.
From my vb code i close the db and the ws but the ldb file is still open.
Is this a dao bug?
example:

Is it possible to connect to SQL Server Express 2005 using VB 6.0. Any tips
?
Thanks in advance,

I guess the above the recommended sequence of actions to be taken on a ADODB
recordset.
Just wanted to make sure that the last two steps can be omitted when the
recordset object is local to a Sub or Function, has been declared been

When I call a SQL Server stored procedure and add a varchar parameter
of, say, 300... does it actually send 300 characters back and/or forth
or just the actual length of the variable? (networkwise).
I'm asking because of the email address field.  Theoretically it can be