2010 web form
- Thread starter mdcory
- Start date
AccessJunkie
Senior Managing Editor
- Local time
- Today, 10:32
- Joined
- May 11, 2006
- Messages
- 278
Hi Matt,
Can you explain a bit more about your specific issue? Are you saying when you click the drop down of form names in the Web Display Form property, you can't select a different form? Or is your issue something different?
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Can you explain a bit more about your specific issue? Are you saying when you click the drop down of form names in the Web Display Form property, you can't select a different form? Or is your issue something different?
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Sorry, I didn't explain very well.
It is disabled (greyed out) and just says none in it. All of my forms and the table check out fine for web compatiblity and I have uploaded to share point with out issues.
Thanks for your help,
-Matt
It is disabled (greyed out) and just says none in it. All of my forms and the table check out fine for web compatiblity and I have uploaded to share point with out issues.
Thanks for your help,
-Matt
AccessJunkie
Senior Managing Editor
- Local time
- Today, 10:32
- Joined
- May 11, 2006
- Messages
- 278
Hi Matt,
The extra information is indeed helpful, thank you.
I believe your issue is that you have not created any web forms in your database. Access will only list web forms in that drop down list since Access Services can only display web-ready forms in the browser.
Have you created any web forms in this database yet?
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
The extra information is indeed helpful, thank you.
I believe your issue is that you have not created any web forms in your database. Access will only list web forms in that drop down list since Access Services can only display web-ready forms in the browser.
Have you created any web forms in this database yet?
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Thanks for the answer.
No I haven't. I am just learning Sharepoint. I was under the impression that it could convert a regular form to a web form. I tried finding some info on web forms but found very little. I'm not even finding how to create one.
Thanks again,
-Matt
No I haven't. I am just learning Sharepoint. I was under the impression that it could convert a regular form to a web form. I tried finding some info on web forms but found very little. I'm not even finding how to create one.
Thanks again,
-Matt
AccessJunkie
Senior Managing Editor
- Local time
- Today, 10:32
- Joined
- May 11, 2006
- Messages
- 278
Hi Matt,
No, there is no method by which you can take existing client queries, forms, macros, and reports and convert them to web objects.
I'm assuming you are indeed publishing to a SharePoint 2010 Server that has Access Services installed and provisioned. I'm also assuming you passed the web compatibility checker before publishing your web database to the server. If that is all correct above then you have now moved your existing tables to the server and they are now web tables.
Your existing database objects can now work againist these web tables from within client. A copy of each of these client objects now exists up on the server as well. However, you cannot open or use any of those client objects from within the browser because the corresponding web objects are different and have more restrictions.
To create web queries, web forms, web macros, and web reports, just click the the Create Ribbon tab. On the Queries, Forms, Reports, Macros & Code groups on this Ribbon tab, you'll see icons to create the various objects. You can differentiate web objects from client objects by looking for the globe icon on the various icons. When you create these new web objects, save the changes, and then sync your changes to the server you can then open your web forms and web report objects in a browser.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
No, there is no method by which you can take existing client queries, forms, macros, and reports and convert them to web objects.
I'm assuming you are indeed publishing to a SharePoint 2010 Server that has Access Services installed and provisioned. I'm also assuming you passed the web compatibility checker before publishing your web database to the server. If that is all correct above then you have now moved your existing tables to the server and they are now web tables.
Your existing database objects can now work againist these web tables from within client. A copy of each of these client objects now exists up on the server as well. However, you cannot open or use any of those client objects from within the browser because the corresponding web objects are different and have more restrictions.
To create web queries, web forms, web macros, and web reports, just click the the Create Ribbon tab. On the Queries, Forms, Reports, Macros & Code groups on this Ribbon tab, you'll see icons to create the various objects. You can differentiate web objects from client objects by looking for the globe icon on the various icons. When you create these new web objects, save the changes, and then sync your changes to the server you can then open your web forms and web report objects in a browser.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Again, thank you very much!
Yes, everything passed the web compatibility, and I have everything on the host. I did start to create a web form last night. The only problem I am having right now is trying to create a combo box to select what records show on the form.
Thank you and you do a great job explaining.
Yes, everything passed the web compatibility, and I have everything on the host. I did start to create a web form last night. The only problem I am having right now is trying to create a combo box to select what records show on the form.
Thank you and you do a great job explaining.
AccessJunkie
Senior Managing Editor
- Local time
- Today, 10:32
- Joined
- May 11, 2006
- Messages
- 278
Hi Matt,
Glad to help.
For your next issue about having a combo box select records on your web form, you might want to start a new thread since this issue is unrelated to your original problem with the Web Display Form property.
For your new thread, be sure to include good information on what specifically you are trying to achieve. If you are seeing any error messages, let us know what those errors are. Also, if you take some screenshots of the macro logic you are using, that would be very helpful.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Glad to help.
For your next issue about having a combo box select records on your web form, you might want to start a new thread since this issue is unrelated to your original problem with the Web Display Form property.
For your new thread, be sure to include good information on what specifically you are trying to achieve. If you are seeing any error messages, let us know what those errors are. Also, if you take some screenshots of the macro logic you are using, that would be very helpful.
--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
Similar threads
