VB Forum / Database Access / July 2005

is it permissible to put small (zipped) attachments here ?
greets

I'm trying to create a temp table in a function, and using DoCmd.RunSQL
(code below). Some of the fields are being populated, others are being
created - that's why I went the SQL route, figured it would be the quickest
& easiest way to get the job done. However,  all fields ...

I'm programming an standard OCX which allow me to filter a recordset.
Due to the "Filter method" limitations (can't apply filters to compare
dateparts -> I want to filter all the records of a month, can't use the
claus "NOT LIKE", ...), I wan't to run a SQL query over a XML

Hello --
When I change any row in a one-column DataGrid I receive the error
Microsoft DataGrid Control
---------------------------

    I need help  :( . I have an access database and I want to
transfer some data from access to Excel file in following way:
create a excel file,
run a query to put some data on it (using VBA)

I'm relatively new to VBA and VB6.
I've been writing a VBA app accessing dBase files via ADO data control.  
In VB6 I add an ADO control and a DataCombo control to a form, plug in the
pertinent properties:

What is the difference between 03.86.1830 and 03.85.1117 versions?
How can I install 03.86 on the Windows 2000 box? I've installed MDAC 2.8 sp1
but this didn't change a version.
Where could I find list of the latest driver versions with system

I have a VB 6.0 application which has commands to access a SQL Server
2000 database. When I ran and test this application, it was doing okay.
However, I got an error message when I made a standalone exe.  The error
message is "[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does ...

I want to know if it is possible to store data in a dll, and if so can anyone
direct me to how I can go about doing this (Example or tutorial site would be
great). I would like to create my own dll to accomplish this. Thanks

I have a stored procedure which is called in a VB application.
Its runs a query with a date and numerical parameters.
However this week, the function returning the SP has fallen over
with the following message

I am having a problem setting up an output parameter that is a varchar to a
stored procedure on SQL Server.  I have no problem with integers.  I have
tried not giving it a size.  I have tried giving it a size of zero.  I have
tried giving it the size of the varchar as defined in ...

I am using ADO 2.7 + SQL-Server 2000. I want to delete a record in a
clientside recordset and it doesn´t work.
Here is my code:
mvarCN = New ADODB.Connection

I'm using Visual Basic 6.0 SP5.
i have a generic code that is used to load flat files to database using an
XML config file that specifies column widths and formats.
I have an issue loading NULL into a DATETIME field, when i load a '' into

I am connecting to a SYBASE database using an ADODB Connection from my VB
code. In the code I am trying to execute a delete statement, a select
statement and an update statement in the order in a transaction using a
single connection object. I am getting the error "Transaction ...

Hi - I'm having a problem and hope someone can help.  The basic problem is I
created a database application in VB6 on a W2K machine and it crashes when I
try using it on an XP machine, which I installed from the install package I
created using the package/deployment wizard.  I ...