Search results

If you will join your table where there is no such record to the table where the this itemid is present you will get the needed result. like this: SELECT Tablewherepresent.Itemid, Sum(nz([pricevalue])) AS Total FROM Tablewherepresent LEFT JOIN Tablewherenotpresent ON Tablewherepresent.Itemid =...

Hmm sounds like you do not want to see the subform ( client finstat ) unless you click the button. Well base you subform on the query and in the criterion for the clientid field put Forms!Yourmainformname.[Clientid], place a button on the main form to open a subform. Oh ... just in case if you...

Change the subform default view to the Continuous Forms and add this button to the header section of the subform thus the button will not appear on every subform record. Also this button does nothing but just jumps to the new record. Try it. BTW it will not clear any records it will not just...

I suspect that your subform works perfectly well :) You just need to jump to the "new record" field. Place a button on a subform with the help of the wizard, select "record operations" in Catergories, select add new record in Actions and .... you are done.

Well if you want to restrict the number of addresses in the table for the same person make fkey indexed and set to "no duplicates" that will allow only one record per person. If you just need to know that there is a number of records then dcount in the invisible unbound field and conditional...

I will be at work till the end of this week then will leave for 2 week as time off. :) Alexei

Did you reference to the libraries ? Pole1 is nothing but an unbound field with holds the value of a treeview control. I am posting the list of libraries to reference to just in case and how it looked like on my PC. If the correct referencing will not help let me know what steps are you doing...

Do you need to append a record to all other record with the same collection type or you need to update the records with the same collection type ? Is it not so that details make a unique record and updating the records with the same data violates some normalization rules ? May be there is...

Designed by Mozolevsky Sergey All you need is to reference to Comctl32.ocx and Microsoft Office Object Library 8.0

Hello what are you trying to cascade ? I loaded your example and could not find anything ...

It is hard to tell what is going on there without the db itself but I think you have a multiple events here. your code is not executed when you scroll the records but it does what you need when you change the value in a combo box, is it true? Sound like your combo box values come from the...

You can send it to aleb@tengizchevroil.com - zipped ! OR you can use WIN RAR program, specify the volume weight and split it by volumes.

As for the display of summarized data in these combos: SELECT DISTINCT q_Leads.SIC1, Count(q_Leads.SIC1) AS [Number of records] FROM q_Leads GROUP BY q_Leads.SIC1; I think you are actually asking about cascading combo boxes .... if so search this forum on "cascading combo box" ... loooots of...

Hi Well finalmeter should not be in a table. Other than that ... here we go :)

This logic will not work for every case. In Russia there is no such thing as county or state, we have regions, in Germany there are lands. In France provinces. So the logic you are trying to implement will not work. The reason is because all the subsequent tables like state, county, city, suburb...

Sorry for buttin' in .... Still don't see the need in tblabumtrack ... as far as I remember even the same song if that is a remix or remake vary on the length and the whole bunch of other details. In your case the tbltrack allows to exist some track which is not a part of any album

Hmmmm. I see that you need only two tables. Parts (tbl1) Partid Partspec Names (tbl2) Nameid PartidFK LangSel Description On the form you also need an option group which will indicate the selection of Language. Depending on the option selected the subform will display the names in whatever...

:) All what you said is possible in Access so I would use Access for this type of project.

Is this what you wanted ?

Here is the data base you can adopt for your own needs