Hi, All Guru member,I have problem to print my data.All record in database i show at DBGrid.That say, my option, to show the record only selected item by name.and the record show in DBGrid.so, i have problem to print record (data) from DBGrid.I've already make the data environment and data rep...

Hi, I am developing a program that send sms to users to inform them the status of their process.I have download a sample code from http://msdn2.microsoft.com/en-us/library/aa446545.aspx But it is of framework 1.1.So i purposely copy the code to .net framework 2.0.When running the program, it...

I have a senario in which the main report contains two sub reports in its sections: 'detail a' & 'detail b'. When the records are fewer in first subreport then they are displayed normaly, but when records are many then they are shifted to 2nd page and the subreport starts from 2...

Hello thereI'm using VB.Net 2005 and oracle 10gI need to save an image at the field "BACKGROUND_IMAGE" on the table GS_USERS; so I wrote the code: Dim conn As New OleDbConnection Dim cmd As New OleDbCommand Dim SQL As String Dim FileSize As UInt32 Dim rawData() As By...

Hello gurus and friends, I'm encountering a problem: I need to have some controls of a form being only conditionally part of the final compilation. To clarify:To make some code part of the final program or not you will use #If Condition Then 'Special code going here #End Ifwhere Cond...

Is it possible to hide a section using a formula.I've to hide a section based on a value returned from query.

I have a field of values of which any can be null. I can deal with these pretty easily in all cases but the average function. I need to be able to take an average that ignores null values.<br/>So for example if I have 5, 7, null, 5 , 7 I want the average to be 6 not 4.8.

Hello,I try to do an authentication with a Bluetooth device using the MS API.I can find the device with BluetoothFindFirstDevice and BluetoothFindNextDevice.Then I call BluetoothAuthenticateDevicee.g. BluetoothAuthenticateDevice(0, hRadio, btdi, pin, Len(pin))This always returns 87: ERROR_INVALID_...

I want a pop-up box/form to get two values from the user. I imagine a behaviour similar to the InputBox() function, but instead of returning just one value, I want it to return two values. That is, the pop up box has two fields.I may have to create my own form. if i do that, how do i make it pop-...

Hi.I have created the FTP program and having a problem with it.I have command button that executes downloading a file (text file) from FTP site, and run Module to convert this text file to .csv file.I'm having a problem when I'm running this program.Sometime the error say "permission denie...

Hii.. i'm still new with VB.NET. I want to know how to make login form that will use database??

Hi,<br/>Anyone has a ADO Connection String for XML. I want to access a XML file as a database using SQL statements. (select)...<br/>If any one can reply with a sample, greatly appriciated...<br/>- Thankx in advnce

Hi... I'm trying to locate a copy of Crystal Reports 5.0 for purchase.Any idea where I can find a copy? I know it's really old...I'm doing some software analysis... can't get the thing to compile without it.Thanks in advance for your time,Brian...

I have a DataGridView with some data from a single spreadsheet table in it. The user changes some items in the table and then it is meant to save a new row into the spreadsheet but i keep on getting an error about needing a proper update statement to insert a row. I can't see why its happening...

I want to copy info from a textbox on a form to a specific cell in a word table on a word document, how is this done please?is it something like .cell(1,1).text = txt16.txt.cell(2,1).text = txt17.txt.cell(1,3).text = txt18.txt????but the above doesn't work!...

Dear friends, i am doing a project using adodc along with datagrid and i am using different kind of Queries but i also wanted to show how records r selected based on that query(like if the query is Select * from AUH_HOUSE where Gender= "F") so it will select all the femals in the list so i wanted...

I know you can open a file and read it line by line of course but I was trying to find out if it's possible to open a folder and then read each individual file so that you could get the date it was created or possibly just once you open the folder just read each file.

I am trying to figure this out, and don't have any code at this time. However, I've got a user-input string. I have to format the string to break it into 100 character strings. So the string could be 50 characters or 10,000 characters. But I need to take each 100 characters and put them on...

Dear friends, i have anew problame where i am using text1.text to enter a tuple in a row but it's not working and telling syntex error i tried all kind of possibleties to do that but faint at last i am using ADODC+datagrid so, i should right the code here and please if you also tell me if the...

I'm relatively new to scripting in Crystal Reports, and was hoping someone might be able to offer some advice with a problem I'm having.I have a database field that contains a large text string of comments. In this string are tilde characters, ~, and those are supposed to represent when t...

I wish to have a timer for the first time one is to 'mark' time in the windows startup routine to a finish time in windows.It's always said this time increases with more and more programs loaded.This may or not be a VB6 but could some point to something to measure these timesThanks...

Good DayI am writing to ask if microsoft visual basic 6 can be used to create a "drag and drop icon gui" and if it could also be used to create icons.The icons that would eventually be dragged and dropped on to a screen must eventually be joined by lines to form a diagram.For example can i use VB6 t...

It is easy to create a timer in Visual Basic.<br/>But I am unable to set the interval value in the<br/>propertys to more than 65000 milliseconds<br/>Is it a way to increase that value?

My SP has field s_Description contain different values like "Combat Banking" ,"Networking" and "DBA" etc.. in tabular form.My problem is ..I want to print this value on "Report header" as comma separated (e.g. Combat Banking, Networking, DBA)how can i create formula to print this comma separated str...

my problem is that i have to resize a label on my form by dragging its corner. please help me on this.<br/>like if i'm going to move the cursor on the corner of the label, the cursor will change and it will allow me to drag its size.

hi there. i would want to create a new control array of picture box and a label.but the label should be inside the pic box. the problem is that when i create a new control array both, the label won't appear inside the pic box. the example is attached here.

I know that this is a total noob question, but I am just learning Crystal. I have an existing crystal report that my company would like printed on a label using a dymo labelwriter. When I change the printer, crystal repeats the form in triplicate and when attempting to print I get an error that st...

what is max size for a string field in latest crystal report?. can it get increased?.

Does any body know how to export a report directly to Excel 8.0 file.<br/>I'm using visual basic 6.0 and Crystal Reports 8.0.<br/>Thanks

CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.<br/>Please solve this error.

Hello,<br/>Hello, How to call Crystal Report from Web?<br/>the problem that i get is at the web, it asks about username and password? how to solve it. can u send me some code for it?

Hi all, Need to find help about DLL. I have used VB 6 for some simple application, but only the .EXE one, not DLL. However, the company that i worked for now, using DLL for the development. Anybody know how to get good info about this ? or maybe can try to explain to me what is the difference betwee...

hi. how can i determine the path of the my documents folder? if i will make a txtfile on the folder of mydocuments, how can i know the right path?

hi,i have created one project its working fine on my machine but when it is installed on some other machine it gives the error Loading report failed because i am loading my reports dynamically through code and i have specified the address of local machine(i.e. d drive).Tell me how te get the path of...

Hello ,I am facing a problem and I don't Know the solution.I'm using VB .Net 2005 . All I'm trying to do is to read a binary file which contains data with the format XX/XX/XXXX XX:XX , replace this value with something else and then save again the binary file.I have written the follow...

I have two datagridviews, one represents existing data which is read only, the other shows another table, with the same structure, but allows the user to change the values. Starting out, the grids will be exactly the same, and the first grid only acts as a reference to what the data was like before...

Hello, Can anyone help me with the following please?I want to print images from a recordset using an Access Database on the datareport. I can load and display the images on the form and also navigate through the records by using the path of the location of the images. But what I can't do is pri...

Question about process in VB.NETDear Friends,I have some VB.NET code that runs some external process:Dim p As New Processp.StartInfo.UseShellExecute = Falsep.StartInfo.Arguments = ...p.StartInfo.FileName = ...p.StartInfo.WindowStyle = ProcessWindowStyle.Hiddenp.StartInfo.CreateNoWindow = Truep.Start...

ListViewHow to insert row before top row, i.e. in reverse order?I have some ListView:1111111 11 111112222222 22 222223333333 33 33333Dim objlistitem As ListViewItemobjlistitem = ListView1.Items.Add("1111111")objlistitem.SubItems.Add("11")objlistitem.SubItems.Add("11111")objlistitem = ListView1.Items...

I am writing a simple formula as below and its giving me error: 'statement is required' where header field is defiend in formulaif {Header.TASK_CD} = "Inspection" thenheader = "INSP + WORK " & "report" elseif{Header.TASK_CD} = "Replacement" thenheader = "REPL " & " report...

on the attached zip file, label1 is draggable on the form. but the problem is that there are some instances that the dragged control won't be placed on the accurate position. for example if i'm gonna drag it one centimeter away then i won't drag. why is that? is there a solution for t...

Hi AllI am looking for a way to make a program that will scan a users computer and display all installed software.. If possible I would like to basically connect remotly to this computer by typing in a computer name in my program, it then connects to the PC scans the system and brings back a list of...

How to check table in database exists or not in vb6?<br/>I have use "select * from table" query but it gave me error that table does not exists.<br/>(Actually I am creating tempory table and deleting it after form unloads)

I want to display picture of customers in crystal reports. For that purpose I have created table customer.When new custiomer comes to me I take their picture using PC camera and save that picture in one of the folders.At the same time I am sending path of that picture to database.Now when I display...

I have a VB6 Application.My Application sends commands to instrument after every 10 seconds.and communication through the serial port This is workin fine since last 4 years.suddenly,I am facing a problem.Randomly,the <STX>,<ETX> and checksum is missing in one of the command.Hence leads t...

Hi I have created an activex exe in vb6 that uses the shells function to execute an exe that converts a tiff file to a pdf. This works perfectly fine if I use the activex exe functionality in a test vb application.The problem that I am having is that the activex exe emits an error sound (no error me...

I want to display picture of customers in crystal reports. For that purpose I have created table customer.When new custiomer comes to me I take their picture using PC camera and save that picture in one of the folders.At the same time I am sending path of that picture to database.Now when I display...

HiI'm a relative newbie to VB and doing some vb programming in excel 2003 (vb6.3). I've created a form with numerous textboxes and written code to copy the contents into an Excel worksheet with a command_click event:Private Sub cmdTfrData2Excel_Click()Dim iRow As Long Dim ws As Workshee...

I am using Crystal Reports XI. I have two spreadsheets I have to link and pull data from. The spreadsheet field names are:Spreadsheet1 Computer Model Serial NumberSpreadsheet2LineOfBusinessAsset Tag The linked fields are Serial Number and Asset Tag. I have the report groupe...

I am trying to find out the last record in a table called Asgnmnt using HeatSeq. Trying the below code producess an error stating "A boolean is required here."code:{@Date Convert} = {?Data Select} and{CallLog.CallStatus} in ["Closed", "Solved", "Suspended", "Implemented"] andmaximum({Asgnmnt.HEATSeq...