Recent content by myuser

Thank you JHB, That was the solution.:)

Hi, I have a combobox that I want to fill its value dynamically. I write: if ........ then combobox1.rowsource="Select specialist from table1" elseif combobox1.rowsource="Select specialist from table2" endif but when I run the form, the combobox value is the SQL statement, like (Select...

Thank you so much JHB. However I dont think I had sorted result via this menu, maybe there is another way too, But really thanks for your help. Have a nice day

Thank you, but where is this panel? you mean in footer?

Hello everybody, I had made a report based on a query last year as bellow, but I don't remember how did I sort the results by "Totally"? TRANSFORM Count(ID) SELECT specialist,Count(ID) AS Totally FROM projects GROUP BY specialist PIVOT main_firm; The results are sorted by Totally...

Thank you plog , but I am sure it is possible to have nested queries. Maybe you have'nt got what I mean. and thank you JHB I have a big table about projects with many fields and many different data (more than 4 colors and more than 3 types) I just made an easy example to make it sensible and...

Hello everybody Lets suppose we have Table: products (As Attached) I wrote the following query: TRANSFORM Count(prod_ID) SELECT seller,Count(prod_ID) AS Totally FROM products GROUP BY seller PIVOT color; It gives "Query1" result (As Attached) Now, How could I get "Query2" result...

Thank you for you time and very good answering. well, I am not good at network issues, When I right click on each folder on my computer, there is not a "share" tab but there is a "security" tab which I could find the name of all domain users in it and give them permission (read/write,...)...

Yes CJ_London, no file server there is. So we should use the only computer with shared enabled for our department.

Hello I have a database which would be used by 15 users via network. Unfortunately network admin has disabled sharing system on all domain computers. There is just one pc in the network which all users of this department (15 users) could share files with it. USB drives are also disabled except...