kehar

I am using Cell 2 and cell 3 of Column A Column B and Column C Column B is the Profit % and Column C is the Selling Price cell 2 of column A is my **search box** where I want to enter Selling Price. Presently, with the help of …

Hi, I have installed CR 8.5 and VB6. prepared one small prog. Now want to add CR control in VB toolbox so as to drag the same in vb form where I have to write code to print. So how to get the control please.

Hello friends, I am using A2DP enable phone and have paired it with my music system via bluetooth. But I don't see any option like "PLAY VIA BLUETOOTH " in my mobile music player. So pl help me what should I do again. Should I download any software ?

Hi, pl write me the simple example to connect student table of school database of Access through VB.net and code to AddNewRecord,DeleteRecord, UpdateRecord, SearchRecord. the fields in the table are say- Name, Desig and Age and textbox in form are- TxtName, TxtDesig, TxtAge the event under which each code has …

Hi, I have completed my project in VB 6 and Access and Crystal Report 8.5 now I would like to make setup file . So ple help me which software should I use and where I can get its free copy. I tried to make it from Package and Development …

Hi, I have completed my software but I would like to create Keygen to it so that the software should ask for Serial No., 15 days after it is installed. Pl help me (Kehar)

Hi, I am using Crystal Report 8.5 to prepare my Report and I want to convert the figures under currency to be converted automatically while printing the report. e.g If I enter 234 in my field kk than under text field hh it should be automatically written as two hundred …

Hello, My problem is that when i try to see other datails of the person names selected in the list box, i can see the details of the firstname (first item) of the list box only and not the second onwards. So pl tell me the code to write so …

Hi everybody, I have used one textbox to accept date say ([B]dt.text[/B]) in which during form load two forwardslash will appear to accept [B]DD/MM/YYYY [/B]type date. Now when I click a [COLOR="Red"]Save[/COLOR] command box and if the [B]dt.text [/B]box is [U]not[/U] filled up with date OR say it has only …

Hi, I would like to use textbox to accept date in VB 6 instead of using dtpicker. The text box should contain oblique sign like ( [B] / / [/B] ) to enter dd/MM/YYYY type date during form load. I tried to use Microsoft Mask Edit control also but it …

Add MS Mask Edit control in your form and under its Property go to mask and enter ##/##/#### then run the programme and give focus. you can enter your own date without using dtpicker.

Hi, I have completed one project but I would like that on every 1st April when I click [B]copytable command botton [/B] from VB6, a [U]copy of the table [/U]with blank records under the [U]same database [/U] should be created with [B]new name [/B]having same field name so that my …

Hi, I would like to install SQL Server 2000 Enterprise Edition in my PC having Vista OS. Pl explain me the step by step process to install SQL as both Server & Client. (K. S)

Hi everbody, I have used one ADODC control in my VB6 prog with SQL 2000 as backend. I have completed the connection of ADODC using UDL file and it's working fine But when i write the following syntax to retrieve data its not working: The code is as under: [B]Private …

Hi, Pl tell me the code to [COLOR="Red"][B]copy the existing table of Access or SQL [/B][/COLOR]and give the [B]new file name to it[/B] from VB6 at Run time without changing the field name. (k. S)

Hi, I would like to replace the ACCESS with SQL Server 2000 enterprise edition. But I have the following problems: 1. While installing SQL should I install as Server or Client. 2. How to connect the SQL with VB 6 for saving,retrieving, modifying data using ADODB connectivity. Pl help me …

Hi In vb6 I would like to display the contents of long message in more than one line. When I use the following command the entire message display in single line only thereby making the message box long The command that I am using is as under msgbox " abcd …

Hi, I would like to pass on a parameter from VB6 for the date.value from datepicker. Pl help me how to convert date.value into string as the parameter I have created in Crystal Report is string type. The parameter name in Crystal Report is chdate. I wrote the code as …

Hi friends, Pl tell me the method to use Num2Str with a simple example. I am using VB6 and Crystal report 8.5 (K.S.)

Hi friends Is there any new technology developed so that I can use my Television as Monitor. The television has RF and AV cord as Input facility. (Keshar)

Hi, with the help of VB 6 and Access I would like to make a software to enter Cheque No and its related bill no. I mean a Cheque could be the payment of number of bills of a firm which varies from time to time. So pl help me …

Hi, I have prepared one report in Crystal Report 8.5 and the front end is VB 6. But the problem when I assigned number of copies to print as 4, in the title portion of the first copy it should show as "DEPOSITORS COPY" in second copy it should show …

Hi, I have almost completed my project but I want to let the software on trial period for one month from the date of installation. After which it should cease to open MDI form unless I give password. or code to prevent the software from installation in more than one …

Hi, I have completed my project in all respect but I would like to include all table and report of Access and Crystal Report respectively in my VB 6 project SETUP FILE. So. pl help me to include such file while creating SETUP file. If there is no way than …

Hi, My database in Access contains record since 2005 and it is not required for frequent use unless the Audit ask for. So I would like to take the backup of the data through VB6 by writing code instead of going to Access and copying in CD So will any …

Hi, I have entered names of student under field NAME in Access, the names are like;- Mohan Chaturvedi, Deepa Agarwal, Mona Agarwal, Sohan Chaturvehi etc With the help of VB6 and Crystal report 8.5 I want to take the Report of those student within whose name the word Agarwal exist. …

Hi, I had deleted some files by shifting the Shift Key but later on when I recovered the file using data recovery software and saved the recovered file in a new folder under C:\ks\recovered file. But when I switch over to the above destination folder and try to open the …

Hi, I have downloaded data recovery software to recover my deleted data from Hard disk from [url]www.softperfect.com[/url] but when I try to open the recoverd file both by double click method and from file menu of the application, every time a message saying the document name or path is not …

There are large no of data recovery software at [url]www.snapshot.com[/url] but I could not open the file after recovery. You may also vist and download those software and if worked pl mail me at [email][email protected][/email]. I could restore the recoverd file in a destination folder but from there every time …

its useless to use recovery from [url]www.snapshot.com[/url]

Hi, When I enter roll no in (which is available in query) text1.text the report is generated. but when i enter another number not available in query then runtime error window appears. I know the code to search the database and show the message. (eg. if rs.eof then msgbox "not …

hi When I log out from the site even then my user name appears at the top line of the window. and when I closed the net and re open giving the address [url]www.daniweb.com[/url] even then my user name appears in the window and when I click the name it …

Hi, There is a memo field called [B]'Particulars'[/B] in my [U]exp[/U] table [U]exp1[/U] database. I have placed the field in my Crystal Report. The length of memo field by default is set to 250 characters. If I extend the field size horizontally in crystal Report my other field will go …

hi I am using IBM PC and ever since I installed second DVD RW my computer has started giving following problem. sometime when I switch on a message appears in black background giving me the option to start in either Safe mode, normal mode etc etc when I opt for …

Hi, Whenever I run SETUP file to install the programme in another computer I have to either create DSN or make the folder in the same drive with same name as is given in VB programme for connecting the database. Is there any other way so that I may install …

Hi I have placed two datepicker and one text box in the form one as [B]dt1[/B] and another as [B]dt2[/B] if I select say [U]12/12/2007 [/U]in dt1 and [U]28/12/2007 [/U]in dt2 then in [B]text1.text [/B]the number of days elapsed between the two days should be appeared. So will any one …

Hi I am using VB6 and Crystal Report 8.5 and Access for programming. When VB form prompts me to enter the month for which report is required and if I enter say [B]January[/B] then the text should appear in the heading of the Report after my text [B]" Expenditure for …

Hi I have used three combo box in VB 6 form one for selecting date one for month and one for year. If the selection is say 12/07/2007 then I need it to be converted as 12/07/2007 under one field i.e date field of access database. So how can I …

try with this rs.open "select tf.time_id from tf where tf.rac_id= val('"& fac_type & "') And tf.reserv_date= cdate('" & booking-date & ")"

Write the following code Pvt command1_click() rs.open "Select * from <table name> where < field name> >= cdate('" & datepicker1.value & "') and <= cdate('" & datepicker2.value & "'),cn, adlockstatic, alockoptimistic, endsub

email your programme at [email][email protected][/email] unless one see the programe one c annot give you the idea because how can one know where you are. Bye.

Sir, I have prepared programme using VB6 and Access2003. The programme is working very fine so far as adding,deleting,modifying the record through VB is concerned. I have installed Crystal Report 8.5 and have prepared a report and save as (bill.rpt) but I dont know how to connect the report with …

Hi I want to add one Baracuda HD and one Sony DVD RW in my computer which has already one Baracuda HD and Samsung DVD rom. How can I connect with the IDE 1 and IDE 2 and how should I arrange the jumper in all these IDEs Pl help …