Access Forms to VB project? 1

[mikeyb540]

Just a Q... Is it possible to transfer my A2000 forms to a VB project?

 

[randysmid]

Hi,
Yes, it is possible, but not that easy to do. As you know, a VB form is a text file with the .frm extension. If you print out a simple form, you will see how the VB form is structured. I wrote an FAQ on how to write to a text file (see faq703-3767).

On the Access side, all forms are stored in the AllForms collection. Here is some information from the Visual Basic help inside of Access:

AllForms Collection Example

The following example prints the name of each open AccessObject object in the AllForms collection.

Sub AllForms()
Dim obj As AccessObject, dbs As Object
Set dbs = Application.CurrentProject
' Search for open AccessObject objects in AllForms collection.
For Each obj In dbs.AllForms
If obj.IsLoaded = TRUE then
' Print name of obj.
Debug.Print obj.Name
End If
Next obj
End Sub

So, each form object has properties, which can then be written to your form text file.


HTH,
Randy Smith, MCP
California Teachers Association

 

[mikeyb540]

Great... I will try it.
txs

 

[randysmid]

Hi,
Obviously, there is alot more to it than just this. For instance, your form will have some properties that are specific to the form, such as recordsource, size, backcolor, forecolor, etc. Then, each control on the form will also have some unique properties, including the type of control, size, location, etc.
You may want to start exploring the MSDN area for Access 2000 for "object models". Here are a few links to get you started:
Controls on forms:

http://msdn.microsoft.com/library/d...jectspropertiesmethodsofapplicationobject.asp

AllForms Collection (on MSDN)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/accolallforms.asp

Controls collection

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/accolallforms.asp

Hopefully, this will be enough to get you started in the right direction. HEY, you might even be able to sell this utility later!!!!



HTH,
Randy Smith, MCP
California Teachers Association

 

[randysmid]

Hi,
You will also need to know about the Section property for the various forms. Here is the MSDN link to that:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/accolControls.asp

HTH,
Randy Smith, MCP
California Teachers Association

 

[MichaelRed]

It is also possible to add the Ms. A. Forms 2.0 To the references for a VB project. If you do not do this, some of hte pproperties of the Ms. A. Forms will not be available to the VB version os the forms / controls and you will get errors in the VB version. Although I have not attempted to do so, it may be possible, with the Ms. A. Forms 2.0 reference in the VB project, to simply use the copyobject method in VB to just get the complete form object from the Ms. A. App.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[mikeyb540]

I think i opened a major can of worms
Thanks for you feedback Randy and Michael

Started playing with AccessToVB 4.7
What a headache!!! More time to convert then re-do my forms in VB6

 

[MichaelRed]

?????????/ Access To VB 4.7 ??????????!!!!!!!!!!!!


Which specific PRE-HISTORY organization are you with??????







MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[mikeyb540]

Below is the link. It is not all that but maybe you would find it useful. The Demo works only on the Northwind but you can either buy the license or find the license

http://www.vbxtras.com/products/accesstovb.asp

 

[mikeyb540]

Hey... I just relized your sarcasm.
Its the lates relase out there.

What's the problem?