transferdatabase help

  • Thread starter Thread starter xg
  • Start date Start date
X

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.
 
Check your help file.

The syntax for TransferDatabase is:

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

You're missing databasename, objecttype, source and destination.
 
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


Douglas J. Steele said:
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)


xg said:
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.
Click to expand...
Click to expand...
 
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)


xg said:
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


Douglas J. Steele said:
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)


xg said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top