Databases
Member Avatar

When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP?

(SELECT sum(oht_net) FROM order_header_total
JOIN order_header ON oh_id …

sql
Databases
Member Avatar

When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP?

(SELECT sum(oht_net) FROM order_header_total
JOIN order_header ON oh_id …

sql
Software Development
Member Avatar

I have two forms

the first FrmRecipe.vb form has all my calulations and functions in it
the second FrmReports has a crystal report viewer with loads of reports.

I am …

Software Development
Member Avatar

I have two forms

the first FrmRecipe.vb form has all my calulations and functions in it
the second FrmReports has a crystal report viewer with loads of reports.

I am …

Software Development
Member Avatar

I am importing data from excel into datagridview its kind of working fine.
my data is like this in excel

10001       MR NEW
10002       MR OLD
10003       MR CLEAN
1MB21 …
Software Development
Member Avatar

I have a form with only 1 object on it , a progress bar.

when the form loads it runs the progress bar, which is working fine.

when the progress …

Topic by Mike Bishop

Mr M

Resolved thank you for pointing out the obvious, I have been looking at the code that long
that I hadn't spotted it. although that wasn't was resolved it. …

Software Development
Member Avatar

I have a form with only 1 object on it , a progress bar.

when the form loads it runs the progress bar, which is working fine.

when the progress …

Topic by Mike Bishop

Thanks Mr M

just a bit more info the form is a MdiChild form open within the parent
I have already tried the code you sugested however the form is …

Software Development
Member Avatar

I have a problem that my crystal report shows the decimal values as 00 every thing is fine but it does not display proper value e.g.

If i have 0.235 …

Topic by hallianonline

convert the text to a number

If NumericText ({field}) then ToNumber ({field}) else 0

you may also have to do a calulation to make it into a decimal number

Software Development
Member Avatar

Dear all,

I wanted to fill the combo box with the data from my SQL server database.
There are two column in the table, product_id and product_name.

for example:

product_id| …

Topic by buffdaemon_live

What i do in this case is use a datagrideview and make it behave like a combo box.
I set the datagridview to one coloum in width, and when you …

Software Development
Member Avatar

I have a form with only 1 object on it , a progress bar.

when the form loads it runs the progress bar, which is working fine.

when the progress …

Software Development
Member Avatar

I have the folling code which imports my CSV file into the respective columbs on my datagridview
I would like to clean the string by removing any " from the …

Databases
Member Avatar

I am trying to calculate days between two dates so that I can find out if they fall in the 30 / 60 / 90 day bracket
The calculation I …

Databases
Member Avatar

I am trying to calculate days between two dates so that I can find out if they fall in the 30 / 60 / 90 day bracket
The calculation I …

Topic by Mike Bishop

perfect thank you

Databases
Member Avatar

I am trying to calculate days between two dates so that I can find out if they fall in the 30 / 60 / 90 day bracket
The calculation I …

Topic by Mike Bishop

i have now changed to

CASE WHEN DATEDIFF(day , dbo.TblReturnDetails.RcvdDate , { fn NOW() }) > 60 THEN '3' WHEN DATEDIFF(day , dbo.TblReturnDetails.RcvdDate , { fn NOW() }) > 30 …
Databases
Member Avatar

I am trying to calculate days between two dates so that I can find out if they fall in the 30 / 60 / 90 day bracket
The calculation I …

Web Development
Member Avatar

can anyone help me with the code below, I would like to strip out comas from the URL

http://www.balmanltd.co.uk/products/steering/ball-joints/ball-joint,-drag-link-end/am1148

$str = trim($str);/*remove any unwanted outer spacing*/
$urlkey = preg_replace("/[^0-9a-zA-Z]+/","-",strtolower($str));
$htmlkey …
Topic by Mike Bishop

like so?

1.$str = trim($str);/remove any unwanted outer spacing/
2.$urlkey = preg_replace("/[^0-9a-zA-Z]+/","-",strtolower($str));
urlkey = str_replace( ",", "", $str );
3.$htmlkey = ($htmlext) ? $urlkey.".html" : "";
4.return array($urlkey,$htmlkey);

Web Development
Member Avatar

can anyone help me with the code below, I would like to strip out comas from the URL

http://www.balmanltd.co.uk/products/steering/ball-joints/ball-joint,-drag-link-end/am1148

$str = trim($str);/*remove any unwanted outer spacing*/
$urlkey = preg_replace("/[^0-9a-zA-Z]+/","-",strtolower($str));
$htmlkey …
Software Development
Member Avatar

I have a datagridview with 10 rows I can select mutiple rows by using Ctrl & Mouse click
but what I would like to do is use a button to …

Topic by Mike Bishop

cgeier thats exactly what i was looking for, thank you so much.

PS do you have any code for the mind reading scenario?

Software Development
Member Avatar

I have a datagridview with 10 rows I can select mutiple rows by using Ctrl & Mouse click
but what I would like to do is use a button to …

Software Development
Member Avatar

I need help. I just finished with the c++ tutorial on learning c++ syntax. So my question is what do I do next. I wanna learn

Topic by Traffkk

Hello world

c++
Software Development
Member Avatar

I have a datagridview with 10 rows I can select mutiple rows by using Ctrl & Mouse click
but what I would like to do is use a button to …

Topic by Mike Bishop

i will try the mind reading way, but not sure how to code it in .net..

the user will select the row using the mouse. then use the button.

what …

Software Development
Member Avatar

Hi there.

I am making an application in VB.Net. In which i am scanning some system folders and on the execution time it gives me the error;
E.g,

access to …

Topic by akkbkht

have you tried turning UAC (User Access Control) off?
Start > Search > UAC

Software Development
Member Avatar

I have a datagridview with 10 rows I can select mutiple rows by using Ctrl & Mouse click
but what I would like to do is use a button to …

Software Development
Member Avatar

I have data already populated in a datagrid
I have three textbox txtCustomername, txtPartcode, txtinvo

I want the user to be able to input text into the txtcustomername text box …

Software Development
Member Avatar

Hi all,
I just came up with a little problem.I used crystal reports for my reporting.
And i used five tables for the report.I've used SQL statement to select the …

Topic by Nebil

I assume that you they are diffrent Details sections on your report?