Search results

Can you explain point 2, ...loads the form, it does not appear to open the form hidden.. What's the difference between a loaded form (but not showing) and a hidden form? As long as the form is Loaded/Hidden you can access the data and other properties, , just by one line Form_Form1.controlname...

Solution thanks to MajP, who is much more experienced then I am. If you type Form_FormName.TxtTest = "Hallo" into the immediate window, this will open (apearantly) a Hidden instance of the form. When you open the form from the nav pane, another instance (..may be not the correct word, don't kill...

Oke Thank you for the information. The hidden form is the possible answer. The strange thing is that if, I only Put: Form_F_Test_txtTest = “Hallo” into the immediate window, this statement alone opens a hidden form. So if you would make a bound form, the value Form_Public.Firstname could be...

Did you know that you can address a form control directly in this way. Instead of a long reference like Forms!FormX.SubFormContainer.Form.txtControl . You can skip all the hassle, and you get intellisense, i think it's pretty amazing..

I know you want to know the answer, I am giving a hint for the solution. I am telling you that it's possible to save and restore data from a closed Form. You can retrieve the data anywhere like with a Public variable. I am challenging you to solve this puzzle? But I understand if you don't like...

Are you sure this is correct --> "SELECT ID from tbInvoices;" you are only selecting the ID field no other fields/records. Your form will only show the ID number ?

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.

And what if the payment had been made on another date in the same month? I think you have to look for entries in the same month and year instead of the same day..

Thnx, for your reply. I am only afraid that these tools will look for a key logger programm. So if Access uses this api, it will probably not trigger the tool, otherwise all the applications which use this api (for other purposes) will get into trouble. If the tool does block the api to be used...

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

Hello,welcome to the group. I personnaly wouldn't start with a template. They often have strange behaviour. They are also very outdated. Do you have experience with vba?

Hello Majp, I react to this old feed. I don't succeed to get your code working. If I add a HelloWorld funtion it works, but it doesn't pick up the Event Procedure. I am using Access 2010 and had to adept the form load code: Private Sub Form_Load() Dim ctl As Access.Control Dim MyTasks As...

The easiest way is to put a small subform control over the drop down arrow and put in the Combobox on focus event me.Combobox dropdown..

put on focus of txtRecipient me.cmdRecipient.borderstyle = 1 and me.subform.visible = true the listbox is not a listbox but a subform with shade effect.

It's probably an update of Windows itself that causes Access to crash. Take a look at Devhut.net, there are a lot of the update bugs.

It's a litte bit better. When numlock is on it stays on (it seems), but when numlock is off it turns back on (thats oke) but the run after it turns back off. I noticed that the CheckNumLock code is ready before the Sendkeys are executed. May be there is an order of excecuting code. First the...

Tried it , same outcome...

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

For who is interested, the GetNumber function: Public Function GetNumber(sNumber As String) As String Dim s As String, sTemp As String Dim i As Integer 'x = " (212)-555-12.12) " For i = 1 To Len(sNumber) sTemp = Mid(sNumber, i, 1) If IsNumeric(sTemp) Then s = s &...