How does one convert VBA to VBScript?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a fairly new web site designer who is very, VERY new at Access. I've
been asked to put a previously-built database on the web so that users can
interact and search and add to it. The person who programmed the database in
Access created forms through which this interaction is supposed to take
place. But the command buttons that trigger the event procedures he
programmed don't work when I turn these forms to data access pages. My guess
here is that I'm dealing with a script translation problem.

I've downloaded a wizard that will convert the forms, but the instructions
require that I convert the commented out code from VBA to VBScript. And I
have no idea what that means.

Anybody?
 
siuMike said:
I am a fairly new web site designer who
is very, VERY new at Access. I've
been asked to put a previously-built database
on the web so that users can interact and
search and add to it. The person who prog-
rammed the database in Access created forms
through which this interaction is supposed to take
place. But the command buttons that trigger
the event procedures he programmed don't
work when I turn these forms to data access
pages. My guess here is that I'm dealing with
a script translation problem.

I've downloaded a wizard that will convert
the forms, but the instructions require that I
convert the commented out code from VBA
to VBScript. And I have no idea what that
means.
Click to expand...

You need to have someone do that work who is conversant both in VBA and in
vbscript.

You should also be aware that DAPs are being "deprecated" in the next
version of Access, so you will have to continue to maintain them in Access
2003 or earlier. You should also be aware that all users must be running
Internet Explorer of a recent vintage, and have the Office Web Extensions
installed. Given these limitations, most users found DAPs useful only on
intranets where the user's environments could be closely controlled.

If you create .asp pages, you should be familiar with vbscript or
javascript. If you use vbscript, you may be able to puzzle out most of the
translation. But, you might find it just as easy, or nearly as easy, to
create .asp pages that have comparable functionality. If you are primarily a
graphic designer, then you need to find a "web programmer."

Larry Linson
Microsoft Access MVP
 
Back
Top