Search results

well that took about 5 seconds=)... it had to be like this: =[Forms]![Myform]![MyCombo] Thanks anyway=)

Hi James! Thank you so much for your help! I only got one last step now... it works, just as you said when I put an email directly in "To:". But I want it to check up the email-adress in a combobox on a form... I tried with [Forms]![Myform]![MyCombo] but that didn't work. I will continue...

Hi John! Thanks for the help, I'm new with access so I don't know that much... especially not when it comes to codes... I've been trying to put something together but it just doesn't work... I want it to work exactly the way your sample does! (By the way, the reason to why I couldn't see the...

Hi John! I've taken a look at the sample but I can't see how you've done it. It's only letting me use the form ... but I can't look at any codes or so...? It says that it's "read only" when I open it?

Hi! I got a question about emailing.... I don't think this is possible but I thought why not ask.... Is it possible to have a button on a form, that when it's pushed, it sends an email with a report included to a certain email adress? thanks! -jake

Ok! What I hadn't done was to look up the value for the text box. I did a DLookUp("[MyFiled]";"MyQuery") in the control source and then I did the conditional formatting! Works just as I want it to! Thanks Hartman! -jake

Sorry, but I dont understand how to do?! How will it know the value in the query by doing this? thanks -jake

Hi! I'm have a query with some fields but only one record. The values in the record depends on comboboxes in a form. What the query is doing, is that is calculating percentage. So the problem is if you go from zero to something bigger than zero, then this this gives you an infinite value of...

Thanks Dave! I hade totaly forgotten about it! This is better then having all those buttons... -jake

Is it possible to in a form have some buttons and depending on which button you push a different subform will be displayed? For the moment I have buttons that opens entire forms that are almost the same but with different subforms. But it feels wrong to do it this way? -jake

That was it!=) Thanks for all help!

Still doesn't work. When I wirte it it says: The expression you entered contains invalid syntax. You may have entered an operand without an operator. What is wrong? -jake

I'm trying to use the =IIf(Field=0,Null,0) but it doesn't seem to work. I putting the statement as a new field in the query, maybe that's not the way to do it? -jake

Zero --> Null OR "#Error" to Zero! Is there somekind of reverse Nz() function? I want Zeros to become null in my query! ..or I almost rather change "#Error" to 0(Zero) if that is possible? Thanks -jake

Is it possible to have the series names on a chart depending on the value in a combobox?? Thanks -Jake

Feels good to know I'm not the only one who thinks so=) Still, if anyone knows.. this is killing me... Thanks in advance -Jake

I have tried... but I just don't seem to find a way to do it... I'm going crazy over this... :(

Hi everyone! This must be a basic thing to know, must be something wrong with me... I have a table with eight fields. I want to do a chart where I the piles are "tighten" togther two and two. I would like the chart to look something like this (Example): |_______________________________ |___ _...

Thanks for all help! It's working just as I wanted! -Jake

Hi guys! I don't really understand where I should put the IIF statemant or the Nz() function. The null values are "created" in this particular query. Can they be converted here or should I do a new query? Thanks Jake