Thank you for your attention and your direction to me, I will trying to use of your valuable inforamtion Thank you:-D

ICE

Dear All I need your direction how to say an amount in words in visual absic.net program language, for the detail I will give an ilustration as follow: I would like my program can automatically write 1,000,000.00 to be "one million and zero cent" in words. Could any body from can help me ho to do that Thank you for your help in advance Best regards :doh:

ICE

:doh:Dear all I would like to have your best favor due to my little bit matter, I have a report which is generated under crystal report, I want to print all report directly without see the report preview first through Crystal report program. do you know any visual basic .net command that will instruct the program to print any report directly no need to see the crystal report print preview ? Thank you

ICE

Dear all I would like to have your favor to explaint me how to create a command in VB.net to tell amount in words, for example 1,200.5 will be say as one thousand two hundreds and five cent Thank you for your attention and your support to me in advance

Dear Guy's I'd like to asking your favor to give me some advise how to export or import data from Excel file to access data base through out Visual basic.net Command program. thank's a lot for your great favor to me Best regards

ICE

Hi. Soodmonu I have tried it and thank's it's running well, thank you for your help Best regards :) ICE

Hi Soodmonu many thank for your reply I have tried that operation but it doesn't working well, and Now I saw you my simple program as follows dim a as double dim b,c as string a=03.00 b=str(a) c=b,substring(4,2) when I tried to run my program an error message was come, I wanna to show two last character from "a" into my screen and it supposed to be "00" but I could not catch it, could you mind to tell me how to do that ? Thank you ICE

Hi.... I need to know how to use Substr operation inside Visual Basic.Net language program, because I could not found it,could you mind to help me please ? Thank you for your attention and your help in advance Best regards :-D ICE

Hi Mr.Kschuler Thank you very much for your reply, well I think I can consider to use your way, but if you don't mind please send me your sample program command for this matter. Thank's ICE

Hi Guys I need a favor again to somebody who had experience with printing report procedure, I have a simple program with a crystal report as the report generate,however when I want to printing out the report I have to running a program which connected to crystal report and click the printer icon on that crystal report preview to printing out my report. Could you please to tell me the way to printing out my report directly without preview it ?, if you can please tell me the command and show me the complete procedure that I have to follow. If this command not need a crystal report as the report generate please tell me what kind a program should I use for the main report generator. Many thank for you Best regards ;) ICE

Hi Guffa Thank a lot for your advise and I have tried to write and run those command into a small program but it doesn't working well. I made Three Text box ( textbox1,textbox2 and textbox3), and here is the structure of my program dim start as datetime dim finish as datetime dim minutes as integer start=textbox1.text finish =textbox2.text minutes=finish.subtract(start).totalminutes textbox3.text=minutes I tried to run this program but it wont be runing propherly it just has 0 as the result came up on the textbox3 I am affraid that I have made a mistake, but I have no idea how to write the right logic program for this case. If you don't mind please let me get your next advise Thank you Best regards :) ICE

Hi.... guys I need a favor from you who have an experience in Overtime calculation, I want to build a program which could counting overtime for each employee in my company, I need to know how to count the overtime which is over than two days as well , I mean if the overtime is start from 17:00 until 04:00 following days. Thank you fro your attetnion and your support in advance. Best regards :-D ICE

Dear all I need your favor due to my case, I wondering know how to write Select Command with two condition. here is I give you my description about my need in my form there in two textbox (textbox1 and textbox2) could you tell me how to write the Select command to involved both of that Textbox using "And" ?, so far I only know one condition for select command as the follow word" " Select * from table1 where (idno='" & textbox1.text & "')",conection) and now I need to combine select command for access textbox1 and textbox2 value. Thank you Best regards ICE

Hi Guys I would like asking to you who have some experience with Visual Studio 2005 to help me how to make setup disk. I have created a simple program it's build under Visual Basic.Net 2005 which was content in Visual Studio 2005,but when I tried to made Setup disk I culd not find some files like at the previous version, and the files at the previous version are - Crystal_Managed2003.msm - Crystal_Database_Access2003.msm - Crystal_Daabase_access2003_enu.msm - Crystal_regwiz2003.msm Actually Those above files are needed when we want to made merge module in setup disk for project which was content crystal report inside. I couldn't found those files in Visual Basic.net version 2005,does one of you know how to find those kind of files inside Visual Studio.net ver 2005 ? or maybe there is another way to made a merge files that will be binding all crystal report files in my Project ? I do hope you will help me to quit from this problem Thank you :( ICE

Hi..... Budy I have a project which was build under Visual basic.Net version 2005, this project was contained some report which were build under crystal report program for Visual studio .Net 2005 as well. I had created setup disk succesfull for my project, but when i try to install it to another computer I faced a problem that the crystal report could not running well. actually when I made a setup disk I could not found the following files : - crystal_managed2003.msm - Crystal_Database_accessXXXXX.msm - Crystal_ database_accessXXXX_enu.msm - Crystal_regwizXXXX.msm when I tried to add merge files, as I know those above files are really important when we want to make setup disk it's base on my experience when I used Visual studio.net ver 2003. And Now I need your help to tell me how to get those above Crystal report support files in Visual studio Ver.2005 ? Thank you Best regards :rolleyes: ICE

Thank you for your reply but actually I used the curly bracket in my real program, but for this line program was not problem, I just concern to program line which tell, crinv.selectionFormula="". In my previous visual studio.net version whole those program was running well, but I have no Idea why it doesn't running in version of 2005. Thank you ICE

Dear all I had installed new visual studio.net 2005 into my PC and I have tried to open my old program which was I made under visual studio.net 2003, everything was running well until I tried to run my report form which was connected to my report form made under crystal report sheet. I couldn't run selectionformula, to present all my data from my database to my report sheet as I wanted. Here is I treid to give you a small part of my program I have a textbox1 in my form which is I will use as my parameter to order crystalreport to present data as I need base on the contains of that textbox1. and the list of my program are : If textbox1.text="ALL" then crinv.SelectionFormula= "" crinv.RefreshReport() Else crinv.SelectionFormula="{inventory.invcod)='" & Me.textbox1.Text & "'" crinv.RefreshReport() Endif I can get all data from my data base if I type "ALL" into Textbox and I can get the data base on inventroy code which I typed on textbox1 as well when I still use Visual studio 2003, but now I could not get any data with the same command under visual studio 2005. My question is Could you please to give me information how to use the right SelectionFormula command in Visual studio.Net 2005, that I can present all information from my database ? I do hope you will understand what I mean with my poor english. Thank you for your attention Best regards ICE

Thank you for your reply, actually I used Visual Studio 2005 an I will use both of SQL and Acces could you mind to tell me how to use both of that kind of data base Thank you ICE

Dear all I wondering Know how created a program which is connected to the database through out ODBC system,and what the procedure that I have to fulfil in order to make it runing well as I want to. Could you please to sent me a program sample as well, thank you for your attention and your support in advance best regrds ICE

Mr.Briga Thank you for youra reply, actually I have ever tried to use Format string but I still got the decimal in rounding up state. The format string which was I used is "###.00" I have a example: I have three Textbox ( textbox1,textbox2,and textbox3) result from textbox1 divide to textbox2 will store in textbox3, on textbox1 I enter 12000 and on textbox2 I enter 10039, actually the result must be 1.19 store in textbox3, but when I run this program on textbox3 I see 1.20 not 1.19 as I need. Could you please to tell me how should Itype the right format on Textbox3 in order to get the right decimal format like I need. Thank you ICE