VB Forum / Database Access / October 2004

I can call a dtored procedure fusing the code below,
Dim InvList As ADODB.Recordset
Set InvList = New Recordset
InvList.CursorLocation = adUseClient

In my VB6 app, i'm using ADO connected to an MS Access database.  My app
requires using a table as a lookup table, only problem is there are over 60k
records in the table I want to look up.  with over 40 megs of information in
that table, obviously i don't want to do a select * and ...

Hi there, does anyone know how to create an inovice no.??
I would like to create a invoice no. like SI041000001
"SI" is fine for me, but "04" means this year (2004), and "10" means this
month (October), and the last 5 digits mean the autonumber which will

Having trouble accessing an Access database from my XP laptop.
I have a routine in VB6 which retrieves records from a Access 97
database with no trouble. But when I use exactly the same code on my
XP based laptop, I receive a message saying I do not have permission

I would like to be able make available data from disconnected
recordsets available to a number of forms(text boxes, navigation etc).
I have tried to put the declarations in a bas module. However, I get a
compile error at:

My app uses DAO 3.51 and I wanted to encrypt my database with
CompactDatabase using the dbEncrypt option but it doesn't work.  It
didn't show any errors but the database is still readable in a text
viewer.

I use Access XP. In VB code of my form I declared a Sub
procedure where the arguments were declared by reference
(what should also be a default appsing of arguments).
Debuging I found out that the values (and references) of

Using VB6 DAO MS Access.
Here is my query that I can't seem to figure out. I want to exclude all
fax_numbers that do not equal "MAT" and fax_number is not NULL and red_falg
= false.

hi
my self avi
currently i am developing one application in vb 6 and back end as
sqlserver 7 which is used on lan.

We have a VB6 client that has a hard-coded loginID and password that
can be viewed in a hex editor. We have a scheme for obscuring it, but
would prefer to follow the accepted "best practice" if there is such a
thing?

Invalid operation. (Error 3219)
I am getting this error when using the insert into statement in VB6.
The data engine is DAO to connect to access2003 database.
I tries the select * statement and that work find.

I have created a SQL statement that uses EXISTS but its generating a
syntx error and I just can't see why.
DB is Access2000 using ADO2.7
The query is:

I have a vb form that displays the results of a stored procedure execution
on a far point's spread grid.The Stored Procedure returns all the expected
results ( around 67,000 Records) but i get an oveflow error after displaying
around 35,000 records.

Hi Veign
I tried your code and it worked fine, but how do I make it bypass the
Microsoft Exchange Setup Wizard and
retrieve just the oe contacts ?

Where to bay a CD containing the explaination to
use all these API' s
Only a few of the tousands can be found in learning-books.
Thats really what we all want - I think. At least I do.