473,946 Members | 15,468 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to migrate a VBA project to VB

Please guide me , Is there any migration tool or a way to migrate VBA
project into VB.

Thanks

Nov 13 '05 #1
4 2130
Per nikki:
Please guide me , Is there any migration tool or a way to migrate VBA
project into VB.


There are a couple, but I've never actually done a migration with any of them.

The low-end/freebies I tested didn't survive much stresss at all.

The one high-end product I tested held up under a hundred or so forms, but I
never actually did a conversion with it.

This was a few years ago and I can't recall any names.

--
PeteCresswell
Nov 13 '05 #2
Per nikki:
Please guide me , Is there any migration tool or a way to migrate VBA
project into VB.


I should add that the it seemed to me like the primary benefit of using one of
those conversion utilities was getting the screens moved over - i.e. saving all
the manhours/tedium of aligning labels with fields and so-forth.

As far as event coding goes, it didn't look good to me. Witness MS Access's
combo box vs VB's..... totally different events, completely different code
required. Also think about MS Access queries. There's no equivalent on the
VB side.

My conclusion at the time was that cost justification would be based on the
estimated manhour savings in converting the screens. In fact, for the app I
was going to use it on, it made sense to purchase the tool....but the project
was cancelled and we never actually did it.
--
PeteCresswell
Nov 13 '05 #3
"nikki" wrote
Please guide me , Is there any migration
tool or a way to migrate VBA
project into VB.


Do you mean that you want to convert an Access database application to a
(classic) Visual Basic database application or to a VB.NET database
application?

Unless you are compelled to do so, that is rarely a worthwhile conversion in
either a multiuser or client-server environment. And, to convert to a
web-based application is not a "conversion ", but a re-write, generally.

What is it that you hope to accomplish?

Larry Linson
Microsoft Access MVP
Nov 13 '05 #4
"nikki" <an*****@gmail. com> wrote:
Please guide me , Is there any migration tool or a way to migrate VBA
project into VB.


Convert Access to Visual Basic, Delphi, Java, ASP or ASP.NET
http://www.granite.ab.ca/access/accesstovb.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1176
by: amtaam | last post by:
Hello All, Iam working on a project to migrate data from Bull GCOS7 files to Windows ASCII files. can anybody gives me ideas? Every kind of help is welcomed. thanks
1
1437
by: Bruno BAGUETTE | last post by:
Hello, Where is the tool to migrate a mysql db to a PostgreSQL db ? The only thing I can find is an empty projet in the Gborg http://gborg.postgresql.org/project/mysql2psql/projdisplay.php Thanks in advance :-) ---------------------------------------
2
5919
by: narasingarao | last post by:
Hi to group, I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project period here i have to migrate the MS-Access database table to Oracle data base tables...so, please help me in getting this....if possible plz send me the sample code.. thanking you,
3
1533
by: CL | last post by:
I began a project for a "client" (I don't do this for a living, I did it as a favor) using Excel. At the time I wrote it, there was one user, one production site and the data was flat. Essentially, I had a main spreadsheet with the date in, pallet, type of pallet, weight, date out, truck and client. Along with that, I had several spreadsheets that showed statistics for each pallet type over a period, sheets showing information on...
1
1279
by: chuliu | last post by:
I want to develop the project from my home pc and the project is originally in my office developing by a group of developers, myself included. VSS is implemented. I am running win2k pro in my office pc which has visual studio .net installed. The source safe server is on another pc. I tried to zip the source code from my office pc running win2000 and take it home to my home pc running winxp and also has visual studio .net. However, when I...
6
1254
by: HK | last post by:
I can't believe that I've bought a couple books on ASP 2.0 and nothing says how to migrate a current project. I searched google and find all kinds of intense junk about compatibility, etc. but nothing with a few simple steps to upgrade the project. Maybe we won't be using all the new classes and that's fine, but I just want to get a few web projects running under VS2005 so new code can be written in VS2005. What the heck do I do? ...
0
829
by: dsoto | last post by:
Hi, I've created a web a few week ago in asp.net 2.0 with visual studio 2005, but I've realized I need it as a project, because I need to place it in my localhost/server to allow everyone to use it. So, the question is, can i migrate/converse it to a project as it was alway in the past versions of visual studio? thanks a lot.
0
1200
by: johnlim20088 | last post by:
Hi, Hi, currently I facing issues of migrate existing Visual Studio 2002 projects to Visual Studio 2005. I understood that there is no problem if we develop a new project from Visual Studio 2005. BUT we does FACING problems when try to migrate/convert from existing Visual Studio 2002 source to Visual Studio 2005 source. We does using existing convertion tools which Visual Studio 2005 provided. But encounter many problem. Any One...
0
1147
by: johnlim20088 | last post by:
Hi, Hi, currently I facing issues of migrate existing Visual Studio 2002 projects to Visual Studio 2005. I understood that there is no problem if we develop a new project from Visual Studio 2005. BUT we does FACING problems when try to migrate/convert from existing Visual Studio 2002 source to Visual Studio 2005 source. We does using existing convertion tools which Visual Studio 2005 provided. But encounter many problem. Any One...
0
10150
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9975
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10679
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9873
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8240
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6318
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4928
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4524
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3525
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.