Re: Notating out old code in Access Database

Tech-Archive recommends: Fix windows errors by optimizing your registry


"NALewis" <NALewis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:834CD4C4-6F94-4940-B872-A3FABD380B17@xxxxxxxxxxxxxxxx

I guess I wasn't very clear. The coding is in an older version of VB, and
I
have been viewing it with Visual Basic 6.5. I have only used VB.NET
though,
so I recognize many elements of the code, but not all. I also have never
done any programming with Access. I was hoping someone might be able to
offer suggestions as to how I should approach this project or comment on
the
feasibility of a novice undertaking a project like this.


Your dealing with VBA, not VB5/6. In this case MSAccess VBA.

A quick summary of the main differences. VBA and VB share a 'core' VB
language, but VBA can only live within a container (the supporting
application). For example, it doesn't have any base I/O services - it can't
print or read/write outside resources. Instead it uses the services supplied
by the container. In addition it also may use other container supplied
interfaces/information. For example, MSAccess supplies a "DoCmd" function
which isn't part of VB.

My suggestion, get a book on MSAccess VBA programming for the version of
MSAccess you are using. Also post questions in one of the MSAccess
newsgroups.

-ralph




.

Relevant Pages

  • Re: msaccess.exe API calls: where to get the function call description
    ... This is because Windows is an OS. ... a basic understanding of programming that many or ... To use MSAccess functions one would have to find an entry point. ... emulated in VBA. ...
    (comp.databases.ms-access)
  • Re: VB .net - A question for Microsoft Moderators...
    ... concrete information on the direction of VBA and of any VSA successor is ... I've never been happy with placations from Microsoft that ... Visual Studio white papers and scan through Visual Studio Express Beta's only ... > is still there as the only integrated method for doing Office programming. ...
    (microsoft.public.office.developer.vba)
  • Re: Is Excel VBA best for me?
    ... > retired and searching for a programming environment ... > expect to integrate the simulations into Excel spreadsheets. ... > Excel VBA seems like an "obvious choice", ...
    (microsoft.public.excel.programming)
  • Re: Word 2003 VB IDE & VB2005
    ... VB.NET syntax can't easily be grafted into the internal layout of templates to replace VBA for reasons of backwards compatibility, and the VB.NET IDE can't be made available with VBA as the language being edited, unless the underlying code for the editor were fundamentally changed. ... Another is performance of the completed application, another is the time and effort necessary to create a deployment package. ... The principles involved in programming are much the same, and sound programming techniques can be taught and learned in any language. ...
    (microsoft.public.word.vba.general)
  • Re: Why VBA is a good programing language
    ... VBA is a fine programming ... > supporting a VBA application on a large scale are a serious. ... templates using SMS or login scripts. ... thoroughly badly behaved applications like the Acrobat add-in. ...
    (microsoft.public.word.vba.customization)