Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slbmis
Starting Member
7 Posts |
 Posted - 2002-03-13 : 17:04:46
|
| how difficult would it be to transport Microsoft access 2000 code unto visual basic 6.Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-13 : 17:15:37
|
| It shouldn't be too bad, because they both use Visual Basic. Make sure that your VB project includes the same References that your Access project has (the Microsoft Access object library, the DAO library, etc.) You can find the References listed under the Tools menu in the Access VB Editor.You may need to re-arrange the modules from Access in VB, especially if you have Form modules. Form module code and report code may have to be created as class modules (that's how they are treated in Access). Once you do get the code transferred, do a compile on it and check for errors. Naturally, any reference to Access objects will need to be modified, since the VB project will not automatically see them (forms, reports, etc.) |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-03-13 : 17:26:06
|
| There are some noteable differences however, especially with the way things like combos and list boxes work. - eg you don't have an "afterupdate" event with the combos in VB6.Oh and reports are going to be very different....But in general - it's not too bad - as long as you can accept some slight differences in the way the interface operates.....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2002-03-14 : 10:45:39
|
| If you're looking to redistribute the code you can't redistribute the Access controls. If you don't redo your forms with the redistributable VB controls your program will require Access on the target machine.There is a access to vb converter program out there somewhere, I've heard (but never used).======Doug G====== |
|
|
|
|
|
|
Visual Basic 6 and MS access