VB Forum / Database Access / April 2004

Is there any way to import tables from DBase IV to Access 2K other than
creating the tables and then copying the data
I am using VB6
I can do it using access automation via the transferdatabase function, but

I'm trying to call a ms sqlserver stored procedure in vb that takes in
a varchar input parameter.
here's the vb code:
   Dim connection As ADODB.connection

All I'm trying to transalte the C++ function's parameters and would
really appreciate if someone could help me out.
The dll is for ex; ProjctMgt.dll
So how do I declare this function in VB6 ??

Could anyone help me with this problem please? I have a date time picker
control on a form, and wanted to use the find method or sql statement to select
records for the month picked in the control.
Example: A user selects the date 4/25/2004, I want the recordset to return

Hi, how to use DAO to create a table with autonumber field?
tdf.Fields.Append .CreateField(FieldsToAdd(ind).FieldName, dbInteger)  //??
how to specify it's autonumber field??
Thanks...

in order to build flexible apps I'm using an ADO connection string on external entities, such as, INI or XML file or even in registry. This becomes a problem because this string contains confidential information, such as User ID and Password
What I want to know is how can I ...

I am trying to create an application in VB 6.0 that will store book records. I want to be able to store the information I enter through a form and display it in a MSFlexGrid or DataGrid (which ever one will give me the ability to sort the fields by clicking on the column heading)

Hai,
How can i show Page totals(Running Totals) in Data reports using data
environment
I developed a project by using vb6.0 and data reports. customer wants in

I do an rs1.AddNew and the program is interupted somehow (doesn't matter
how) and then I come back later and want to cancel it.
How can I test whether I have done the Add.New or not? I've tried rs1.state
and rs1.status to no avail. If I just do rs1.CancelUpdate it throws a

How can I protect my database with mdb format against content viewing
after creating an application in vb?

i would like to get notified when the user wants to get to the next record.
now the problem is that i get an error when i use that one:
-- code --
Private Sub Adodc1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum,

VB 6 application.
I'm doing either update of the existing record or insert of a new one into
table with Autonumber field.
After insert I would like to get a new ID (from Autonumber field) of the

hi again,
    i am currently printing my ms access reports and i noticed that
it takes a while before the printer starts printing.  when i tried to
print any document using ms word, the time difference is noticeable.

This may not be the right place to post but here goes..
I have just installed Access 2003 on an XP laptop
Applications I have written using VB 6.0 can not recognize the new .mdb format.  I previously used Acess 97
I installed MDAC 2.8 and Jet 4.0 SP8 to no avail

I have a table that is a photo catalog. It contains an autonumber ID key,
date, photo category, and a URL.
I need a query that pulls the newest photo of each category, but can't
figure out how to do that.