Search results

Thnx everybody, this post is solved.

Wow, your code is so much shorter then mine. This is Exactly what I was asking for in my post . Thnx.

Again, very strange conversation. Upload a databse for 3 lines of code? I think the information i have given is sufficient. Read my post again, my question is clear and the instructions are clearly given I I have also stated that you don’t have to reply. I really don’t get the irritation. May be...

Probably you mist my docmd.close command. It’s no a real long code,did you take the time to read it well and test it. The thing is that using Form_F_Test” wlll probably open the Form F_Test hidden (if there is no F_Test open already) .Noe you can check the property Form_F_Test.visible = false...

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