Showing Access Forms in SharePoint

I am having a rather annoying problem with an Access form on SharePoint.  The form form works (partially- it is still a work in progress) when loaded in MS Access, and according to the web compatibility checker, it is perfectly valid.  However, when I try to open it in SharePoint, I receive the following error (in the subform area of the main form, which should contain timesheet data for the currently-logged-in user):

The Form 'Child100' is not available.

I am a bit worried by a forum post I found from 3 years ago claiming that datasheet view is not supported for 64-bit versions of Office, but I can view lists in datasheet view without issue.  Yet I can't even open the subform on it's own (which also works fine in Access).  Does anyone know what might be causing

EDIT: As it turns out, the 64-bit issue is not the problem, as I apparently have 32-bit Office products.

July 15th, 2013 11:34am

Hi,

I understand that a sub form doesnt show up in browser. What is the data source for the sub form? Can the data source show up in browser?

You can have a test with a datasheet form alone. Check whether the form can be opened in browser. If you the sub form alone cannot be opened in browser, you need to change the data source for the datasheet.

For more information, please refer to this site:

Create a form that contains a subform: http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-HA101872705.aspx

Thanks,

Entan Ming
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2013 5:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics