Search results

Ok, thanks Vila! :) Aaaaaand I think we are done here. Until next time! S

Yes, I have had to change , into ; several times when copying code from the net, but only when working in query designer or those control sources for labels and such. There's only 3 of us worldwide who use this application and we are all located in the Netherlands. So for us it isn't really a...

:D Seems like a fine mess! I'll definitely explore this a bit more and discuss it with my boss. Anyway, here's the screenshot! S

Well, you seem to know this stuff way better than I do. But I can assure you that I use semicolons; even access' 'on-the-fly' suggestions for when you start typing a formula (e.g. 'Iif(...') shows the semicolons. I can't explain it, but it's the truth. I wanted to upload a screenshot for...

@VilaRestal You are right, it's a calculated field in query designer, not VBA. You need to change something (not sure what) when you go to the region and language settings of your OS. I suppose it has to do with the list seperator, but am not sure. S

Thanks guys! Well, the whole comma / semicolon issue depends on your system settings; for me it's semicolons, that I am sure of. I'll try out the suggestion! S

Howdy guys, hope this is the right place to post this. I can't get this nested IIF to work; not sure what is wrong.... name...

Hi Guys, thanks for all your help; it got me into the right direction. There was another problem that had not so much to do with the formula: The text box's name was the same as the name of value_1. Apparently it caused some circularity problem. I simply renamed the textbox and now pr2-eugin's...

Thanks! @Mahenk Not sure what you mean there, but when I make simple select query based on the (linked) table with this: name: IIf(IsNull([MapVendor].[vendor_name_we]) Or [MapVendor].[vendor_name_we]=" ";[MapVendor].[vendor_name];[MapVendor].[vendor_name_we]) where vendor_name_we = value_2...

Damn...n00b indeed.... ;) Ok, that fixed it a little (still have to use semicolons). Unfortunately, this: =IIf(IsNull([value_2]) Or [value_2]=" ";[value_1];[value_2]) only returns value_2 if it exists and always shows #Error when value_2 does not exist and value_1 does exist. Note that both...

Thanks for the replies guys. I wish it was that simple! :) Access (2010) shows the structure of the formula as I type it and it definitely wants semicolons. I tried replacing it with commas but access then does not even recognize it as a formula at all. As far as I know, it should always be...

I have a form with a text box. I need the text box to show value_2 if value_2 exists, otherwise select value_1. Apparently, my Iif statement for the Record Source does not cut it: IIf(IsNull([value_2 ]) Or [value_2 ] = "";[value_1];[value_2 ]). The formula itself appears to be wrong... Fair...

Well hello! Dutch guy here. I found this forum whilst looking for the answer to my question. Couldn't find it, so here I am! I chose this forum since it appears to be one of the livelier ones in terms of activity. I hope to learn a lot here and in the future perhaps even help out a little...