Transfer Data from Html Form to access table

[daameta]

Hello every one,
I am back With New Question. i have a table in ms access 2010 called tbl1. and a form for data entry called frm1. is it possible that i can enter data from html form in my internet explorer. if yes what is method to do this. remember when frm1 available in internet explorer no database or ms access file opened with this.
thanks for your guidance and reply

 

[CJ_London]

is it possible that i can enter data from html form in my internet explorer. if yes what is method to do this.

not quite sure what you are asking - but you could copy/paste each field

another option would be to copy the web page and paste to an unbound textbox set to plaintext, then use string functions (such as left/mid/right/instr/instrrev) to find the relevant field values

 

[daameta]

thanks cj london
i am asking a method to use a html page as form. and all data will be go in database table called tbl1.

 

[CJ_London]

you would need to build a web database (access 2010 and later) to have forms to run in your browser.

Or use something like visual studio to create your forms

if it is interacting with a database, then the database does need to be open, but normally for web databases you would use sharepoint. This is not my area of expertise so cannot really help more.

 

[prowaseem]

i dont think this could happen in this way ! otherwise share what you got

 

[CJ_London]

otherwise share what you got

nothing to share other than what has already been provided. download the free version visual studio and give it a try