Search results

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...

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...

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...

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