Search results

Thanks aqif, I figured as much. Thanks for the new idea.Ill try it later.

Hi All, on a "Run Report" button of a form,i have the following code: Dim strsql strSQL = "SELECT sum(shutdowns) FROM System1" when i debug and try to read the "strSQL" value,it always shows strSQL holding the string "SELECT sum(shutdowns) FROM System1" instead of the sum. could anyone please...

Iam trying to open a report(based on a query)from a form. i need to concatinate 3 field values on the form to get a date. when i try to run the report by clicking on the command button,am told theres a type mismatch. my command button has this under it: Dim stRelMonth As String Dim...

I posted it again because i said .."i got it" in the previous thread..and evidently i did not!!

Hi All, Please help with the underlying problem. i have 2 combo boxes. combo_box1 of them has values "january","april","july" and "october". combo_box2 has values 2001,2002,2003. after the user selects the values,i concat the values,and store it in an underlying table as...

Thanks..I got it.

Thanks... when i format the combo box, it shows up as "01-jan-01". But how can i get it to display ,for ex:"Jan" instead of the pre-determined formats?

Thanks a lot. Now since thats taken care of,i have another doubt.. when i query,how can i display "jan","apr" etc in the same combo box ?my dates are stored as "01-jan-01" . Thanks again

Hi All, Please help with the underlying problem. i have 2 combo boxes. combo_box1 of them has values "january","april","july" and "october". combo_box2 has values 2001,2002,2003. after the user selects the values,i need to concat the values,and store it in an underlying table as...

Hi All, Please help with the underlying problem. i have 2 combo boxes. combo_box1 of them has values "january","april","july" and "october". combo_box2 has values 2001,2002,2003. after the user selects the values,i need to concat the values,and store it in an underlying table as...

Thanks Eric. It finally works!!!

Exactly..thats just what i want.

Yeah..I got it to work in 2000. If you check the sql script,u'll notice the "where" clause.I dont want any clauses/criteria's there.Your example works fine,if i dont enter anything at the prompt.But If i enter the parameter, then a blank report follows or only those rows which satisfy the...

Clicking "OK" without typing any text will return all records but incase the user types anything...then nothing is returned..and our field in the header does not get populated.!!

Hi Eric, Thanks for the effort..but it was not of much help..coz i couldnt open it because of some format error!

Hi All, Am a novice in here. when i click on a report,I want a dialog box to ask for a user parameter input. I want to display this user entered parameter in my reports header. I dont want to use this parameter in my query or criteria. Any help is greatly appreciated. Thanks