Search results

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

Hi, I have a table of products (+/- 1000) and I want to create a new field with color numbers (eg 255 = Red) in it. These colors should be unique for every product and once I have a new product the field should automatticaly generate a new non existing color number. How can I easily fill this...

Hello, I'm quite novice in Access and I think I want to do someting huge. Probably a bad idea, but we give it a try. I have a table with on the one hand contains products which are identified by a category, a subcategory,a brand and a description. On the other hand I have a table which has...

I know that when you requery them, they will pop-up the next time you go to a record on the form. But I think it only happens when you store actually the values in a field of the main control source table. I do not store the different values of the comboboxes in the table "promotions", they are...

Fizzio Thanks that you want to help m out again, but I've created the following: 5 Comboboxes Category SubCategory (Cascading) SubCategory (Cascading) Brand (Cascading) Description (In this one only the productdescriptions are mentionned that fulfil the selection made using the other...

Hello, Hope this question doesn't file for the top 10 Most stupid Ones. I have a table product and a table promotions. This last table has the primary key (Bcode) of the table products in it. I also constructed a form in which I input the promotions for the products. To save memory I only...