Search results

  1. MsAccessNL

    Formatting column widths and captions/column headings on a datasheet view subform

    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
  2. MsAccessNL

    Solved I used to be able to copy objects from one database to another but now I get error code 3734

    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.
  3. MsAccessNL

    A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control

    I didn’t read your whole post. I had an error once, which I couldn’t solve. I found a way to trap the error. It had to do with an empty ole object.
  4. MsAccessNL

    A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control

    I didn’t read your whole post. I had an error once, which I couldn’t solve. I found a way to trap the error.
  5. MsAccessNL

    How to display a Word document in Access

    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?
  6. MsAccessNL

    Report Creation from Microsoft Excel

    I have code to transforn an excel sheet/selection ino a report. Post your file and I can see if it works on your sheet.
  7. MsAccessNL

    Attendance tracker

    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?
  8. MsAccessNL

    Hide a field in Subform (Datasheet) form based on Form Value

    Alternatively, you could make two datasheet forms. You can load it in the subform control with SubformcontrolName.SourceObject = ".."
  9. MsAccessNL

    Show a form inside a datasheet, yes it's possible!

    I got 2010, i will check it in 365 runtime.
  10. MsAccessNL

    Show a form inside a datasheet, yes it's possible!

    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...
  11. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    WOW SUBFORM IN A DATASHEET FORM NEVER SEEN BEFORE!!!! (I think...)
  12. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    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...
  13. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    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...
  14. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    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.
  15. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    I believe this is no longer true, based on the info of this post. The subdatasheet is only activated when you open the Table (we can now call it a Table form).I presume that most applications don't work with the table view. The data in a used form is not comming from the Table, but from...
  16. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    screen.ActiveDatasheet.SubdatasheetHeight = 300 Works to make the height smaller, but you can't make it bigger then the original Height. It's interesting that you can get a subform into a datasheet form, but not into the detail section of a continuous form..
  17. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    I understand, but the (linked) table datasheet is showing individual row Heights. So it’s possible. I am trying to find A way to get this done. Like the position of a textbox in a continuous form, a lot of people are saying (for many years) that you can’t determine this, but it’s just one of...
  18. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    Thanks Edgar, that’s exactly what i wanted to know, if i could trigger an event directly on the table. When the table is linked and you exppand the subdatasheet, the rowsize of that particular row is made larger. (Click on the + sign in your activities table) .Can you see/find a property with...
  19. MsAccessNL

    Solved Is the Table you see in Access a Datasheet Form? Yes.

    I adjusted the post, to make the question a clearer.
Top Bottom