Connecting Tech Pros Worldwide Forums | Help | Site Map

Access Report to rtf

Bob Darlington
Guest
 
Posts: n/a
#1: Nov 13 '05
I have downloaded Stephen Leban's code to write an Access report to rtf, and
am running into trouble with the fCreateSnap procedure at the line:
Set specs = CreateClass
When I try to compile, I get an error 'Variable not defined'
I am new to using classes in this way, so hope that someone (Stephen?) can
help.
Is there a missing procedure for CreateClass. If so, where do I find it, and
where do I use it?

--
Bob Darlington
Brisbane



pietlinden@hotmail.com
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Access Report to rtf


Do you get a 'broken reference' reminder when you try to open your
database? What happens if you compile your code? I moved the
ReportSpecs.MDE file into another directory and that was the only way I
could get it to cause errors.

'Variable not defined' - Your file probably can't find the MDE file
where the library files you're referencing are located. Try putting
the two databases in the same folder, recompiling your code and running
it again.

Bob Darlington
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Access Report to rtf


You were close. But I was even more stupid than that. I'd actually deleted
the reference. One of my late night efforts which I must stop.

I seem to remember Stephen saying (in the ng) that he was going to rewrite
this without the need for a separate reference.

Anyway, it's a great add in and its solved some real problems for me. I wish
I'd looked at it a long time ago.

--
Bob Darlington
Brisbane
<pietlinden@hotmail.com> wrote in message
news:1115952994.074022.327660@g44g2000cwa.googlegr oups.com...[color=blue]
> Do you get a 'broken reference' reminder when you try to open your
> database? What happens if you compile your code? I moved the
> ReportSpecs.MDE file into another directory and that was the only way I
> could get it to cause errors.
>
> 'Variable not defined' - Your file probably can't find the MDE file
> where the library files you're referencing are located. Try putting
> the two databases in the same folder, recompiling your code and running
> it again.
>[/color]


Stephen Lebans
Guest
 
Posts: n/a
#4: Nov 13 '05

re: Access Report to rtf


I've got the rewrite half done. Just have to find a few hours sometime
to complete it.
:-(

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Bob Darlington" <bob@dpcmanAX.com.au> wrote in message
news:428846a9$0$5176$afc38c87@news.optusnet.com.au ...[color=blue]
> You were close. But I was even more stupid than that. I'd actually[/color]
deleted[color=blue]
> the reference. One of my late night efforts which I must stop.
>
> I seem to remember Stephen saying (in the ng) that he was going to[/color]
rewrite[color=blue]
> this without the need for a separate reference.
>
> Anyway, it's a great add in and its solved some real problems for me.[/color]
I wish[color=blue]
> I'd looked at it a long time ago.
>
> --
> Bob Darlington
> Brisbane
> <pietlinden@hotmail.com> wrote in message
> news:1115952994.074022.327660@g44g2000cwa.googlegr oups.com...[color=green]
> > Do you get a 'broken reference' reminder when you try to open your
> > database? What happens if you compile your code? I moved the
> > ReportSpecs.MDE file into another directory and that was the only[/color][/color]
way I[color=blue][color=green]
> > could get it to cause errors.
> >
> > 'Variable not defined' - Your file probably can't find the MDE file
> > where the library files you're referencing are located. Try putting
> > the two databases in the same folder, recompiling your code and[/color][/color]
running[color=blue][color=green]
> > it again.
> >[/color]
>
>[/color]

Bob Darlington
Guest
 
Posts: n/a
#5: Nov 13 '05

re: Access Report to rtf


Thanks Stephen. It's a great utility which has got me out of a hole.

--
Bob Darlington
Brisbane
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
wrote in message news:0U2ie.13921$Ph4.500808@ursa-nb00s0.nbnet.nb.ca...[color=blue]
> I've got the rewrite half done. Just have to find a few hours sometime
> to complete it.
> :-(
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Bob Darlington" <bob@dpcmanAX.com.au> wrote in message
> news:428846a9$0$5176$afc38c87@news.optusnet.com.au ...[color=green]
>> You were close. But I was even more stupid than that. I'd actually[/color]
> deleted[color=green]
>> the reference. One of my late night efforts which I must stop.
>>
>> I seem to remember Stephen saying (in the ng) that he was going to[/color]
> rewrite[color=green]
>> this without the need for a separate reference.
>>
>> Anyway, it's a great add in and its solved some real problems for me.[/color]
> I wish[color=green]
>> I'd looked at it a long time ago.
>>
>> --
>> Bob Darlington
>> Brisbane
>> <pietlinden@hotmail.com> wrote in message
>> news:1115952994.074022.327660@g44g2000cwa.googlegr oups.com...[color=darkred]
>> > Do you get a 'broken reference' reminder when you try to open your
>> > database? What happens if you compile your code? I moved the
>> > ReportSpecs.MDE file into another directory and that was the only[/color][/color]
> way I[color=green][color=darkred]
>> > could get it to cause errors.
>> >
>> > 'Variable not defined' - Your file probably can't find the MDE file
>> > where the library files you're referencing are located. Try putting
>> > the two databases in the same folder, recompiling your code and[/color][/color]
> running[color=green][color=darkred]
>> > it again.
>> >[/color]
>>
>>[/color]
>[/color]


Closed Thread