Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Paul77fox

    Pivot table problem

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

    Pivot table problem

    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...
  3. Paul77fox

    Pivot table view problems

    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!
  4. Paul77fox

    Temporarily denormalize a table

    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...
  5. Paul77fox

    Program to generate all possible records for a table structure

    Just perfect! Thank you PHV
  6. Paul77fox

    Program to generate all possible records for a table structure

    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...
  7. Paul77fox

    Converting 300 excel sheets into database

    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!
  8. Paul77fox

    Converting 300 excel sheets into database

    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"...
  9. Paul77fox

    Converting 300 excel sheets into database

    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...
  10. Paul77fox

    Converting 300 excel sheets into database

    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...
  11. Paul77fox

    Hi, I need to print only "true" marked records

    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!
  12. Paul77fox

    Hi, I need to print only "true" marked records

    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...
  13. Paul77fox

    Hi, I need to print only "true" marked records

    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 :)
  14. Paul77fox

    Hi, I need to print only "true" marked records

    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...

Part and Inventory Search

Back
Top