PLEASE HELP!!

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

Guest

Hi...I have spent the past couple of months creating a database for a survey
that will be posted online so that people can fill it out. I created a very
long form, with code and subforms,etc...and then after bringing it to the
person who is putting it online, I realized that I have to put the form into
"page" format in order for it to be posted onto the web. I tried using the
"Save as page" function, but it didn't work. Is there anyway i can do this
without having to redo the entire thing? also, it seems as though these
"pages" don't support subforms or code. Is there any other option?? any
advice would be greatly appreciated!!!!!!
 
Data Access Pages (DAPs) are a completely different animal from forms.
Except for very simple forms, you likely will need to rebuild the entire
form's functionality manually in a DAP. And, DAPs do not use DAO
recordsets... and they use VBScript, not VBA.... and they do not have all
the same built-in functions that VBA has... and they use ADO recordsets for
all queries and recordsets... and many multitable queries that are updatable
in forms are not updatable in DAPs... and they don't have "subforms", but
have groups instead... and so on.

DAPs are a very steep learning curve..... likely, you'll need to start from
scratch with what you've designed so far.

See www.msdn.com for various articles about DAPs -- navigate to the library
and search on Office and then Data Access Page.
 
Back
Top