Linking VBA Code using a Macro

[sandeep23]

Hi,

I am Sandeep. I am using MS Access 2010 with SQL SERVER 2008 R2

I have to develop a web site consisting of Web Forms with web database. I need to populate the data from SQL SERVER to a web form in ms access.
I am able to do the same thing using blank web database with normal forms.

I am struck at a start point My Questions are:

1. Do we need to use macros for that reason to populate the records from sql server to ms access forms?
2. If Yes, how to write VBA Code and link that to a macro?
3. Do we need to use the Queries for populating the records from SQL SERVER to ms access web forms?


Thanks,
Sandeep Kumar.

 

[sandeep23]

I am novice to MS Access and basically a Dot Net developer. Can you please help me in writing a VBA Code for a button click in web form of MS Access.
Can I use only VBA Code without using Macro's for a button click? if yes, how can I ? Again I saying, i am using MS Access 2010.