Search results

  1. MsAccessNL

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

    If I open a table and type in the immediate window: ?screen.activedatasheet.form.name, i get the Table name. The next step was to get all the properties of this table/form and if i could manipulate them. It appeared to work. So my question to the experts on this forum. Is a table view in reality...
  2. MsAccessNL

    Create Navigation Pane or ListView to be used in Runtime Version

    I got this "little" issue. I am working with Access 2010 and i wanted to test the New Webview2 control. So I downloaded the webview db from Daniel's Devhut.net and installed the Access365 runtime on my pc (seems to work next to 2010). I mist the navigation pane to open the several forms quickly...
  3. MsAccessNL

    Can I set the font size of Ribbon or Nav Pane?

    I am working on a so called QHD (2550*1440) 24 " monitor. The font of the ribbon and the nav pane are very small. Making the font larger in the Windows settings, doesn't have any (or much) effect. Is there a way to adjust the font size?
  4. MsAccessNL

    Solved Relationship must be on the same number of fields and data type Error?

    I get this error when linking PK to Fk with referential integrity , Also with a newly created test db. It looks like my Access is corrupted, or am i missing something. I noticed that that Access started numbering my databases again with nr 1 >> Database1 I am using Access2010
  5. MsAccessNL

    Solved How to make editable query of Contacts linked to table Notes and Table EmailAccounts?

    I want to make a seperate table to store al my notes "T_Note". The Table 'T_Note" is linked to every table wich should have a Note field. So for instance table: T_Company can have a note and T_Contact can have note. Next i want also a seperate table "T_MailAccount" for all the email adresses...
  6. MsAccessNL

    How does Access create a continuous form?

    I am really curious how Access assemblies a continuous form. I tried googling it , and found out that it’s quite a special feature.
  7. MsAccessNL

    Move or Remove focus from open form

    When I run these two commands: "DoCmd.RunCommand acCmdLayoutView, DoCmd.RunCommand acCmdFormView" from a cmdButton on the mainform it will work but from a subform it doesn't. When I move the focus to another openform, the docmd works. My question is to remove the focus from the main form...
  8. MsAccessNL

    Fetch change in linked Sharepoint table?

    I want to trigger code when data in a linked sharepoint table has been added. I want to establish communication between two seperate access db’s thru a sharepoint table. I could run code on a timer, but this would be every second, this could conflict with other code. A possible solution could be...
  9. MsAccessNL

    How to get sticky lines like in Relationship View?

    Is it possible to get sticky lines as show in the table relationship overview? I want to make a workflow interface where the different stations (=Subformcontrols) are draggable (this part is already working). It would be nice if the connection lines between the stations would also move along...
  10. MsAccessNL

    Solved How to work with stacked or tabbed layout?

    How do you get this empty boxes/spaces in a stacked or tabbed layout.?
  11. MsAccessNL

    Solved Autoresize a subform without using code?

    This subform in Northwind Traders auto resizes itself without any code? Also al the other controls adjust to the subform size automatically. In design view the subform control is only 1 cm high.
  12. MsAccessNL

    Function if form isloaded as form or as a subform

    I was looking for a (short) function that checkes if a form isloaded as a form and also if it's loaded as a subform. I have found some posts about this subject. The currentproject.allforms...isloaded seems not to work when the form is opened as a subform so you have to check this with another...
  13. MsAccessNL

    Solved it's Magic you can store data in a closed unbound form!

    I think it's because a form is also a class. When you declare a Form event (can be without code), the form class is initialized and the form controls can be handled, even when the form is closed, the class is activated by calling the form control.
  14. MsAccessNL

    How to prevent a Keyboard Hack?

    I am totally shocked. Is it really so easy to hack someone's keyboard entries? With just one api it's possible to see everything i type, all my private emails, passwords on sites. I tested my banksite and it records every entry, everything you type in any programm. This api can also be used with...
  15. MsAccessNL

    Sendkeys makes Numlock Toggle in RunCode Module

    I have this Runcode module that i use a lot with coding. You can run a private event in the vbe editor. It only toggle the Numlock on and off. I tried a lot (with the code from this forum). I narrowed the problem down. The CheckNumlock function works, stand alone, but in the code beneath it...
  16. MsAccessNL

    Introduction Daniel Sanders

    Hello guys, A short intro about myself. I am a freelance vba developper from Amsterdam the Netherlands. I love to solve problems and i love to learn new things. I hope to achieve both on this forum, where a lot of knowledge has been shared over the years. Thanks for letting me join. Daniel...
  17. MsAccessNL

    Introduction

    Sorry beginners error, i tried to delete this post,but didn't succeed...
Top Bottom