Search results

LOL Thank you Both!!!! much Appreciate it!!! i will try this out and let you know what comes out of it.. thank you once again!!!!

anyone have any iea as to how to get this working? PLEASE HELP!

Hello, I am currently exporting multiple queries in excel using transferspreasheet command. This is all working fine however what i want to do now is when i am exporting to excel and formatting excel using excel automation, i want to highlight the blank cells in usedrange to highlight in...

Thank you Galaxyomathome. But it's not in access.

Hi Jdraw, ok so the hidden checkboxes run queries and with a code i basically say if the checkboxes are selected then export to excel. Does this help? Hi Bib, yeah thats what i ended up doing is making them small but the form is still too big and i dont want to put them on top of each ther as...

i just learned something new today and THANK YOU Sean... so what u did was put the is null and the charcters as the criteria... instead of the other way around... makes me feel like an idiot but THANK YOU Sean!

OMG!!! Thank you!!!! That worked like a charm.... and really this was a pain for the past 3 days so THANK YOU THANK YOU THANK YOU!!!!

thank you John!

thank you... i see both your points and its something i cant control so i guess i'll have to have the client do a check on their end...

How can one run a form with in a form? For example I have 4 visible checkboxes in one form that control 50+ hidden checkboxes in the background and exports data to excel. If vischkbox1 is clicked – it checks off hidchkbox1 through hidchkbox10 If vischkbox1 is clicked – it checks off hidchkbox2...

you state the below but your not working query has maybe thats the reason why???

I've tried this as well... but still doesnt recognize the Like *{ statement SELECT Income, IIf(Income Is Not Null,('$' & CDbl(Left([Income],9) & '.' & Right([Income],6))), (IIF(Income Like "*{", "Format Incorrect", "1")) )AS Income_Actual_Dollar_amt From TableIncome;

I've tried this but it still doesnt work... any help would be appreciated SELECT Income, IIf(Income Is Not Null,('$' & CDbl(Left([Income],9) & '.' & Right([Income],6))), (IIF(Income Is Null, "Format Incorrect", (IIF(Income Like "*{", "Format Incorrect", "1")))) )AS Income_Actual_Dollar_amt...

thanks Steve your post really helped med understand the IIF statement and how its used... i am having similar type of issue in my thread "Converting COBOL picture format number to regular decimal number using SQL" ...it seems like the Like and Not like are not being recongnized... does that...

so if the date is in text field then there is no way to distinguish if is in the correct format?

thank you Brian. i will give this a try as well. thank you both though.

so do u know how one can write an or if else statement? reason i ask is dont want to get too much in COBOL but there are positive values and negative value for signed numeric value and then for numeric values (no signs) there are no characters at the end. Signed numeric values - the sign is...

sorry thought my examples above gave away that the amount could be formatter incorrectly. Ok so it could be null or it can be in an incorrect format...so see the first line... Income income_Dollar_amt 00000905979000{ #Error 000011121940000 $11121.94 i can have the null part working if i do...

thinking more about it, i could make a table and replace the #Error to a string then export that... but is there another way to do this within the query or a better way to do it, where the #Error output is replaced by something like "Incorrectly formatted amount"?

thank you. the other option above works just fine, however when i run the query for the amount where they are spaces, it gives an output of #Error, now that is fine however I have a Code where it exports this out to Excel with a click of a button. So during the Export process, it gives a warning...