Search results

This is really a strange forum, i think these replies are more about ego, then about the content. Thank you very much of saying to me that the code is useless. An explanation about what problems a could encounter would be welcome, that’s the purpose of my post as i pointed out in the beginning.

Sorry something went wrong

Xxx

Try :IsOpen(Form_F_Test) and see what happens, do not use Forms!F_Test

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

I really don’t know hiw to reply. I didn’t want to attack anybody. You, and others are much more experienced the I am, Yes that’s correcr. My thoughts about the analysis was wrong, yes. If you take a deep breath and look at my questions again tomorrow, you will interpret them may be different. I...

It

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