Solved

VB vs. VBA - dumb question; please humor me

Posted on 2010-09-24
7
443 Views
Last Modified: 2012-05-10
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
Comment
Question by:dgmoore1
7 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 33755345
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
 

Author Comment

by:dgmoore1
ID: 33755352
I'm even less experienced with VB .net, alas...
0
 
LVL 33

Expert Comment

by:jppinto
ID: 33755401
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 10

Expert Comment

by:3_S
ID: 33755410
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
 
LVL 16

Accepted Solution

by:
carsRST earned 500 total points
ID: 33755415
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
 

Author Closing Comment

by:dgmoore1
ID: 33755627
I think this might be my best approach
0
 

Author Comment

by:dgmoore1
ID: 33755630
I mean to use VBScript, that is...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Write data from SQL to CSV file - position 1 52
Cannot enter table caption text in Word protected document 6 111
Put text in a picture ASP.NET C# 2 50
Copy a row 12 57
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now