Populate dataa onto reports and forms automattically

[ppaeee]

how do i populate data onto forms and reports in access 2003 automatically that come forms that are saved as pages (online based)

 

[JamesMcS]

how is the data saved? As an html document?

 

[ppaeee]

Hi

yeah the forms will be saved as html- but how do i save the forms from access as html- do you use the pages tab on access?

I am creating an online booking system where when a user enters data it gets populated automatically onto forms and reports in accesss>?? how do i do this? any tutorials i can use

thanks

 

[ppaeee]

is there anyone you know that are experts with access that can help me online? i need to finish this project ASAP

 

[JamesMcS]

If you're using Access 2003, create a data access page. You can publish that to the web, and by definition it will be linked to the tables you base it on. Then, as users enter data into the DAP, tables will be populated, and you can create a report based upon that table.

If you're using Access 07 it's a little bit different. User:Mr. B has recommended some free Microsoft web page tools which can be found here:

http://www.microsoft.com/express/Web/

 

[JamesMcS]

Also, there's thousands of experts online who can do this for you, they're called developers But get your cheque book ready

 

[ppaeee]

how would i do login and password on data accesss page?

 

[ppaeee]

also how do i do help icons so when the user preesses it will provide them with help

 

[ppaeee]

i cant create a data access pagee. Its say i need to reinstall OLE server dont know how to do this?

could you tell me how?

it givee me this message:

This error can appear if an attempt is made to save a form or a report as a data access page in an Access project (ADP) file and a combo box or list box control on the form or report has a RowSource property set to the name of a table, view, or function.
Set the RowSource property of the control to the name of a stored procedure or an SQL SELECT statement that selects only the proper field(s).
More information about this error message online.


how do i solve this

 

[JamesMcS]

I've not had a lot of experience with them to be honest. Try doing what the error syas and see if it solves the problem.