Search results for query: *

Thank you dhookom, I tryed the easy way but the hard way is good too :)

Hello everyone. I'm using ms access 2010 and I have a problem with the names of the columns and rows of a pivoted table. They are 1, 2, 3....12 for month_id and 1, 2, 3.....20 for service_id, instead of jan, feb, mar... and service1, service2, service3...service20. The pivoted table is a child...

Hello guys. Can anyone tell me why in my pivot table view, the rows and columns are named 1,2,3...etc instead of their real names? Thank you!

Hello everyone! I need some help here! The main table structure is : client_id : month_id : service_id : amount : I would like to have a form with client_id like combo box, and then temporarily denormalize the rest of the table (month_id, service_id, amount) to look like a spreedsheet (month_id...

Just perfect! Thank you PHV

Hello guys. I'm new in ms access and I would like to know how to generate all the possible records for this table structure: client_ID : month_id : service_id : amount I have 30 clients, 10 months and 35 services I would like to have 30x10x35 records in my table (generated programmatically) with...

Thanks guys very much. I finally understood how it works. I think that using excel for such a long time washes your brain and cannot think that other data structures can exist. But they exist and are so beautiful and elegant. Have a nice day!

I didn't think that this could be so complicated. Maybe I don't know how to explane what I want. I know that I see this problem in a very limited way, due to the lack of experience but let's try another approach. Let's say that I will have a form with a textbox that says "Insert client's name"...

The sheets are a mess and is no need to extract anything. I will start filling the tables by scratch. I'm not used to planning databases but in my case I think it will be something like many to many realtionship. Like every client can have multiple services and every service can be done by...

Hello guys. Please help me with this and tell me the best method of creating a database of 300 clients everyone with its own table ((months (only ten of them) an services (30)). If I create a table where all the clients will have fields for months and services, will result 10x30=300 fileds for...

Works like a charm Olaf. Sorry, I did't pay attention to the comments. I think I've just learn the most important programming lesson. Reading the comments carefully :) Thank you for everything!

Olaf you make me think that everything is possible in programming if you have the right knowledge. Even a stupid reqest like mine above. And I say stupid because I just realised that I will never print all the records of my tabel. Not all at once at least :) The idea was to easily check all the...

Yes Olaf, it's true. It's just like a generic invert selection. In fact I wanted to make manual selection of records to print and use the header doubleclick to at first deselect them all and then, at the next doubleclick, select all and so on. But I think this is not so easy. For me at least :)

Hello guys. I'm very new in visual foxpro and I need help for a simple project. I have one table, one form, one grid in that form and I need to know three things: 1. How do I program the DblClick procedure of my logical field's header, to change all values in "true" and viceversa (if they...