Search results

Here is the version. There are examples of treeview usage, listview usage, multiple selection in listview, examples of custom menus, toolbars. I had to strip db from some functions to fit allowed size. It is twice packed first it is packed with RAR then with ZIP. In orders forms when you...

Zip your db and send it aleb@tengizchevroil.com

Ok ... I am back at work. 1. I do not see any screenshots of your db. if you can post db here then post it please. 2. No I didn't mean populate a grid of the query. I meant to populate the table, I assume you already have some records and the field appsource is empty at the moment 3. When you...

If you can wait till 20th I will post a full blown version of the stuff you trying to accomplish. I am just out of my office till that moment.

What version of MS office do you have installed on your machine ? I tried to run the code and it did what I needed.

Try this one. I could not force to change the numbering of the pages after every project. Also I am not sure how you make your calculation... of the total billed amount I mean you have a number of fields like tax ... do you include it in the calcs? So I didn't make any assumption and just...

Post db :) Free of charge :):)

To load sample dbase for what ? Do you have a special project in mind ? You can find some samples here on this site. Some you can load from www.hiprog.com but it is all in russian so it won't be of any use. I personally use only these two sites.

Final version with report: :)

This db is adopted to your table :) Now based on the select day query you can create a report Let me know if anything you need else

Here we go ... Here is a sample dbase for you to use.

Don't be panic everything can be solved :)

LOL the voice from sky "use union query" :):):):)

:eek: The way you go further is determined by your business needs. Whether you need it to display on the form or your you want this to be on the report. Both approaches are different. Besides I suspect that you don't need so many query as u stated above.

:):) Here we go:

Sounds like you need the running sum query, you can search the threads on this but i will give also an example SELECT [your date] AS DateAlias, [your amount field] AS DailyCashflow, CCur(DSum("your amount field","your query","[your date]<=#" & Format([your date],"dd/mm/yyyy") & "#")) AS...

Task . Query without MEMO and OLE fields. Lets say we have query MyQuery with field MyField. In query you may have other fields which can use predicate DISTINCT. MyQuery can be sorted or unsorted. We need to build a query which will not change the order of the fields but will add calculated...

this is the sql for your query: SELECT tblHeadHousehold.AppSource AS Source, Count(([AppSource])) AS [How many] FROM tblHeadHousehold GROUP BY tblHeadHousehold.AppSource; Populate your field Appsource with appropriate values and then run the query. As I said above since they are connected via...

Booking date is now unbound field since it is not used anywhere but selecting of the booking date. Main form is unbound as well because I needed to have a list of courses AND at the same time a list of assigned employees. if I bind the main form to the assigned courses table it would give me...

Here is a solution: The reason why you get this kind of message is because you use an aggregate function to get the total value. Well at this stage: From the first query ( the one with aggregated function ) create a "make table query", once a new table will be create, create a second query...