I open a browser from my program like this:strUrl = " http://www............ ""lngScanDocPId = Shell("C:\Program\Internet Explorer\iexplore.exe " & strUrl, vbMaximizedFocus) 'I can close that window, but if the user close it this code result in an error:If lngScanDocPId <> 0 Then AppA...

Hello, I have an asp.net 1.1 application, I created some reports via Crystal Reports 9.2.2.693. Reports are compiled within the application dll.When I try to run my reports I get the yellow asp.net page showing the error "Unable to Load report".I triyed removing a report from the project and op...

i have a report with agency as group. In the group header, i have a sub report that will show an average value(total sales divided by no. of day).Can i sort this report sccording to this value using group sort expert? the problem is, i can only get the summary field for the (total of sales divided b...

Hi all,I have a list box and the items list as in the attachment http://img43.imagevenue.com/img.php?image=00276_ask_122_1181lo.JPGProblem:How should i prevent the list item called "No"(Under display column) from being removed by double clicking it?any help or suggestion is appreciated thanks....

Hi all another time, i've a view from sql server binded to my datagridview on a form, i've used an Instead Of trigger to evade the multitable update error.. but the error raises before the trigger has effect.There is some way to correct update a view on my datagridview?Thanks! :confused:...

Is there a way to write to a String Collection Editor at runtime through code in VB.NET 2003?The following is the code I am using and it doesn't work.Imports Microsoft.Office.InteropImports System.CollectionsPublic Class frmMainMenu Inherits System.Windows.Forms.Form#Region " Windows Form De...

Hi,I have a problem that i cannot figure out how to fix.I have a sub report that i need to have the group totals in the Page header and i cannot for the life of me remember how to do this.I have grouped by field 2 which gives me a time for Planned and unplanned events, I need to add up the time of t...

i want somewbody to tell me how to make a program start immediately windows startup and how to make the frm topmost

I am able to set the backcolor of selected text using EM_SETCHARFORMAT and CHARFORMAT2 with SCF_SELECTION, CFM_BACKCOLOR, including being able to set the backcolor back to transparent. However, I am NOT able to READ the backcolor of selected text if its TRANSPARENT, the returned result is 0, which i...

Hey Guys,I'm running into another problem with the Crystal Report Viewer. Here's a little info before I get started, I'm developing a Windows App using WinForms in VS2005 and Crystal 11 Release 2. I'm referencing all the latest Crystal dlls from Service Pack 2 of Crystal 11 Relea...

I am trying to find a formula to convert the GST to local time EST as well as account for daylight savings time. We had a formula that was working until this year when the dates on DST changed. (Probably redundant but changed from the 1st Sunday/April thru last Sunday/Oct to 2nd Sunday/March thru 1...

We've got a VB6 app running on our server which uses the FileSystemWatcher object...I've created a vb.net upgrade for the app, and want to run them at the same time to prove the new app detects the same changes. I'm worried that the VB6 app or the .net one will comsume that event and...

How will i know if the file has been successfully copied?Im having a bit of trouble when im trying to copy a large file because the other files is being skipped.Example:File1 = 700MBFile2 = 1MBFile3 = 2MBDim filx as FileDim foldx as FolderFor each filx in foldx.Files filx.copy(sDest)Next...

Hello Pals,I've written the program to open the number of specific MSWord files from the different folders. All files are commonly names as NEW.doc, but unfortunately one folder got no file such like that, but still I don't want to create a new file on that , instead of that I need to avoi...

I need to find the text in the MS Word..." Commencing on 23rd October 2004 "I need to find the above complete sentence to get that specific date, how can I do that ? because "Commencing on" will remain in the other documents , but the date will be vary in other documents. I need to get the date ....

1)How do I detect whether a new row is being added to a datagrid ?2)How do I detect whether an existing being added to a datagrid ?I couldnt find any events for this.I want to run a nonquery and need to know this .3)is there a way to lock the datagrid so i cant edit it at all?...

In my the report the data is being maintained in three detail sections. When i try to export data into Excel using data only excel option , the records should be displayed in only one row. But it is getting displayed in two rows. I am using crystal X1 and VB.net.Earlier when i had used only Plain VB...

I want to know if it is possible to develop software in VB6.0 to be used in touch screen kiosks? If yes, then what are the extra things one has to keep in mind as compared to writing VB applications for Windows desktops? For Windows desktops, we handle events like click, MouseDown, KeyDown, KeyPress...

Pls help me ,I am in the final stage of my project. In my application i have around 2500 .doc files in different folders.the file name i have given is like t:\528750\1.doc,528750\2.doc etc. I would like the user to Open one of the .doc file,update it & save. i tried with Document.open("filename",,f...

How to connect and view a DBF File on the datagrid?<br/> <br/>What command can be used to SELECT Data on the DBF File?

I am trying to move from VB to VB.Net and having lots of problemsHelp me plz' in main module in want to open loginform which having name 'Loginfrm' but it can't working if i set the StartUp Object to 'loginfrm' then its working but why it can't working from Module....

I would like to display all the items that checked in the checkedlistbox in listbox. When I run the code below...Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click For index As Integer = 0 To CheckedListBox1.CheckedItems.Count - 1...

I am created a ADO control on my form which retrieves records from two tables that are JOIN through the common field .I want to insert the values only in one table using AddNew Method and then using update method.I have used addnew method and receives values from the user in text boxes on the form a...

I have a VB.NET 2005 program that on a click of a button exports my report to a text file. This works fine apart from one thing, i get a strange charactor every 60 lines. So i opened Crystal Deveolper and tried exporting from there and it gave me and option set number of lines per page and setting t...

I am displaying info in a DataGridView from a spreadsheet that is then altered using buttons by the user. The spreadsheet is then saved back to the spreadsheet using another button. All this is working fine - no probs.Problem is that there is a Macro in all of the cells in 1 column that keeps a runn...

I have a formula field that makes an average of my total database.<br/>I grouped my report and got the average of each person. <br/>I now want to make a field that tells me the difference between the total average and that persons average. <br/>Any ideas? I can't seem to make it work....

Hi friends,I have got stuck with a weird problem. In my crystal report, I have set up some input parameters. I am setting values for these parameters somewhere inside code. But I don't want to show the default input parameter dialog box. Under any case, user should not see the ugly parameter...

Greetings!We service a variety of clients and wish to have them generate their own (pre-determined and created) reports via our web server (NOT connected to our main server or our database) Nightly we run a backup to this web server of our database so our current reporting program (Report Writer) ca...

I'm new to Crsytal and am trying to exclude a group of duplicated records when one set of criteria is met for one record within the group. The code that current exists within the report will exclude the record that meets the parameter conditions, but the other related records that do not meet...

Hello, I am new here and Have a question for the programmers. I have been working as a Network Engineer, Network Admin / desktop support for the pas 13 years. It is very safe to say that I feel that I am as burned out as burned out can be. I have always been interested in programming but have not to...

dear friends, i have created 2 tables one is for "Owner ship"and the other "House"the relation between 2 tables in the owner ID and the relation is one to many!!!!!!but i want to make a relation ship between then that :1 owner can own max of 2 housesand 1 house can be owned by 1 person onlybut m...

Hi all i need urgent help from all u experts here...I am displaying records in my listbox control from my person_Master...While excuting my project runs properly but after some time it gives error invalid array index property ..it is due to inserting records more than 32768...but i hve to show more...

I am using a MSBDC and have some textfields and checkboxes bound to it. When i changed the database from access to mySQL the textfields still work fine but the checkboxes dont react . If i switch it to a textfield it reads 1 or 0 as expected. So, datatypes you say, well right now its a TINYINT(1) an...

I'm sure that this must be a simple one, but I can't seem to resolve it.I have written a procedure which involves a loop. A bit of code within the loop may return an error, and so I have included an error trap.The first time that the error occurs in the loop, the error trap is triggered a...

Microsoft Excel 2003 & 2007I have written a code that I would like to be able to run on multiple worksheets within the same workbook. The code runs as it should on "Sheet1". However, when I go to "Sheet2" and try running the code, I get an error message because it is still trying to input data on "...

I am a transcriptionist, and my client requires the patient name to be in the file properties Title field of each file I create. I have some code that will copy the patient name from the report and open the correct dialog box, but I can't figure out how to get it to paste the name in the title...

I have a cross tab in a report I am working on. Along the top, it lists vehicles and along the side it lists coverages, with the amount for the coverage and vehicle being displayed.The issue comes in that after three vehicles, it cuts off the page, and the expert continues on the next page, but with...

I am using Crystal 9.0 Professional. I have a report that is a subscription renewal notice that is a 8.5 x 14 form with four perforations (so four notices per sheet). When I print the report the first record prints correctly but the subsequent records creep up a little so that when the 4th record...

Heres my problem in my program i have datagrid and adodc and in the form load events i want to filter all records that Pay_Date was less than or equal to todays date, it was working fine before when the connection of adodc was with the adodc object but when i change it to this Adodc1.ConnectionStrin...

I've got a report with six vertical fields. Are are currency type, all are same font. All are right justified. All are from the same data source. All are the same data type on the data source. For some reason, one of these fields is approximately 1/16" indented from the rest. Normally, I...

Hi all,<br/>I am trying to extract messages from outlook express on a server and file them in a folder. - contact, subject and text<br/>Does anyone know if this is possible or can direct me to a place where I can get help on this.<br/>Many thanks in advance

I have a start time and end time and am trying to calculate a total time working on the project. For most times I can get it to work. But when I have a time that starts at 11:30 pm on one day and ends at 1:00 am the following day I get a negative number. I am using a subtraction formula to calcul...

Can I connect Crystal Report document in C# .NET using Windows Integrated Security,Crystal Report Document provides SetDatabaseLogon Method with two overloads, both of them ask for UserID and Password.I do not want to supply with the userID and password because I am connecting using Windows Authenti...

hi,<br/>i have image data in a variable type Dim imgData() As Byte, how can convert into image file and set up the picture box and also convert picture into Byte() (vice versa) using VB 6.0<br/>any one help!<br/>thanks in advance.

Hi, I want to have a loop and, within that loop, read one line of text at a time. What am I doing wrong?Dim counter As Integercounter = 1For eee = 1 To weekinf(do something)(open txt file #2 for input)Line Input #2, linetext(counter)dateinf = linetext(counter)(close txt file) Print #1, datein...

1. I have two Columns in DataGridView 'Advance' & 'Deduction'. Here i want is, when i type into certain row under Deduction column the Advance Column's corresponding row value should automatically get deducted. For example, if advance value is 200 and if i manually enter 50...

1)How do i pass a parameter on cases like this whre i want the name of the table to be a parameter so the user can chose at runtime using vb.net 1.1'this failsa = "table1"cmd2.CommandText = "Select * From table=@one where deptno =" + txtdeptno.Textcmd2.Parameters.Add("@one", a)2)can I import a...

Hi, I would like to create a program that01 Searches through my emails (in my gmail account.)02 Checks for more than one email from a sender (e.g. 2 emails with the same address.)03 - Deletes any extra emails (thus creating a list of emails each with a unique address.)04 Gives me the total number...

Hi ,am getting this error."Missing parameter field current value." When i Use this line of codecrReportDocument.DataDefinition.ParameterFields.ApplyCurrentValues() it says "ApplyCurrentValues is not a member of CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition".How do i get rid of thi...

Hi,Im trying to access an MS Access 2003 database within VB6 Enterprise edition. I believe I have got all the code correct to simply edit, add and delete items within the table. However I cant seem to get the VB application to connect to the Database. Someone told me I needed to add the component &#...