Recent content by Sven

hm it has to be something with my version of office i guess.. You told me before that you got the desired results from my database, with just dropping the quotes. With the exact same file, I tried dropping them.. but got that error again. My version is office xp 2002 sp3 though.

ok, thats VERY strange. the reason I added the quotes, is because of the error I get otherwise? I also had =IIF(bitrate>2,'do this','do that') as formula, but access would give me a prompt errorbox, saying 'you may have entered an operand without an operator' Thats why I added the quotes...

Hm, I just can't find it. I tried it now with 'bitrate', is an integer but doesn't work either. Also tried with other text boxes standing in the form, no luck.. I have uploaded the db: http://users.telenet.be/naait/problem.mdb Hope it's just something stupid.. :)

SELECT titel, duur, grootte, type, locatie, [resolutie-breedte], [resolutie-hoogte], bitrate, filmlijst.status, status.status FROM filmlijst INNER JOIN status ON filmlijst.status=status.id WHERE filmlijst.status<>'2' ORDER BY filmlijst.titel; this is the recordsource I have...

yeah it's not really about the sources i guess, is it possible that access doesnt recognise the 'iif'? It's an english version, so normally there wouldn't be a problem. But in the access-help pages, I can't find anything on it either.

sadly enough it wasn't a column name, so I still have the problem. grtz

no it just stays the same, I really don't understand it :confused:

Hi, I want to use an IIf in a textbox in my report. I have the following code in the control source: =IIf([filmlijst.status]>2,"d","e") the error given is: invalid syntax, you may have entered an operand without an operator As I searched on this item, I don't really see the problem...

thats also the way I did it ;) At first, I didn't find the menu for conditional formatting & thought I had to include this in the report's sql. NOT ;) Any ideas for the exception handling?

ok thx, worked out well with conditional formatting :) sorry for late reply though, didn't had the time to work on it. other little question: I have some fields in my report which contains error-values (beginning with '#'). I want to leave these fields empty, if there isn't a valid result. How...

Hi I want to color my text based on a criteria. If the status (a field in table) is for example '1', then it should be in normal black color. If it's '2', it should be in green. '3' should be in red. As I'm not familiar with the reporting stuff, I don't seem to get it to work. thanks in...