The reason i mostly do not use datasheets because they look like an application from the 90’s. Sort and filter can be added with a simple function.
Public Function HeaderClick(HeaderName As String)
DoCmd.GoToControl "[" & HeaderName & "]"
DoCmd.RunCommand acCmdFilterMenu
End Function
I got the same error with Access 2010. All objects (on both databases) must be closed before i can drag drop or import. One db with sharepoint connextion gives this error to.
You can show a word document in an Ole object control. There are posts about this being a bad idea, but a client of mine is working with iit for several years now, without problems. May be the control gave problems in the older Access versions?
I get this error on opening, i think it's the language setting. "mrt" is short for March in Dutch. What would be a quick fix, without using the windows language settings?
May be using month numbers?
You can insert any form you want. It can also be a continuous form, another table or Query. It's not necessary that the table or query is linked to the main datasheet table/query.
Make a datasheet form (i used the wizard for this test)
You select the controls in design view, right click select...
Hello Edgar,
Good news here. I discovered how the linked datasheet has been made! In the picture you see to table in one datasheet who are not linked to each other and this is made in a form. This is not a table view!. The trick is, that they use the tabbed layout control for the...
Thank you Edgar, your time and effort, it’s very much appreciated! The only problem with your solution is that the rowheight of the subform/subdatsheet is now (also) larger. I was looking for a way to make only the subformcontrol larger. Like with SubdatasheetHeight, but that is only usefull to...
I don't think you get the essence of this post. A table isn't a table, it's a form. Properties of a form are not activated if the form isn't opened. Like in Sql server. You Create a table and then you can have a view of the table. We can better use the name TableView instead of Table.