Search results for query: *

thank you very much mate - very helpful! (-:

When selecting my Default Values for a parameter I have set up, and the selecting the browsed table and field, the report is not picking up all of the distinct values from the table and field that I have entered. Does anyone know if there are any restrictions on the number of default values a...

Thank you all for your help - its been handy. I have it working now.

I dont want to hard code the date into my SQL. Any way I can keep the format of the date (dd-mmm-yy t) yet use it as a parameter in a convert command???

Hi, I'm currently trying to convert a character into a datetime but I keep getting the error "resulted in an out-of-range datetime value." The character value I have is in the format "27-feb-2003 09:00:00" I have tried different parameters in the CONVERT command but cannot...

Hi, I'm currently getting a run-time error '35760' &quot;Cannot coerce type&quot; when trying to ftp a file. My help file within visual basic appears to be non-existent and wondered if someone can explain this to me. The code preceeding the error is as follows: FromFile = <from directory...

How do I use DOS commands in VB programming i.e. syntax. For example - doing a Net Use to map a couple of drives with a VB program that runs when users logon? Thanks

Thats fantastic. To be picky tho - can we do it for just one cell? Thanks again, James

I only want one row to be made read-only if the check-box is selected

Is there anyway I can make a row on a grid read-only depending on the value of a check box?

I have assigned the field name to a variable but then when I place it on the report it just gives me the variable name. How do I get the actual value of the field? Thanks for your help James

within a formula field i have concatanated a field name within one of my tables (as the suffix will change depending on separate data). I wish to view the *value* of this field within my report. How do I go about this? Thanks, James

Yep, there is no associated data with the product so it is not appearing on the report. Tried a right outer join on the two tables but this removed most of the fields on the report so did not try a left outer join? will try this now. Thanks, James

My data is driven by unique codes for individual products. When grouping on the product I find that if there is no information for it, the product will not appear on the report or the drill down menu bar to the left??? Is there any way I can get the product to appear in the report (in the...