Hello All,I m doing a project in VB.Net in which i ve to do sampling of records with replacement.and then i ve to show the detail record of that selected sample in grid.I can select the sample by query and make its string with all those repeated ID's.After that i use that string in DetailRecord...

Hi Guys,<br/>Im a newbie to the VB world, im trying to custom format the date time picker control so that it highlights/displays the monday of the current week.<br/>Any help would be appreciated!

Hello gurus,<br/> I am developing an application in vb.net in which I am creating a moveable rich text box at runtime inside a picture box.I want the rich text box to be transparent <br/>Pls see the attachment.<br/>I hope it will be clear now.<br/>Thank You

Hi,I use CR XI and want to report from log files which are in the form of lines such as :Field1|Field2|Field3...So I chose Text as database type from Database Expert and added log files as source. The problem is there are more than one text files and DB expert sees all of them as seperate tables, an...

I have an application that open internet explorer browserI try to close it by:(lngScanDocPId is the processID of the explorer window) If lngScanDocPId <> 0 Then AppActivate lngScanDocPId SendKeys "%{F4}", True lngScanDocPId = 0But it does not always work properly.Is there a bet...

I have created some Reports from an Excel spreadsheet which use area A1 - K8, but now have added some more rows and would like to include two additional rows to include A1 - M8 without recreating the report from scratch and selecting the area again. I am new to Crystal reports and am hoping this is...

hi,<br/> i'm using crystal report 8, i need to open the report using crystal report control and need to pass parameter " jobno" using VB. can anyone send me a sample code.

Hi all,thanks for the great input i have had so far working on this report, so far it has progressed really well, Up until the final hurdles.We have a report that picks up from a SQL database, it function is to show us the length of time it takes to run coils of wire through our system. We have a Da...

Greetings!<br/>Hi All,<br/>I need to have my report page break optionally (based on column value Y/N), Is there any thing i can do with formula available at section expert. Im using New Page Before.<br/>Thanks in advance

hello friend i am a new user of dev-archive.com i want to learn how to add crystal report in my visual basic .net . please explain me how to add crystal report in vb.net . i am very thankful whom so ever help me . your's thankfully....

I am trying to convert OLE Embedded files back to the original DocSource.We have a VB6 application that OLE embedded all types of files (doc, xls, pdf, htm, bmp, jpg, msg, txt) using the following method.OLEDoc.CreateEmbed DocSourceOpen "c:\docs\" & DocID For Binary Access Read Write As FileNumOLEDo...

Hi Friends,I am a BSc IT Student. I have to make a project, with VB6.0 as front-end and Oracle 9i as back-end. I would like to know :-a) how to connect the text box, combo box etc... to Oracle database. b) how to insert data from VB form to Oracle database.c) how to retrieve data from Oracle datab...

I have a report that I have designed in Crystal 8.5. My issue is that one of the datasources is from a secure database and fails when the user goes to print the info. My print preview within Crystal looks perfect and pulls the correct info. Is there a way that I can program the report to automati...

Hello,I am trying to use this if function in my report, but the imbedded variables are not showing the data they are linked to.ie - it says {@FX Currency} instead of EUROI tried moving the quotes around, but it did not help. Any assistance is appreciated.if {@Hedge Des} = "Cash Flow" then "To offset...

Hi I am trying to fill a datagridview with data from access using a variable. My code is:Dim DBCon1 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=S:\SanctionsDb\2007-08\MeritsDemerits.mdb") Dim ds As New DataSet Dim da1 As New OleDb.OleDbDataAdapter("Select * from...

I have some VB6 code, but i dont have the VB6 IDE/liscense. However, I do have Visual Studio 2005 (.NET). Can I use VS 2005 to compile and run the VB6 code?

I am working on a little computer game. Its form size is approx 1024 x 760. Upon the start of the game, I wish to change the screen resolution to around 1024 x 760 so that my window will be nearly the entire screen. All of my game collision code is based off of the the form's dimensions, so i h...

Hi to everyone.I'm using VB6 and Crystal Reports XI.Does anybody known how to...1) Avoid the Printing Dialog Window that pops after the .PrintReport command.2) Avoid the Printing Records window that appears after the Printing Dialog Window.The app requires that the user dont be able to choose a...

Hi to everyone.I'm using VB6 and Crystal Reports XI.Does anybody known how to...1) Avoid the Windows Printers Dialog that pops after the .PrintReport command.2) Avoid the Printing Records window that appears after the Printing Dialog Window.The app requires that the user dont be able to choose...

Hi all,I am having a difficulties with "ComboBox.ListIndex = 0" command. I used this because i want to set the current index of the ComboBox into 0. However, if I use this command, it will call ComboBox_Click function, which i do not want to call. Any idea how to set the index into 0 without calling...

Is it posible to use Hyperlink in Visual Basics 6.0

HiI have published my application on Linux Apache web server. I am using ClickOnceDeployment provided by Microsoft.But when I am trying to launch/Install this application I am facing this problem.(10/11/2007 12:54:37 PM) Downloading 'CrystalReports\CRRedist2005_x86.msi' from ' http://w...

Hi there, anyone knows how to format the crystal report with no lines in between each record when doing the exporting of report to excel format. My crystal report has a subreport and right now when I export to excel the output is something like this as shown below. No Company Type/Dept (heading)1...

I am creating a login page using VB 6.0. <br/>I want to validate the text box field, ie on pageload cursor(controll) should focus on the username field.<br/>can anybody help me to do this?

Can I send email through VB6.<br/>What are the steps that I shold take care if I have to send attachment with mail???

Hii am making an application with tapi which will catch the key pressed by user in a call, i m learning tapi and after 2 months i have succeeded in Making Call, Recieving call in Tapinow i want to catch the tones/Digits Pressed BY User in a call, If anyone have some code please share with meThanks...

I have a report that lists daily spot rates:USD/EUR 10/12/07USD/GBP 10/12/07USD/CAD 10/12/07etc.I would like to create a report that divides the USD/CAD rate by each of the rates.ex:USD/CAD / USD/EUR = EUR/CAD 10/12/07USD/CAD / USD/GBP = GBP/CAD 10/12/07The...

I am sure there is a solution already out there, but I couldn't find it. I am trying to insert a carriage return in some Crystal Syntax I am writing. I am doing the followingcstr(currentfieldvalue) + chr(13) + "FG" and instead of displaying"$300.00FG"it displays"$300.00 FG"Can someone help...

The project properties/assemby info all reference my correct project name...when I install the service via VS2005 setup project it shows up in the services screen as the project name. If I write to the event log myself the "Source" column always shows the correct project name...However when the ser...

I have a Crystal report that uses a data definition file (ADO) and I am about to convert the file and connection to ADO.NET. I am looking to convert the report with the least amount of rebuilding as possible. What recommendations does anyone have to do this conversion with the least amount of rebuil...

I am in need of a powerful serial port monitor to use with my .net application. Do you know of any free versions/that come along with source code??<br/>thanks

All of my customers are in a single data file, with one record per customer for each year that the customer bought something. (If customer A bought something in 1993, he would have a customer record in the file for that year. If he did not buy something in 2004 he would have no customer record for 2...

Hi,I have some running process MyProc.exe.Inside this process I play with MS-SQL or Oracle queries through ODBC provider. Obviously MyProc.exe sends to the connected database some DB queries like "select count(1) from SomeTab"or "insert into SomeTab values (1, 'xxxx')", etc.I'd like t...

I want to add text in Listview's Column by click on that particular Column and Row...<br/>Please tell me it is possible in listview

I want to develop a program for monitoring a process in Windows.If a process run for more than 30 minutes an alert mail should be triggered.This program will be scheduled in the Windows scheduler.Please let me know how to develop an alert program and how to schedule it in Windows Scheduler?...

hi all,the problem is Records are being added when i press the Add button. But im using RichTextBox1 because i want formatted data to be saved in the database and also i want data to Retrive data with the same Formatting when i press. First, Previous, Next And Last button.i think i did not make any...

Hello to everybody. This is my first topic here. I search in forums topics and found that also others had problems with zips etc but couldn't help me a lothere is my project which contains all the class etc from vbaccelarator http://rapidshare.com/files/62321147/vb_zips_prob.rar.htmlcan tell me...

Ok, I need to know how a Hardware Identification Key relates to a regkey.dat file. And where I can get software to break or build whatever I need to make a regkey.dat file for another computer if I have the Hardware Identification Key for that computer already.Basically, I have the key and regkey.da...

Hi everyone,I am making using Shell() function to run a command line tool from my VB Application.I am using it to archive a folder. So I am using the code :Shell("command line argument as string")where "command line argument as string" is the DOS command for the particular command line zip tool.The...

Hello all,First of all, I have a game app that was designed to display in 1280x1024 resolution. Small screenie here: http://matrixgames.com/files/games/s347_3difficulty.jpgIt has a picture inserted into the form property, and uses image boxes (NOT picture boxes) and labels mostly.I need to find a way...

Hi, Using Vb net(2005) in Windows Forms, I have found this applicaton on your site " DualListManager_Demo.zip". Since I am not in C++ I am wandering where I could find a version of this application in Vb net (2003 or 2005). Thank you in advance.

I have created one project which is working fine,but there is one big problem,i.e. when we add, modify or delete records it gets properly updated in the dataset as well as in the dtabase.I close the project and check the database it sores data properly but when i re-execute the project data in the d...

I am a cpp user.I want to invoke a report file(.rpt) from my application which is developed in cpp. can anyone help me..

Hi Everyone,I have a questions that 1) I have a pictureBox Picture1 and it contains a Bitmap picture , I would like to extract the selected color of the Picture1 to another Picture Box Picture2 , that is If I select a particular pixle by Point(X,Y) and if I get RGB value of (224,35,167) , then I wo...

Hai,I had done one project named as Resume handler. In this we are storing the entire details of candidate resume.I had added one search form in with softaware,qfn,location as search options. The shortlisted candidates are listed in Flexgrid control.My need is If I click on a candidate name in the F...

plz anyone know about displaying data in excel files using c# on command prompt thats using console application plz help me

I have a crystal report viewer object in asp.net with only the HasPrintButton set to true. I would like to catch the event that fire when clicking on the print button. Is there a way of doing this

How to create Print Button programmatically on apx page to print Crystal Report.. (using ASP.Net with c#)Before click on print button report will be dispaly to clientthen i'll click on print button to do 2 thing1) Report will go for printing2) Data will be insert into a table that "Perticular...

I'm working on creating a new system to replace the current system we are using. The means writing a program to load all the data in the old system, convert it to the new system, and initialize the new system.The program currently does this.Drop triggersDrop tablesCreate tablesLoad old dataCon...

Windows XPExcel 2003I am trying to create a macro that will take the seletion made in a combobox and add it to whatever is in a cloumn. If the column is empty then nothing happens.For Example:ComboBox Entry "Test"ID (Column A) - Before1234456776459999 empty cell 123456ID (Column A) - After1234 Test4...