VBA and VB although primarily look the same but there are a lot of VBA functions that VB doesn't understand.
I don't know of an easy way to do this other than rewriting sections of the code.
Hopefully someone else will have an answer that's more to your liking.
If it is of no bother please copy+paste this 'lengthy' code! I need it badly! We're working with a huge program, all structured as classes and with declaration-code looking like this:
Option Compare Database
Option Explicit
Private mform As Access.Form
Private mFkt As Object
Private mC_Connect As Access.ComboBox
Private mCI_DBTyp As Access.ComboBox
Private mC_DBTyp As Access.ComboBox
Private mFSuch As Access.ComboBox
Private mK_AA As Access.ComboBox
I see no other alternative!!I don't have the faintest idea how I would re-write it!Do you?
If it helps, here a few details about the program:
each form has it's own class ! Most classes have objects which allow polymorphism to occur and the mFSuch(for example) is a combo which could be needed in another class!
Please help!
I appreciate your help
thanx
kingz
I wish it were that simple. I am talking about a book on the subject here, however, if it that important, you might want to consider buying it. Have a look here.
There is another little utility you can use. But it does cost.
This will convert all your forms,queries,reports etc.. from Access to VB. Probably some tidying up to do but have a look
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.