×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

docmd.transfertext using a stored procedure or query in an adp.

docmd.transfertext using a stored procedure or query in an adp.

docmd.transfertext using a stored procedure or query in an adp.

(OP)
Tried posting in other forums, maybe this is the correct one to post in.
I can't believe this will not work.
Using an ADP.  backend stored procedures.  have done this million times using a table.  Can you substitute a stored procedure returning the data you want in place of the table?   100 people on the net say yes, 100 say no.  The syntax says you can use a query.  Does a query mean a sp as well?  1 person said create a query in vb.  I did an add in for 3.6 DAO.  The set qry comes up with and invalid object.

Dim qry           As querydef
Dim sqlStmt       As String
   
sqlStmt = "SELECT tblepoftp_Data " & _
            "FROM tblEDIPOFTP"
   
Set qry = CurrentDb().QueryDefs("qryTemp")
qry.sql = sqlStmt

 DoCmd.TransferText acExportFixed, , qry.sql, FTPAddress

 ....thanks.       

Remember when... everything worked and there was a reason for it?

RE: docmd.transfertext using a stored procedure or query in an adp.

GShen:

Sorry but i dont think this will work

1) an adp does not have a CurrentDb Property
2)even in a mdb the proper syntex whould have been

CODE

DoCmd.TransferText acExportFixed, , "qryTemp",FTPAddress
3)acExportFixed needs a SpecificationName   or schema file

what is it that you are trying to do perhaps we can find a work around

RE: docmd.transfertext using a stored procedure or query in an adp.

(OP)
Hey there,
A few notes.  Intellisense comes up with currentDb in the vb code which is a little weird.  As far as the schema, it dynamically creates the schema everytime and then I kill it after it creates it.  From my understanding the schema file will be different for every file name.   I am trying to send p/o's to vendors.  The name of each member will indeed be the p/o number.  Hence, I was thinking I can't use a schema.ini file.  Can I rename the schema it creates and then use that one everytime I run this?  Is it in one of the parameters to use a particular schema?  THe bottom line is I run an sp to create a table with 2 fields.  1 is a simple auto number file (int) and the next is the data string I am creating (varchar(500))which is more than enough.  I need to transfer just the data field.  I can't have the ID out there.
Thanks.  I will look up the schema while I await a reply.  If I am incorrect or you need more info.,please let me know.  Thanks so much......Gary

Remember when... everything worked and there was a reason for it?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close