application.loadfromtext

[Danny S.]

Hi.

Can someone help me out with the syntax for the
application.loadfromtext command? Here's what I've got:

Application.LoadFromText acReport, Me.ObjectName,
"C:\Documents and Settings\dsmitherman\My
Documents\Access\vss\backups\report\" & Me.ObjectName

When this runs, though, I get the following error:

Run-time error '3011': The Microsoft Jet database engine
could not find the object ". Make sure the object exists...

I've tried various quotation marks arrangement, to no avail.

Thanks for your help.

Danny S.

 

[Dirk Goldgar]

Hi.

Can someone help me out with the syntax for the
application.loadfromtext command? Here's what I've got:

Application.LoadFromText acReport, Me.ObjectName,
"C:\Documents and Settings\dsmitherman\My
Documents\Access\vss\backups\report\" & Me.ObjectName

When this runs, though, I get the following error:

Run-time error '3011': The Microsoft Jet database engine
could not find the object ". Make sure the object exists...

I've tried various quotation marks arrangement, to no avail.

Thanks for your help.

Danny S.

The syntax looks correct to me. I'd guess there's something wrong
Me.ObjectName or with the path you specified; however, I can't make it
give me that particular error message, so I'm not sure exactly what's
wrong. Have you stepped through the code, checked the value of
Me.ObjectName, and verified that the error is being raised on this line?