Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writing from Foxpro into Access
Message
From
30/03/2000 01:54:58
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
 
To
30/03/2000 00:16:52
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00351204
Message ID:
00352583
Views:
11
Hi John,

That's one of my dislikes about the FoxPro report writer that you can't put Form controls on it. I think if you could then it'd be a killer tool. I've used the method that you suggested before and it works very well. When your Report Writer Utility becomes available in Beta I'd be more than happy to test it. A tool like that would be hugely benefical to me.

Thanks,
Gavin...

>Well, no, Gavin, because you can't drop Form controls on to a report in VFP. So I don't support them. Of course, when needed, you could emulate them with a small box and a field with IIF(fieldval,"X","").
>
>BTW, the tool is going to be uploaded in beta format within the next 24 hours.
>
>
>> Can you please tell me more about your Report Writer Utility. I created a report from a DBF using Access with checkboxes and when I saved it to RTF format to import into WORD it didn't keep the checkboxes. Does your utility allow for checkboxes to be printed on a report and kept when converting to RFT?, and if so how can I get my hands on it.
>>
>>Thanks,
>> Gavin...
>>
>>>It's possible, Gavin, but I personally haven't tried it. You need an Access VBA guide to try.
>>>
>>>OTOH, I am releasing a utility here in the next few days that will convert report writer output to a Word Doc. With that utility and simple Word automation, you could create your RTF.
>>>
>>>
>>>>
>>>> I have a tricky question which I hope someone can help me with. I have a VFP6.0 Application that is used to capture customer survey information and I want to be able to produce a report of the questions asked and the nominated answers. The problem is that the report has to be able to be eMailed as an attachment. As the Foxpro report writer doesn't seem to be very good at outputing to a text file ( I need more than just ASCII text ), I decided to use the Access report Writer. All seem to work fine until I realised that I'd have to export the data from Foxpro and import it into Access. What I'd like to be able to do from my Foxpro Application is for the user to press a button on the surveys screen and all the nominated data be extracted and for Access to load up with the surveys report ready to print from the appropriate record source into an RTF file. Has anyone done this before? Is it possible?
>>>>
>>>>Thanks,
>>>> Gavin...
Previous
Reply
Map
View

Click here to load this message in the networking platform