Search results

Thank you very much. To be sure i understand your advice quiet well, am i wright if i put a hidden textbox on the form, call it e.g Nieuw and set the default value of it to "False" as initial value and use it as a replacement of the boolean that otherwise must be declared by a dim or public ...

In a form with subform , i have to use a Boolean that can be seen as well in the parent form as well as in the subform. I like to declare this Boolean such a way that it can only be seen by this two forms? Must it be declared as Global or as Public and where do i have to declare it? In the...

Thank you for your advice. Meanwhile i found the mistake , see code snippet beneath. In the Sub CmdCancel_click the name CmdNieuw was wrongly spelled If Me!CmdNieuw.Enabled = False Then Me!Cmd!Nieuw.Enabled = True

i have a dataentry form for managing persons from which i by products. The form has as recordset : "tblLeveranciers". I can navigate from the first record in this table to the last and vice versa, and make changes to the data , save this changes and undo changes. Even when i click the button to...

In my database program i use a lot of forms to navigate from one menugroup to another. For example the code below is fired when the form "frmLeveranciersbeheer" is closed and normaly after closing this form we get back in the form "frmSchakelbord", from where we initially should come when...

I like to thank you very much for the help and the practical advise !!!!

In my subform "sfrmorders" , i have a field "Qty" with the default value set to 0. This setting is ment to eliminate the change of a ISNULL or a ISEMPTY. Is that a good technic to obtain that goal? When entering an orderitem , this control must be assigned a value greater then 0. The possibility...

Thank you very much for the help.

It worked out fine. Thank you a lot !! By the way; The combobox i mentioned i my question is the control with tab number 0 in my subform. To make it impossible for the user to leave this control without selecting a item, I tried to put some code in the exit event of this control to check for a...

I like to thank you very much for the help. Tomorrow i examine the sample you sent me, and if i still have questions about it, i let you know. Have a good night! greetings from Brugge in Belgium.

On one of my forms i have two subforms. The second subform is a subform of the first subform. The purpose of the parentform is to display suppliers of products. A supplier can be choosen via a combobox on this form. To make the link between the parentform and the first subform i use the control...

In a table tblArticles there are the following fields: Sellprice (numeric - currency) buyprice (numeric - currency) Stock (numeric - double) Is it wise to set the default value of this fields to 0, to eliminate a null value or a empty value in these fields ?

Thank you very much for the advice

Thank you for the help I'm glad to hear that you have a kind of relation with my country. Belgian people who emigrated to the U.S are known as hard working people. So be proud of your ancestors. i'm sure they belonged to the group of hard working and friendly people. I myself have been in the...

Thank you for the help I'm glad to hear that you have a kind of relation with my country. Belgian people who emigrated to the U.S are know as hard working people. So be proud of your ancestors. i'm sure they beloged to the group of har working and friendly people. I myself have been in the...

Thank you for the help I'm glad to hear that you have a kind of relation with my country. Belgian people who emigrated to the U.S are know as hard working people. So be proud of your ancestors. i'm sure they beloged to the group of har working and friendly people. I myself have been in the...

Thank you very much for the help. Greetings from Brugge in Belgium

I like to thank you very much for the help Greetings

For archiving purposes i have a sub into which by mean of a appendquery records of a table who met a certain condition are appended to another table who serves as archivetable. After appending the records to the archivetable, the same records are deleted in the original table by mean of a...

On a form i have a subform "SfrmOrders". The visiblity of this subform is set to false in the properties window. I have on my form a button "CmdSfrmOrders" with the following Click event If CmdSfrmOrders.Caption = "Show saved orders" Then Me!SfrmOrders.Visible = True CmdSfrmOrders.Caption =...