I am new to Access. I have created a Data Access Page to use as a form for employees in my office. Most people do not have Access, but everyone has Internet Explorer, so a Data Access Page was my only alternative (unless there is another option, I would love to hear it if there is). I am using Access 2000. My problem is that after people fill in the text boxes, they want to save the page with the filled in data; they want to keep an electronic record of the form. The problem is when they save the form after filling it out, the entered data is gone when the saved web page is opened. I have tried saving it as a complete web page and as a web archive to no avail. I suspect this problem has to do with "persistence," but I am not certain. I would greatly appreciate any suggestions on how the pages can be saved after being filled out. All text boxes are unbound. Thank you in advance for your help!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Saving data entered into a Data Access Page 1
- Thread starter Xodarapa
- Start date
-
1
- #2
Databaseguy
MIS
In order to edit your data, the following conditions have to be met:
1. The primary key field must be included on the page
2. Your page can only contain data from a singel source
3. You must use simpe controls. Text boxes, Combo Boxes, etc.
4. You can only display a single row at a time
See the View Products Data Access Page in the Northwind Sample Database. It allows edtiting...
1. The primary key field must be included on the page
2. Your page can only contain data from a singel source
3. You must use simpe controls. Text boxes, Combo Boxes, etc.
4. You can only display a single row at a time
See the View Products Data Access Page in the Northwind Sample Database. It allows edtiting...
- Thread starter
- #3
Thank you Databaseguy for your suggestion.
My Data Access Page is not attached to a table or query, and I do not want to update any values in an underlying table/query. I just want to use the page as a simple form that can be printed immediately and hopefully saved as a web archive (.mht file). It is my understanding that Access 2000 no longer enables publishing of forms as they are trying to push data access pages, therefore I have no choice but to use a data access page. Since there is no underlying table or query, I can not include a primary key on my page; all the controls are unbound. Any more suggestions would be greatly appreciated. Thanks again.
My Data Access Page is not attached to a table or query, and I do not want to update any values in an underlying table/query. I just want to use the page as a simple form that can be printed immediately and hopefully saved as a web archive (.mht file). It is my understanding that Access 2000 no longer enables publishing of forms as they are trying to push data access pages, therefore I have no choice but to use a data access page. Since there is no underlying table or query, I can not include a primary key on my page; all the controls are unbound. Any more suggestions would be greatly appreciated. Thanks again.
gusbrunston
Programmer
Well...
For one, while I know zilch about data access pages, I can't understand why you're using Access at all. Your objects are not connected to any database, so the information entered by the users has no place to be stored. I use web based forms filled out by web visitors and the info shows up in my email (Outlook). Sorry if I've missed the point. Maybe you should put a one-table database on the web server and store the form and info there.
Gus Brunston
An old PICKer
padregus@home.com
For one, while I know zilch about data access pages, I can't understand why you're using Access at all. Your objects are not connected to any database, so the information entered by the users has no place to be stored. I use web based forms filled out by web visitors and the info shows up in my email (Outlook). Sorry if I've missed the point. Maybe you should put a one-table database on the web server and store the form and info there.
Gus BrunstonAn old PICKer
padregus@home.com
- Thread starter
- #5
Dear Gus:
I originally designed the form in Word, but Word's support for forms that can be filled in is very rudimentary. I do not know much programming (yet) and you can not control the tabbing order of fill-in fields in Word forms without programming, and you can not create fields that except user input that will wrap to more than one line (that I know of, and if you can, there is that programming problem again). It is simple in Access to adjust tabbing order through the properties of the text box. I could have used a combination of just Word tables (instead of multi-line fill-in fields)and check boxes, but I ran into an issue of teaching everyone in the office how to unprotect the form to enter data into the table and protect it again to use the check boxes, but then there is the problem of lossing data already entered into a form when it is unprotected in Word (Again, programming would solve this problem, but...) and there is also the problem of many people in my office being a bit technologically phobic. The form I needed to electronically recreate uses many check boxes and multi-line fields; the data access page works beautifully except for the saving problem, which by the way, was not an original criteria for the form. It looks like I have to learn VBA sooner than later. Any suggestions from anyone out there on how to alter the behaviour of the data access page through it's properties or the properties of the text boxes would be great. I read something about the Text property of a control and suspect my answer revolves around that, but I am not sure how, where, or when to use this property. Thanks again.
I originally designed the form in Word, but Word's support for forms that can be filled in is very rudimentary. I do not know much programming (yet) and you can not control the tabbing order of fill-in fields in Word forms without programming, and you can not create fields that except user input that will wrap to more than one line (that I know of, and if you can, there is that programming problem again). It is simple in Access to adjust tabbing order through the properties of the text box. I could have used a combination of just Word tables (instead of multi-line fill-in fields)and check boxes, but I ran into an issue of teaching everyone in the office how to unprotect the form to enter data into the table and protect it again to use the check boxes, but then there is the problem of lossing data already entered into a form when it is unprotected in Word (Again, programming would solve this problem, but...) and there is also the problem of many people in my office being a bit technologically phobic. The form I needed to electronically recreate uses many check boxes and multi-line fields; the data access page works beautifully except for the saving problem, which by the way, was not an original criteria for the form. It looks like I have to learn VBA sooner than later. Any suggestions from anyone out there on how to alter the behaviour of the data access page through it's properties or the properties of the text boxes would be great. I read something about the Text property of a control and suspect my answer revolves around that, but I am not sure how, where, or when to use this property. Thanks again.
gusbrunston
Programmer
Hi again:
My biggest problems: 1) I can't stand to see people suffer; 2) I'm fairly new to Access (but where are the gurus when you need them?); 3) I have a hard time keeping my mouth shut, so...
1. You know more about Data Access Pages than I do;
2. But, you can create a database with a table and create a form without "programming."
3. So, why not create a table (make sure the wizard is turned on), put the fields into it that you want (making sure you have a primary key...see "databaseguy" above...)
4. Let the wizard create your form.
5. Put the database and form on your server...and then use your Data Access Page. You may have to put a licensed Access on each workstation, or make a standalone program . . . but the users can save their data and later look it up using the form they input with...
You may have a reference book; if not, mine is Running Microsoft Access2000 from Microsoft Press, $44.99.
Best of luck,
Gus Brunston
An old PICKer
padregus@home.com
My biggest problems: 1) I can't stand to see people suffer; 2) I'm fairly new to Access (but where are the gurus when you need them?); 3) I have a hard time keeping my mouth shut, so...
1. You know more about Data Access Pages than I do;
2. But, you can create a database with a table and create a form without "programming."
3. So, why not create a table (make sure the wizard is turned on), put the fields into it that you want (making sure you have a primary key...see "databaseguy" above...)
4. Let the wizard create your form.
5. Put the database and form on your server...and then use your Data Access Page. You may have to put a licensed Access on each workstation, or make a standalone program . . . but the users can save their data and later look it up using the form they input with...
You may have a reference book; if not, mine is Running Microsoft Access2000 from Microsoft Press, $44.99.
Best of luck,
Gus BrunstonAn old PICKer
padregus@home.com
- Thread starter
- #7
Gus:
Unfortunately, I am not the systems administrator at my job, as was hired as an administrative assistant, so I am not allowed access to the network and I am not allowed to install programs (it is a very frustrating situation!) I put personal web server on my machine (windows 98) but the DNS server in the office is not set up correctly and a WINS server is not installed so many people in my office can not access the site on my machine. The system's administrator would have a heart attack if I suggested installing Internet Information Server on the server; needless to say she would not let me try and troubleshoot the address resolution problems. The upshot of all of this is that I can not design anything that would have to return data to an underlying table. I just found out that everyone in the office will be getting Access soon, so that might help the situation some. I was under the impression that you can not create a stand-alone program with Access for distribution unless you have the developer edition, which I do not. I think the answer lies in modifying the html so that the data is returned to the form, but the html source editor is not installed on my machine, and I have to hunt down the systems admin to install it, which can take some time to do. BTW: I have a hard time keeping my mouth shut also! Thanks for the suggestions...
Still Suffering
Databaseguy
MIS
Me Again.
As far as you personal web server, I believe (not sure, I'm new to DBs + Internet) that the people in your office can hit your web site by using your IP address. I just confirmed that by hitting my PWS by using an IP address.
I'm still trying to figure out exactly what it is you're trying to do. Could you E-mail me the form ??? If I get a better idea I could probably help.
As far as you personal web server, I believe (not sure, I'm new to DBs + Internet) that the people in your office can hit your web site by using your IP address. I just confirmed that by hitting my PWS by using an IP address.
I'm still trying to figure out exactly what it is you're trying to do. Could you E-mail me the form ??? If I get a better idea I could probably help.
- Thread starter
- #9
Gus:
Our office uses DHCP, not static IP addresses, so I would have to inform everybody in the office whenever I get a new IP address; and my administrator will not reserve an address for me. I am going to have to put this issue on the side right now because my office is getting new carpet, and right now I am packing up all the things on my desk...the computer is next! Thank you very much for your attempts at helping my resolve this...I appreciate the effort!
Our office uses DHCP, not static IP addresses, so I would have to inform everybody in the office whenever I get a new IP address; and my administrator will not reserve an address for me. I am going to have to put this issue on the side right now because my office is getting new carpet, and right now I am packing up all the things on my desk...the computer is next! Thank you very much for your attempts at helping my resolve this...I appreciate the effort!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
