Recent content by Agamemnon

Hello, I'm want to set-up an automation event from excel to access, but I don't have a clue how to start. The situation is as follows: 1) I have a Combobox (or Listbox) in excel and I want to pass the variable(s) selected into an access query. 2) Afterwards I want to return the results of the...

Every month should be a new field. I have another table where the months are fields and I need to link them.

Hi, Probably a basic question, but I can't find a solution. How can I stack columns into one column Example: Current Situation Prod Jan05 Feb05 Mar05 Prod A 1 2 3 Prod B 4 5 6 Desired Situation Prod Month Data Prod A Jan05 1...

Hi, Back from Holiday. Here are some answers to your questions and more questionmarks from myself 1) to RV: Actually I have 10 excel spreadsheets (workbooks) and I import every sheet into a seperate table. Afterwards I want to combine all the created tables into one "master table". I...

By the way KenHigg, Happy Birthday

Actually I import data for a certain category which has information on products for 52 weeks from excel into an access table. This table has as fields cat prod per1 per2 ... I do the same for 10 other categories (in total more than 150.000 lines). and they all have the columns cat prod per1...

Hi, I want to join (combine) two tables that have only identical column fields in common into one master table. There is no relation between the two tables. This master table I will use afterwards as basis for a excel pivot table. How can I do this? Suppose I do not have identical column...

Does anyone know if there is a possibility to implement "conditional formating" in het pivot tables system in Access 2002. Thx for your reply Agamemnon

Can someone help me out?

Hello Mile-O-Phile, Do you think I can use this property also on a report. As I don't know a lot of VB maybe you can help me out. My query 'Info' has the following fields: Type, Subtype and Subsubtype In my report 'Calendar' I have a textbox 'Txtname' that displays the field Type. Know I want...

I don't know if it's that property? I'll look after some info on it. Thx

Hi, Can someone tell me if you can add a comment to a text box (I mean a comment like one can add in excel and that pop's up if you stand on it with your mouse) The comment should display information that can be retrieved in existing tables. I would like to use the comment to put extra...

Hi, I'm trying to understand how the calendar report in attachment works. If you open the database Calendar there is some code for the Report_rptRotation. Now I'm wondering where the object "boxTimeLine" comes from. I've started a new project and want to use this object but I can't find it...

If you think it's to difficult, it probably is. Maybe I can simplify things by saying products belonging to a certain brand get the same color and I limit myself to lets say 30 colors as a whole. I only want to create a report which is very visual and that can be put into a Powerpoint...

OK Some more Information and some more Complexity Products have the following in Characteristics: Category, SubCategory, SubSubCategory,Brand. SO it would be best that if products are in a certain Category their colors are as far away from each other, except if they are from the same brand...