Search results

Ok, I did it guys... When the mind is not clear easy things seems difficult. Thanks a lot for helping!

Still I would need to count the number of rows...

Thanks pbably, You mean to use the Dcount in the union query? If yes what's the syntax?

Hi, I use a union query as follows SELECT ALL [A], [B] FROM [Εμβόλια παιδιών] WHERE [B]>"0" UNION ALL SELECT [C], [D] FROM [Εμβόλια παιδιών] WHERE [D]>"0" UNION ALL SELECT [E], [F] FROM [Εμβόλια παιδιών] WHERE [F]>"0"; When the query runs I need to have the numbers of resulted rows (if...

DCrake, Eventually i managed to short it out Here is the code i used to disable 3 command buttons in all tabbed pages apart from the first. Private Sub tabContacts_Change() Form!cmdNewContact.Enabled = IIf(Form!tabContacts = 0, True, False) Form!DeleteRegistration.Enabled =...

DCrake many thanks for replying! Actually this condition part I am looking for... How can the IIF function give True or False as result when I am opening only page2? Isn't there any function that looks like IfActive(page2) then gives True or False?

Hi, This forum has been a great help so far! I have a tabbed form with 5 pages. What's the code to use so that when i am viewing ONLY a certain page (for example page 2) to disable a button command on the form? I guess in the On_curent event of the form I have to use a code that looks like...

Thanks again Wayne, I did use the code in OnClick event, the list box still allows (highlights) more than 5 items to be selected. Also, you suggest not to put the selected names in the table. why? I use these names to plot a chart.

Thanks Wayne, it works! Indeed, any selection after the fifth is not registered in table _temp, however, it is still highlighted in the list box and this can confuse. How can I modify the multi select list box so that it does not to allow more than 5 selections (let’s say out of 20) at the same...

Hi, I use the following code to implement a multi select list box. I tried to modified it (by using a loop) so that the user cannot select more than 5 items in the list box and probably to take a message the limit of selections is reached. Any help? Private Sub List15_AfterUpdate()...

Hi, In one of my forms I use a column chart with its data table to depict statistical results. However, when I reduce the height of the plot area the height of the data table reduces analogous and vice versa. Is there a way to chnage ONLY the height of the plot area, or ONLY of the data table...

A bit confuse hear, I cannot really understand what you mean with the above IFs... Let me rephrase the whole concept. When the db starts a MAIN form opens, in the Open Event of this form I use a macro to open the second small form. However, I would like to be able to control this automatic...

this is not a smart way, would confuse things

Wazz, using this code the second form will never open again once the check box is unchecked (set to false).

Dear Wazz, Thank you for replying. I am already using this option to open at startup another form, you can call it the MAIN form. Now I am looking for code to put it in the open-event of the MAIN form to control the opening of the SMALL form based on its check box, when the check box of the...

....any help?

i am so soryy, it's a misstype. I meant db! I changed it!

Hi, I have a small pop up form that is bound to a select query. I need to add a check box on the form so that when it is checked the form will pop up every time the db opens.

Hi David, I managed to convert the file to vesrion 2002-2003. Looking forward to your comments.

Hi David, Thanks for the quick reply The version 2007 does not allow me to save the file to an earlier version format because it uses features that requires the current file format. sorry! This file is part of a real application that is not in English.