Calling VBA modules in Access Data Pages 
Author Message
 Calling VBA modules in Access Data Pages

Hi All,

I am making a project in Access 2002 and I have an
Access data page, on this page I have a command button and
I like to call a module (I have wrote in VBA) from inside
the on click script for this command button. Is there any
way to call VBA modules from inside the VB script in
access data pages?

Best Regards
Peter



Sat, 02 Apr 2005 13:54:37 GMT  
 Calling VBA modules in Access Data Pages
You can copy the procedure to the DAP and call it from there easily enough.
--
Joe Fallon
Access MVP


Quote:
> Hi All,

> I am making a project in Access 2002 and I have an
> Access data page, on this page I have a command button and
> I like to call a module (I have wrote in VBA) from inside
> the on click script for this command button. Is there any
> way to call VBA modules from inside the VB script in
> access data pages?

> Best Regards
> Peter



Sun, 03 Apr 2005 11:47:52 GMT  
 Calling VBA modules in Access Data Pages
How many procs have you done this with where it actually worked in VBScript,
without major modification? ;-)

--
MichKa

This posting is provided "AS IS" with
no warranties, and confers no rights.


Quote:
> You can copy the procedure to the DAP and call it from there easily
enough.
> --
> Joe Fallon
> Access MVP



> > Hi All,

> > I am making a project in Access 2002 and I have an
> > Access data page, on this page I have a command button and
> > I like to call a module (I have wrote in VBA) from inside
> > the on click script for this command button. Is there any
> > way to call VBA modules from inside the VB script in
> > access data pages?

> > Best Regards
> > Peter



Sun, 03 Apr 2005 13:22:00 GMT  
 Calling VBA modules in Access Data Pages
Ohh 1 or 2. <g>

Point is they do need to work with VBScript which is a subset of VBA.
--
Joe Fallon
Access MVP



Quote:
> How many procs have you done this with where it actually worked in
VBScript,
> without major modification? ;-)

> --
> MichKa

> This posting is provided "AS IS" with
> no warranties, and confers no rights.



> > You can copy the procedure to the DAP and call it from there easily
> enough.
> > --
> > Joe Fallon
> > Access MVP



> > > Hi All,

> > > I am making a project in Access 2002 and I have an
> > > Access data page, on this page I have a command button and
> > > I like to call a module (I have wrote in VBA) from inside
> > > the on click script for this command button. Is there any
> > > way to call VBA modules from inside the VB script in
> > > access data pages?

> > > Best Regards
> > > Peter



Mon, 04 Apr 2005 00:05:11 GMT  
 Calling VBA modules in Access Data Pages
Yes, but VBA always has types and such, even ignoring the completely
different object models, almost all of it will just be wrong!

This is the reason why the TSI Frm/Rpt to DAP wizard puts the code behind
the page commented out -- so that someone can have it right there and do the
conversion. No way a free tool was ever going to have the money spent on it
to do that sophisticated level of conversion.... :-)

--
MichKa

This posting is provided "AS IS" with
no warranties, and confers no rights.


Quote:
> Ohh 1 or 2. <g>

> Point is they do need to work with VBScript which is a subset of VBA.
> --
> Joe Fallon
> Access MVP



> > How many procs have you done this with where it actually worked in
> VBScript,
> > without major modification? ;-)

> > --
> > MichKa

> > This posting is provided "AS IS" with
> > no warranties, and confers no rights.



> > > You can copy the procedure to the DAP and call it from there easily
> > enough.
> > > --
> > > Joe Fallon
> > > Access MVP



> > > > Hi All,

> > > > I am making a project in Access 2002 and I have an
> > > > Access data page, on this page I have a command button and
> > > > I like to call a module (I have wrote in VBA) from inside
> > > > the on click script for this command button. Is there any
> > > > way to call VBA modules from inside the VB script in
> > > > access data pages?

> > > > Best Regards
> > > > Peter



Mon, 04 Apr 2005 04:40:52 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Call Access Module from Data Access Page

2. calling/running MS Access module from ASP pages

3. Calling VBA functions in an Access database from an ASP page

4. DTS Packages called from VBA module

5. VBA modules called by stored query

6. Access VBA Calling MSWord/Excel VBA?

7. RESET data of a VBA module related to a form

8. Write report Data in Module VBA

9. Conversion of column data - types within VBA - Module

10. WSH calls VBA or VBA calls WSH

11. Returning data from asynchronusly called external module

12. calling Excel VBA macro from VBScript in Compiled Help HTML page

 

 
Powered by phpBB® Forum Software