[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

VB vs. VBA - dumb question; please humor me

I am a longtime VBA developer with advanced skills, but my experience with VB is very limited. What's the quickest way for me to learn to work with queries and tables in VB? I need to create an executable that will perform actions similar to those already implemented in a MSAccess app so it can run as part of a process on a server where MSOffice/Access is not installed.
0
dgmoore1
Asked:
dgmoore1
1 Solution
 
Patrick MatthewsCommented:
The very first thing to do: make sure that you are learning VB.Net and not VB6.  Despite the similar names, they are very different beasts :)
0
 
dgmoore1Author Commented:
I'm even less experienced with VB .net, alas...
0
 
jppintoCommented:
The quickest way to learn VB is to start using it! :)

Install Visual Studio and buy a beginner book and start making something. You will have some doubts, some questions, that you can post for instance here at EE. The book will help you understand the principles of VB .Net. With a bit of practise you will see that it's not so hard to make the jump from VBA.

jppinto
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
3_SCommented:
Do you already use ADO in VBA?
Then there is no much difference between VBA and VB6. Only in making the connection to you database

Some questions
Do you want to use early or late binding?
Do you want to use as DSN?

If you don't know what this mean just ask.
Then I can give an example code. Or you could post a part of you VBA code you want in VB.
0
 
carsRSTCommented:
I'm unclear on your overall goal.  If it's to learn VB job reasons, then do what matthewspatrick says.  

If you have been given a task, the quickest way, given your skill set, is to create a VBS script.  Just use ADO to connect to your access database.  You do not have to have Access installed from where it's run.
0
 
dgmoore1Author Commented:
I think this might be my best approach
0
 
dgmoore1Author Commented:
I mean to use VBScript, that is...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now