transferdatabase help

[xg]

I have a frmActiveView which is based on qryActive query. I want my button
to transfer all the records to a:\active.dbf and I cannot get parameter
right.

I started with:

DoCmd.TransferDatabase acExport, "dBase IV",

What after that? Thanks.

 

[Douglas J. Steele]

Check your help file.

The syntax for TransferDatabase is:

DoCmd.TransferDatabase [transfertype], databasetype, [, structureonly][,
saveloginid]

You're missing databasename, objecttype, source and destination.

 

[xg]

I got error message as 'object invalid or no longer set'. my code is:

DoCmd.TransferDatabase acExport, "dBase IV", "a:\", acQuery,
"qryActiveView", "Active.dbf"

My intension is to export all the records from qryActiveView to
A:\Active.dbf

I have a form with unlining qryActiveView. on the form, I have a button to
do above line. where did I do wrong?

thanks

Check your help file.

The syntax for TransferDatabase is:

DoCmd.TransferDatabase [transfertype], databasetype, [, structureonly][,
saveloginid]

You're missing databasename, objecttype, source and destination.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have a frmActiveView which is based on qryActive query. I want my button
to transfer all the records to a:\active.dbf and I cannot get parameter
right.

I started with:

DoCmd.TransferDatabase acExport, "dBase IV",

What after that? Thanks.

 

[Douglas J. Steele]

Sorry, I've got no experience with dBase, but try:

DoCmd.TransferDatabase acExport, "dBase IV", "a:\active.dbf", acQuery,
"qryActiveView", "Active.dbf"


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I got error message as 'object invalid or no longer set'. my code is:

DoCmd.TransferDatabase acExport, "dBase IV", "a:\", acQuery,
"qryActiveView", "Active.dbf"

My intension is to export all the records from qryActiveView to
A:\Active.dbf

I have a form with unlining qryActiveView. on the form, I have a button to
do above line. where did I do wrong?

thanks

Check your help file.

The syntax for TransferDatabase is:

DoCmd.TransferDatabase [transfertype], databasetype, [, structureonly][,
saveloginid]

You're missing databasename, objecttype, source and destination.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have a frmActiveView which is based on qryActive query. I want my
button to transfer all the records to a:\active.dbf and I cannot get
parameter right.

I started with:

DoCmd.TransferDatabase acExport, "dBase IV",

What after that? Thanks.