Recent content by tabaki

I have a row of elements (in this case numbers) example: 1 - 3 - 3 - 2 I want to create an algorithm that generates each sequence: 1-3-3-2 1-3-2-3 1-2-3-3 ... Does some one has an idea? 1 remarque: 3-1-2-3 and 3-1-2-3 or the same sequences for me, even though the first "3" is replaced with...

Code permissions are enabled, I've opened my report in each possible vieuw

Perhaps it is a stupid question, but I don't seem to get the Detail_Format procedure called. I have a test database (2007) with one table called and I have created a test report that prints 2 records (in the detail section) on each page. I've adjusted the Detail on Format event a bit to see if...

I created an excel program in excel 2003; with VBA compiled in 2003; I used it, this worked perfectly I changed to 2007, conversion was perfectly; now a xlsm file is made; (I could not save in 2003 format, because I changed some format things that don't exist in 2003) I used this xlsm file in...

I have an Excel 2003 sheet that works perfectly; now when I change it a bit in Excel 2007, may Buttons become pictures. What can I do to prevent this

Thank you very much PHV, it was indeed the solution: although in the formula on the excel page the ";" characters appear I have to use "," characters in VBA... strange...

Hi skip thank you very much for your answer but I still can't create this formula what you were assuming is true, my notation is ";" in the IF-formula I assume when you want to interpretate the character " litterally you should place it twice. I have simplified my formula and it still won't...

Hi, I am a newby and therefor this rather easy question but I don't seem to solve this issue I want to create a for loop in which I want to paste for each row the folowing formula: if(row K = ""; ""; row K * row K) the code : for row = begin to end formula= "=if( & row & "K = \"\"...

I have a report that gets his information from a query filtered by a form. I filter by changing the query, by changing the parameters. I have succeed to filter by a textfield, but I can't succeed on a datafield (general type: dd/mm/yyyy hh:mm:ss). Always I get error 3075 Please help me dim...

I've done this, I even gave them exactly the same place on the report, now they are like this RPT1 XXXX RPT2 XXXX RPT3 XXXX

Hey, I have a report where I want to list 3 subreports in this way: Subrpt1 Subrpt2 Subrpt3 XXXXXXXX XXXXXXXX XXXXXXX XXXXXXXX XXXXXXXX XXXXXXX XXXXXXXX XXXXXXXX XXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX But access always...

The program i am developping is really a amelioration of an existing program. The existing file had hidden columns where some intermediair sums were made. This we thought was then the only possibility to calculate the totals. The problems came when unknowing people used this file and forgot to...

I have a worksheet where in I calculate the costprice of new projects. On each row I calculate the price for each part. Some times I need 4000 parts so I have a lot of rows. Above I calculate the totals for each column (in VBA). Each column is a diffrent type of work Now my problem: when I...

I have a pie chart on which I display all type problems that may occur in an intallation. Now I 've got to show this every month. It should be useful that problem type 1 should always appear in blue, and problem type 2 always in yellow. Now it shows the first record in blue, the second in pink...

In the mean time I have found a solution myself... not a beautiful although. I've created a new field that is a combination of all the fields on which I want to filter. This field I use as master/child field.