VB Forum / Database Access / June 2005

While this is an ADO issue, I do not get the same results in MS Access.  The
following code, written for AutoCAD VBA generates an 'Out of stack space'
error.  I can run the query in Access without error.  The result set, as
tested is less than 4 records, with 6 fields each (not ...

I would like to know how to move a record from one table in a database into
a different table. Is this possible? If so would I copy the record to
another table and then delete the original?
At present I have the records from tblListings loading into textboxes which

- VB5 program
- Access 95 database
- win98 / winXP workstations
My VB5 program allows users to view and modify an (mdb) database. (The

How can I print DataGrid contents. I have DataGrid wit SQL server table
loaded and I need to print that out and I don't know how for a week.
help please

Hi, im trying to open a Report from VB, when i open it it only shows one
record on each page, im not used to develope in VB thats why im having
some troubles with reports.
TIA

I have an application that connects to a remote SQLServer database, when i
execute a BeginTrans on my connection object i get the 'Transaction cannot
start in Firehose Mode' error message.
Does anyone know why you get this message, and what the workarounds are?

i have doubt in using recordset...The runtime error occur when using
objrs.movefirst; The runtime error message is "Rowset position cannot be
restarted" and the runtime error code "2147217896(80040e18)".
Here is my code..

I have a VB3 program  based on a Access 2.0 database wich runs without
problems in a Network with Windows 98.
When it runs on a mashine with Windows 2000 or Xp and I try to start it from
another client

Hello, I’m having some problems with Visual Basic 6.0 and Access XP.
I’m trying to set the index of a table so i can use the method
Recordset.Seek, the problem is that whenever I try to set the
Recordset.Index property to the table’s Id field I get a run-time

I have a VB application which will save data entries into a Access 2003
database. Records are saved into Mstr table when user click on a save button
in the VB application. Records sould be saved into table, but sometime they
are not?

I am using VB 6.0 (not .net) and I have an access database that I would like
to connect to using ODBC.  Does anyone have the code or a web link to create
the connection to Access and the code for doing SELECT, UPDATE, INSERT and
DELETE?

I have function Function1 defined in MS Access 97 module.
This function is used in query Query1: SELECT A,B,Function1(A) FROM ...
So far so good .. good results.
Now I want to use Query1 in my VB6 application:

I wrote a VB5 program on my win98 system.  The program creates a blank
database composed of 3 tables - nothing fancy. When I open that blank file
with Access 2002, it says "Database (Access 95 file format)".
The customer (my neighbour) has been using that program for about a year,

I return a recordset from a function call (in vba). In the calling code I have:
   Dim rs As ADODB.Recordset
   Dim cnn As ADODB.Connection
   Set rs = frstRecordset(strSQL)

I am a novice at ADO code, so the answer below might be very simple. I use
the following function to insert records into tables and would like to use it
for different SPs requiring different numbers of input parameters. How would
I do that? I know I could declare optional ...