Forms in Sharepoint

When working in sharepoint is there a way to open the form in design view? and how do I open the form properties? when I click form properties it never opens it.

Sponsored Links:

Related Topics

Create Access forms and reports from a SharePoint list
You can create forms and reports from a SharePoint list and use them as views. Users of the SharePoint site who have Access 2007 installed can open these forms and reports by using the View menu of the SharePoint list. You can make an Access view the default view for a list.
What do you want to do?
* Create an Access view of a SharePoint list
* Make an Access view the default view for a SharePoint list
* Use an Access view of a SharePoint list
* Modify an Access view of a SharePoint list


Hardest question ever, Access->Sharepoint
Been looking around all day and made minimal progress.

I have an Access 2007 database and a Sharepoint 2003 server/site. I have managed to export the tables to Sharepoint, but how on EARTH do I get the forms I have made to work on sharepoint. Basically, I want to be able to the user got an "advanced search" form and type in what they are looking for, and then have the results displayed, have them dbl click the resultsand it open a different form with txt boxes and such with the information pertaining to the item they double clicked.

(PS. I am aware sharepoint 2010 has WAY better access integration, and web services, but I am unable to get the to upgrade to 2010 )


Move the tables in an Access database to a SharePoint site and link to them
If you have data in a Microsoft Office Access 2007 database, you can share it as lists on a Microsoft Windows SharePoint Services 3.0 site, where team members can interact with it. They can share and manage the content by using the features of a SharePoint site while they continue to use forms, reports, and queries from Access.
In this article
* Overview
* How data is moved
* Use the Move to SharePoint Site Wizard
* Limitations of migration
* Move to SharePoint feature is unavailable when you use earlier database file formats


InfoPath Access Sharepoint
I have my database in Access 2007, my forms are in InfoPath (based on my database)and I need to post those forms to SharePoint. My problem is that the users (who will fill in the form) don't have InfoPath, the only solution is to create a browser-compliance form in InfoPath, but I can't do it with Access database.

It works only with SQL server database. Is there any easy way toconvert Access database to SQL server format (I am not a programmer)? Or may be there are some other solutions I can use to post my forms online (preferably to SharePOint) and use Accessdatabase.


Blueprint for using data in SharePoint Server
By combining Office SharePoint Server 2007, the 2007 Microsoft Office system, and the data in your enterprise, you can create a business solution that will make you feel right at home.
In this article
* Building a business solution is like building a home
* Understanding data foundations
-The three types of data
-Making connections to data
-Using data grids to work with data
-Using forms to efficiently change data
-Using reports to present data and make decisions
-Using dashboards and KPIs to act upon data
* Leveraging data within SharePoint Server
-SharePoint lists
-SharePoint libraries
-Web Parts and Web Part Pages
-The Business Data Catalog
-KPI lists
-Workflows
-SQL Server Reporting Services
-The Report center
* Using data from Office system programs with Office SharePoint Server 2007
-Excel and Excel Services
-InfoPath
-Access
-SharePoint Designer
-Other Office system programs
* Get started with templates and scenarios
-SharePoint site templates
-SharePoint workflows
-Office system templates and scenarios


Import from or link to a SharePoint list
If your department or workgroup uses Windows SharePoint Services 2.0 or later to communicate and collaborate with each other, you might encounter scenarios where you need to work with some of the SharePoint lists in Microsoft Office Access 2007 to take advantage of its rich querying and reporting features.
You can bring a list into Office Access 2007 in either of two ways — by importing, or by linking. This article describes the steps both for importing from and for linking to a SharePoint list.
What do you want to do?
* Import a SharePoint list
* Link to a SharePoint list


Control which forms and reports are available on a SharePoint site
When you publish a Microsoft Office Access 2007 database to a Microsoft Windows SharePoint Services 3.0 site, you can control which forms and reports in the database are available to users of that site.


Integration of Access, Excel and Sharepoint possible?
Possible connection between excel, access, and sharepoint?

At this moment, I have all my data stored in Excel like a 'database'. This Excel file is available in a staff Intranet, deployed on Sharepoint. My colleagues accesses the Excel file from the Intranet to update information, and saves the changes after updating to reflect the changes.

After a period of time, inconveniences and loopholes are beginning to surface as my colleagues' needs increase.

I am considering to use Access as my database instead of Excel for a more organized database. Because I am restricted to only use Sharepoint, can I actually integrate Excel, Access and Sharepoint all together? I heard that it is possible to connect Excel to Access, and then apply Sharepoint technologies with both.


Publish a database to a SharePoint site
When you publish a Microsoft Office Access 2007 database to a Microsoft Windows SharePoint Services 3.0 site, other members of your organization can work with the database.
In this article
* Overview
* Publish your database to a SharePoint site
* Republish a database to a SharePoint site


Sharepoint
How do I use Sharepoint? I am currently using MAcess 2010. I feel this would help especially when my company runs a business in another country and I would like my admin there to be able to use what I have completed


Export a table or query to a SharePoint site
If members of your department or workgroup use Windows SharePoint Services 2.0 or later to communicate and collaborate with each other, you might encounter scenarios where some of the data in your Access databases must be made available on one or more SharePoint sites.
When you need to temporarily or permanently move some of your Microsoft Office Access 2007 data to a SharePoint site, you can export it to the site from your Access database. When you export data, Access creates a copy of the selected table or query database object, and stores the copy as a list. It is important to remember that the exported list will not reflect changes made to the source table or query after the export operation.
In this article:
* Common scenarios for exporting data to a SharePoint site
* Export a table or query to a SharePoint site
* How Windows SharePoint Services data types map to Access data types


Unable to display Access 2010 Web forms
I am running the RTM versions of SharePoint 2010 and Office 2010 on a Windows 7 machine.

I am able to publish Access databases to SharePoint - the site, forms and lists get created. I am able to access the site and view the lists. However, when I try to access a web form, I get the following error: Access Services is unable to process the request.
Click here to try again.

I am able to view and edit the from in the Access client.

To simplify things, I created a web form based on a table with only 2 columns.


Break link between Access 2010 table and a linked list in SharePoint 2010
Does anyone know how to "unlink" a table after linking it to a SharePoint list in MS Access 2010? I created an Access 2010 database and then linked the tables in it to a SharePoint site using the SharePoint button under Database Tools on the menu ribbon. All that worked perfectly. However, now I need to unlink the tables without deleting them.

When I use the More Options > Delete List menu option on the right-click menu of one of the linked tables, a message appears that says "You are about to delete the list and all its data from the SharePoint Site. Do you want to continue?". That sounds like what I want it to do (remove the list from SharePoint but keep the table in Access). But when I proceed, not only does it remove the list, it also deletes the table in MS Access!

Is there no way to break the link between an Access Table and a SharePoint list once established


Break link between Access 2010 table and a linked list in SharePoint 2010
Does anyone know how to "unlink" a table after linking it to a SharePoint list in MS Access 2010? I created an Access 2010 database and then linked the tables in it to a SharePoint site using the SharePoint button under Database Tools on the menu ribbon.

All that worked perfectly. However, now I need to unlink the tables without deleting them.

When I use the More Options > Delete List menu option on the right-click menu of one of the linked tables, a message appears that says "You are about to delete the list and all its data from the SharePoint Site.

Do you want to continue?". That sounds like what I want it to do (remove the list from SharePoint but keep the table in Access). But when I proceed,not only does it remove the list, it also deletes the table in MS Access!

Is there no way to break the link between an Access Table and a SharePoint list once established?


Link to SharePoint list
I would be forever in someone's debt if they could please post code to break and then re-establish a link to a sharepoint list?
PS. The SharePoint refresh method does not do the trick:

DoCmd.SelectObject acTable, "SP_Repository", True
DoCmd.RunCommand acCmdRefreshSharePointList

I need to break the link entirely and create a new one


Can't publish Access 2010 reports to SharePoint 2007 site
I have a 2010 Access database that contains data fueled from a 2007 SharePoint list. From this data, I have created several reports that I would like to make available on the same 2007 SharePoint site in which the data came from.

I'm attempting to do this via Save & Publish>Publish to Access Services. After I enter my SharePoint site's URL and Site Name (I have also run the compatibility checker with no issue), I am asked to verify my credentials. I then receive this error message from Access:

An error occurred while initializing the Access Services database I have full administrative rights on my SharePoint site and computer. I'm not even sure if Save & Publish is the right way to go. If I were to right-click on the report itself and select Export, "SharePoint List" is grayed out.


Syncronising Access data with Sharepoint List
I have made a access database all of which tables are linked to sharepoint list.When I append any table by append query Sometimes it is reflected on sharepoint list but sometime not but allthe time on that local database.It is happening when probably there is some network problem.But my ques is if the problem is in network then how am I seeing the append query data as all mytables are linked to sharepoint list.


Date Conversion Query
I have created a linked table from Sharepoint and the date field is formatted in Sharepoint as "mm/dd/yyyy hh:mm:ss". Since it's linked in Sharepoint I cannot format the table, and I cannot edit the date format in Sharepoint.

I can't figure out how to convert the field to only read the date "mm/dd/yyyy" and leave off the date


Import Excel files on SharePoint 2010
I have Access 2010 and I would like to import Spreadsheets stored in SharePoint 2010. I have figured out how to import a SharePoint list. However, I want to import the actual spreadsheets. Is there a way to do that? Better yet can I link to the spreadsheets?


Linked list from sharepoint - formatting URL question
I have what seems to be the oposite question from a lot of others. I see most people want to turn plain text into a hyperlink but I want to turn a hyperlink into plain text.

I have a SharePoint 2007 list that I have linked to with MS Access 2007.

On my SharePoint list I have a column formatted as "Hyperlink or Picture" that is used as a hyperlink to other SharePoint sites. Now I want to create an Access report using that hyperlink field with two changes:
1) I want to be able to group on it
2) I don't want it to show as a hyperlink on my report