Vb Versus Vba - Convert And Upgrade An Application
May 8, 2009
My company is in the process of analyzing how to convert and upgrade an application that was written in Microsoft Office Access 2003. Recently we purchased Microsoft Visual Studio 2005.
The first step we'll probably take will be to convert the Access data to Microsoft SQL. Is there a recommended way of doing that? What should be done with the VBA code?
The second step we're not sure about. We're wondering in we should develop all new software in VB or that we should still use VBA, if possible, after the data has been converted to SQL.
We currently have +- 20 different console application developed in VS2008 and running at different scheduled intervals, all controlled by Windows schedular. The problem we have come accross is that it is becoming increasingly difficult to manage and maintain these console apps. In some instances a console app will just fail or never run to start with and this creates a lot of problems. In many cases one console app is dependant on another and if 1st one fails well...you see where this is going.
I am looking for a new solution that will help us to trace, debug and manage these console apps better. We are preferably looking for a gui front end, maybe windows app where we can set the intervals for them to sun and view some error reports if they did not run.We are port all the code for the console apps to which ever new appliocation we develop.
When upgrading my old app, how do I preserved those old Application Setting that had been set by previous app, so that the new app can use back the old app setting?
just want to know what is the difference between these date values?Once some one told me that its difference is server date and client date but not sure which one he meant.Below is 3 type of date currently I'm using and don't know what is the difference between them.
DateTime.Now is from System.DateTime.Now Now is from Microsoft.VisualBasic.DateAndTime Today.date is also from System.DateTime
I have a few questions regarding the GUI applications.I am aware that Console applications are non-event based programs which do not have the pretty GUI interface.Having done C/C++ on *nix with a main() as the entry point and in Windows 3.1 with WinMain as the entry point into the application, I am trying to figure out the entry point into the VB application.
I have a situation with an application of mine where I noticed I get a different result when the application is installed in comparison to it running in Visual Studio. If the application is installed a certain aberration pops up in this computer graphics application at a certain point in one of the screens but if I run the same group of settings or you could say the same "screen" running the application from Visual Studio I don't see the aberration ever happen. I tried deleting the bin and obj folders and then rebuilding before creating an installation and it doesn't change anything and whether I use InstallShield or create an installation using ClickOnce I still see the same issue. I have Enable application framework unchecked but found it makes no difference checked or unchecked
I have a vb.net windows application. I want to convert some part of it to an application that can be run on all mobile platforms like iphone,windows mobile, ipad etc. It should be platform independent
I have a fully functional multi-threaded VB2008 console application that I need to convert to a windows forms application. I am doing this to add additional functionality at a later time. How would I go about doing this?
I have a console application code below. I am trying to convert this to a windows based form application but I don't know where to start. This code asks you to input a website and then it gives you the IP address for that particular website the user enters. All the code works fine but I want this in a windows form application.
using System; using System.Net; using System.Net.Sockets; class GTest
I have an application that is written in VB.NET, using the System.Windows.Forms.Form as the front-end GUI. It runs perfectly on my Windows machine however recently there is a business requirement to convert this application to run as a web application so that people could view them in their blackberries when they go to the URL. Is there any quick way to perform such a conversion or I will have to translate the code line-by-line for such cases?
I have been tasked with setting up an internal web application to become public facing. The web site was written in ASP.Net and I am just looking for some advice about how I should go about this procedure. Apart from hosting the site on a public facing server I don't know what else I would need to take into consideration.
I am not able to find the Exclude Command in VB 2010 Express. I have no idea which version of Visual Studio it is working with. I've got one 217MB VB 2010 Express file and many 2008 VB Express files with one of them measuring 31 MB. There many other SQL files and .Net Files.
Trying to figure out the best approach to convert a VB.net application built in VS 2008 and convert it to MAC OS 10. the app uses WebBrowser controls and Win API calls. I know very difficult to do... looking for a tool that does it or a pathway like convert to C++ then to Mac's C extended native lang.
I want a code and a ready executable format for a program that converts WPL (Windows Media Player Playlist) to a HTML code with this style in Visual Basic 2008
[URL]
I want the code to learn from it and the executable filee just for the quick action.
I get to convert a Delphi application to VB.Net.My last project i had to convert a Java app to VB.Net.Anyway I have most of the application converted however there are a few items that i have been unable to find the .Net equivalent. Most are from the Delphi. Sysutils class.
I am trying to convert an exe file to another file preferrably a BAT file or MSI fileI have converted an file into exe but now i want to convert it into another file
Private Sub Decode(ByVal strFrom As String, ByVal strTo As String) Dim fileIn As New StreamReader(strFrom) Dim fileOut As New StreamWriter(strTo)
I have the following code that i need to convert from a MS Office- Visual Basic App into a stand-alone application. I have debugged most of it to run in visual studio 2008, however it has a problem with the message box stuff. If i cant have a message box with the information in it then I want to put the output in a label but im not sure how to convert it to display in a label. [Code]
I've inherited a web site, which I've converted into a web application in VS2008. The conversion has worked for everything except a Gallery control.The compile error I'm getting is:Type 'Gallery' is not defined in file: gallery_oct07.aspx.designer.vb
Option Strict On Option Explicit On Partial Public Class gallery_oct07
I am very keen to build a simple application to convert AVI to jpg in order to learm a little about video processing. I know free applications that do this already exist. But, I'd still like to develop an application to help me learn more about avi's and to hone my programming skills a bit with a real project.I'm familiar with VB, so that's not a problem. I just don't know how to process an avi file nor how I would programmatically extract the frames from that file.Where should I start? What is required to extract frames out of the avi to individual jpgs?
I want to convert my project into application.But my program is working with the help of SQL Server through LAN.. I converted it as application software.. And It works well in my system only.. If i install and run it in some other system which doesn't have SQL Server,.Net framework, it shows Error.What i do now.
I have written an address book and for its database, I used Access to create a .mdb database and store my data programmatically into this .mdb file.However, the problem is that when reading and saving data to this kind of database I have to use Jet 4.0 which is NOT available on 64-bit systems and I have to compile my application as 32-bit in order to run on all systems.I just want to know how is upgrade to SQL?I never used SQL, can I create a stand-alone database file using SQL like Access and create tables/fields so I can modify it programmatically?I also need the database file to be independent and don't need any special requirements to run on target systems, like the .mdb file I've created in Access!
I have a problem with an friend of mine that uses for one of his server application a batch file to communicate with his server application.The problem is that he wants me to help him translating this batch file into an windows console application (actually he want this .bat file to be converted into an windows forms application - but having the console source code I can manage (I think) to put the code into buttons, textboxes, etc)My problem is to convert his script commands into .NET methods.I know that instead of echo I have to use Console.WriteLine but for the rest...
@echo off del folder\file.cfg del folder\folder\folder\folder\file.cfg del /q file\file\file\logs\*.*
