98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Link an access form to the intranet
microsoft training access course - Link an access form to the intranet
Resolved · Low Priority · Version Standard
Thu 29 Nov 2007, 10:06Delegate Julie said...
Julie has attended:
Access Advanced course
Access VBA course
Link an access form to the intranet
I have a database for measurement requests and all most of the users need to be able to do is fill in one form to submit a request. Ideally this would be linked to our company intranet.
Is there a simple way to do this? Previously i have made a backend database and then got everyone to download a copy of the front end to their desktop but in this instance that is not appropriate due to the number of users. I could have one copy of the front end on our server for everyone to use but i'm concerned about multiple users of one instance causing problems.
Any ideas would be appreciated!
Fri 30 Nov 2007, 15:08Trainer Pete said...
RE: Link an access form to the intranet
Hi Julie, Thank you for your post, In answer to your question, I would suggest you try a Data Access Page, this can be edited by any number of users on your company intranet, and will not cause problems of multiple users entering data simultaneously.
To create a Data Access Page from a form, go to menu item File, Save As and from the Type option drop down choose Data Access Page, this will create a separate HTML document of your Form which can be used to enter and view data. The entries will update your database form. ... I hope that helps, best regards Pete.
Thu 28 Feb 2008, 11:16Delegate Julie said...
RE: Link an access form to the intranet
The form in the database has a piece of code in the save and send button which sends the originator of the request and email to give them their request number and a second email to the metrology manager to notify him of the request.
If i do it as a data access page will this still work?
Fri 14 Mar 2008, 09:21Trainer Pete said...
RE: Link an access form to the intranet
Hi Julie, I really cant say without seeing the whole thing, a data access page is written in HTML, so if the piece of code is able to be re-written by Access into HTML there is no reason why it should not work.
All I can suggest is that you create a copy of your database, and then try it out on the copy, that way if it does not work or something goes wrong then you have lost nothing in the long run. best regards Pete
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Design View in Relationship windowYour in the Relationship window and changes are required to be made to a Table's design. |
