Problem #1. In Reports if you add a parameter and select multi-value when I run the report and Select All from the drop down list or if I select more than one value I get "incorrect syntax near ','. I haven't been able to find anything on this error. I am running Sql Server 2005 SP2.
Problem #2. In Microsoft Access I can add a Combobox that will return a list of values from a table and will let me assign a sort order.
When the form is loaded there is no value for combobox. The user can leave this value blank. What I like to do is write code that says if the combobox is null then select all.
When I try to do this in VB.net the form loads the combobox with values already in the combobox.
How can I either fix problem #1 or #2 or both? Thanks for your help.
Happy holidays.
Problem #2. In Microsoft Access I can add a Combobox that will return a list of values from a table and will let me assign a sort order.
When the form is loaded there is no value for combobox. The user can leave this value blank. What I like to do is write code that says if the combobox is null then select all.
When I try to do this in VB.net the form loads the combobox with values already in the combobox.
How can I either fix problem #1 or #2 or both? Thanks for your help.
Happy holidays.