Can I use MS ACCESS forms?

[tjessejeff]

I am new to VB6 development. I am trying to convert a ACCESS database to VB6. There are forms that uses subforms. Is there a way to copy or use the forms with subforms in VB6? Or is there a way in VB6 to create forms with subform?

 

[petermeachem]

Answered elsewhere. I wish people wouldn't cross post. Unless you haven't, in which case apologies. Peter Meachem
peter@accuflight.com

 

[tjessejeff]

I haven't crossed post. I am creating a VB6 application from an ACCESS application. There are four forms that uses subforms and are rather time consuming if I have to recreate the in VB6 code. I was wondering if there is a way to either use or port or recreate easier in VB6. If not, is there an easier way to create the effects of subforms that respond to combo box selections.

 

[petermeachem]

I'm sorry. I'm sure I answered this for someone, can't find my reply now.
You need to do the forms from scratch. You should be able to copy/paste the code and do global edits to account for the differences. You may well have problems with combos. The Access one is much better as it has multi columns and other features. If you can't legally use the Access one, you may need to buy a third party control.
I converted a big project like this. It's not too bad once you get into the swing of it. The worst bit was the reports that I had to re-do in Crystal. That took the longest.
(I'm sure I've typed all this in already today. Must be getting old) Peter Meachem
peter@accuflight.com

 

[tjessejeff]

Thank you for your response. I see I have a lot of work ahead of me. And thanks for the info on the reports. I am sure I would have had a question on that when I got to that point.

 

[petermeachem]

It took me two weeks of extremely hard work to convert an Access project with about 40 forms and 10 reports. Two or three of the forms were biggies. Some were tiny, just to select a date for a report or similar and quite a lot needed little more than plonking a Janus grid (highly recommended) on a form and setting a record source.
The customer bet me I couldn't do it in two weeks and said they would pay me 50% extra if I did. I had quoted 3 weeks would would have been reasonable. Peter Meachem
peter@accuflight.com