473,831 Members | 2,237 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Visual Basic Info

2 New Member
Hello, could someone please point me in the right direction? I often use Microsoft Access and to a lesser degree, Microsoft Excel. I need to learn more about writing code and am unsure as to whether I can do a course that would be applicable to both Access & Excel (would this be a Visual Basics for Applications course?) or just a Visual Basics for Access course?

Thanks for your help
Feb 1 '08 #1
5 1259
debasisdas
8,127 Recognized Expert Expert
What are you doing with access and excel ? Writing any macros ?
Feb 1 '08 #2
daniel aristidou
491 Contributor
I think your looking for a VBA course......
VBA Should work for both access and Excel..
My advice is to ask the teachers...
Feb 1 '08 #3
Dasher
2 New Member
Thanks for the replies.

I have been using macros in Access ut hav reached a point were i need to use and read other peoples code.
Work has offered to put me on courses and this is were im a little confused about VBA/VB.

So from the above post I assume VBA will apply to Access and Excell.

So if im going to put in the time learning code am I better of looking at specific course on Access or learn something that I may be able to apply to other programs/situations i.e. VBA ?

Does that make sense?
Feb 2 '08 #4
Killer42
8,435 Recognized Expert Expert
I don't know about the courses. But one way to pick up VBA in Excel is to record macros. Then you can edit them, and the code is there, already written for you. It's a fairly quick and easy way to learn how to perform specific tasks in VBA, and how the code fits together.
Feb 4 '08 #5
WinblowsME
58 New Member
My suggestion is to pick up a VB 6.0 book, or enroll in a VB 6.0 course (if they're still around). Then, migrate to VBA. Like Killer mentioned, Excel's Macro Recorder is a fast way to learn VBA, even faster if you know VB 6.0.
Feb 7 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3049
by: Joan S. Fuster | last post by:
Hola a todos. Soy un usuario de Access desde hace muchos años, y entiendo que le consigo bastante buen rendimiento. Sin embargo, nunca he programado en Visual Basic, por lo que algunos procedimientos me resultan muy difíciles de conseguir sólo con funciones y macros. Mi preguntas a quien me pudiera y quisiera responder serían:
11
22971
by: Tom_OM | last post by:
I just got a new computer and am having a beast of a time getting Visual Studio to install on it. The computer is an HP Pavilion a750e with an AMD Athlon 64/3700 processor, a gig of RAM, a 250 gig hard drive, and Windows XP Professional. I have MS Visual Studio Professional 6. The install process copies all the files to the hard drive -- the progress bar completes. Then I get the message, "Setup is updating your system" and then I...
2
3610
by: Ralph | last post by:
I used to have Visual Basic .net std. 2003 installed on WinXP SP1A. But I found it too hard to upgrade WinXP to SP2. Now, I do have WinXP SP2 installed, but I am having problems installing Visual Basic .net standard 2003. Not installing Visual Basic at the WinXP SP1A level - was the only way I found that I could install WinXPSP2. My computer was purchased with WinXP SP1 Professional. I also have Norton Internet Security and Norton...
26
10896
by: Bruno Jouhier [MVP] | last post by:
I'm currently experiencing a strange phenomenon: At my Office, Visual Studio takes a very long time to compile our solution (more than 1 minute for the first project). At home, Visual Studio compiles the same solution much faster (about 10 seconds for the first project). My home computer is only marginally faster than the one I have at the office (P4 2.53 vs. P4 2.4, same amount of RAM). On the slow machine, the CPU usage is very low,...
1
1383
by: new to VC++ | last post by:
i've been developing code in turbo C++ in a DOS based environment . Now that i've finally shifted to Visual C++ , i really can't get my old programs to work . I realised everything has changed . Even most of the libraries have changed . specifically how do i clear a window once the user provides info and display info in a clear window (a.k.a clrscr() in turbo C++ ) . Even multiple windows would be great but how do i do that ?? .
4
5172
by: Andy | last post by:
In visual studio, I have an asp.net project. When I debug, I have to manually attach to aspnet_wp.exe. My project used to automatically attach to this process. How do I get it to automatically attach to it again.
6
3095
by: Dusan Jan | last post by:
I get the following message when compiling or by background compile: Visual Basic .NET compiler is unable to recover from the following error: System Error &Hc0000005& (Visual Basic internal compiler error) Save your work and restart Visual Studio .NET. I have browsed for this issue and there are several reports on this. One claim that there is a kb article on this that asks to call MS for a patch. But no link to that article works.
6
2201
by: Chris Lane | last post by:
Hi, I have been searching for a possible list that shows what methods or properties in the System Names replace the ones in the Visual Basic Namespace so I can stop using the Visual Basic Namespace on new projects. Thus far I have been unable to find this information, please inform me. For example in the Visual Basic Namespace there are Control Characters like Tab and Back and so on. Where are the equivalents in the System Namespace?
10
8210
by: Steve | last post by:
I am trying to create a DLL in Visual Studio 2005-Visual Basic that contains custom functions. I believe I need to use COM interop to allow VBA code in Excel 2002 to access it. I've studied everything I can find on COM Interop and .NET. I've also tried many of the 'Walkthroughs' on the MSDN site relating to COM add-ins, .NET and Office XP but am unable to get even these working in Excel 2002 or Word 2002. I've installed the Office XP...
0
1260
by: Gloria | last post by:
Hi all, I created a DTS package in SQL Server 2000 that creates several stored procedures. I need to run this package as part of an installation program for an application that uses the stored procedures. In the past I saved the DTS package as a Visual Basic file, compiled the Visual Basic file in the Visual Studio 6.0 environment and ran the executable during the installation. I want to do the same thing using Visual Basic in Visual...
0
9793
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
9642
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
10493
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7747
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
5617
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5780
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4416
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
3960
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3076
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.