Search results for query: *

Hi Chrissie1 thanks for sharing your idea. I be checking it first if this would work on my project then I will let you know. JBats JBats Good is not better if not than best...

Hello Guys, I just want to ask if how could I remove the flickering of my screen (GUI) during runtime. I have inserted lots of images in my application to look good but my problem is when I change screen, the screen that should be displayed will flicker before it will display the whole screen...

Hello Guys, Just want to ask if how could I detect or check the current Operating System of my Application build in VB? Thanks JBats Good is not better if not than best...

Is anybody could help me where can I find a code posted in this forum that can be used or reference to open a harddrive from the other working station even that station did not have a drive sharing. Or any software that can be used for this particular cases. Any help would be highly...

I used the Crystal Report 11 in my VB Project and I was just wondering because when I tried printing my report directly to printer using the method PRINTOUT, It doesn't work. I am using the following objects. 1. Crystal Reports ActiveX Designer Run Time Library 11.0 2. Crystal ActiveX Report...

I was creating a formula which will return a list of enumerated expression. How could I insert a carriage return in the formula. e.g. '1. Item 1' + '2. Item 2' + '3. Item 2' When this expression be displayed, each item will appear on each line. JBats Good is not better if not than best...

This is the exact example I am looking for. Thanks a lot for sharing your knowledge it helps me a lot. SELECT * FROM (SELECT ItemCode, ItemDescription, (SELECT SUM(SoldAmount) FROM T_Sales WHERE ItemCode = t_Product.ItemCode and CatCode = '1') AS TotalSale FROM t_Product) WHERE TotalSale > 0...

I will create a procedure in my VB6 project that will import (copy) a text file from our website and store it in my local machine. The data in this text file will now be transferred to my Sybase SQL Database. How can I do this? Is there an existing discussions in this forum that can be a used...

Thanks for your rely, both of your example are correct but I'm looking for a way on how I can make the variable inside the query be included in the WHERE CLAUSE condition. I will show you another example inorder for you to understand more on my question. SELECT ItemCode, ItemDescription...

Hellow People, I just want to ask if this statement is possible or there is a way to do same with this one because I tried this in Sybase SQL and it works. SELECT TransCode, Description, Status = Case When Status_ID = '01' Then 'Active' else 'Inactive' end From t_Trans WHERE Status = 'Active'...

I created a collection of controls in my form. Now, read through each control of the form to get the control name and its index number. Not all the controls in my form was defined as control array. Now my problem is how can I determine if the control that was being read through my For...Next...

Thanks Madawc for your ideas, I will try this and let you know. JBats Good is not better if not than best...

I was doing a report in Crystal 11 with a calendar format that will list down all the VCD films that customers rented for the particular day of the week/month. I grouped my report according to customers name and below is the detailed list (in calendar format) of VCD films that the customer...

Thanks for the infor you've shared but my problem when I use this API function is that when I tried to close my application while the help window still open, the application get's freeze. I don't know why and another thing is that the help window is always on top. Thanks Jbats JBats Good is...

Hi Jim We have same problem actually, I also encountered this error <<file is not a Windows Help file, or the file is corrupted.>> Have you ever got a solution on this? could you share it to me I would be so much glad. Thanks, JBats JBats Good is not better if not than best...

Hello guys, I would like to ask if is there a way I can open my help file (build in CHM format) in my VB application without using commondialog control. My problem rightnow is that when I tried launching the help file using this control, it doesn't work and it says the file is invalid or...

Thank you guys for sharing your ideas. I tried what Madawc suggested by putting the statement inside the recordselectionformula of the rpt file and it works ok but my problem is when i'm going to change the value of agencycode and batchnumber. Yes your right MisterMo that this number are...

Hi Guys, I'm having a problem executing my program in VB6 using Crystal Report 11. I tried executing this code below in my program and an error occurred "Basic Syntax is not supported in group or record selection formula". Set CrystalReport = crApp.OpenReport("c:\Program\ra.rpt")...

Hi Guys, I am converting a crystal report (rpt file) created from version 8.5 to version 11 and it works fine. I also changed the reference object in my VB project of CRAXDRT 8.5 to CRAXDRT 11 and also the viewer object. My problem now is that when I print the report an error exist "This Field...

Hello Guys, I had an existing DLL project from VB6 and tried to upgrade/convert it into VB.Net. I had the conversion process completed and build the project into dll file. When I tried to reference the dll file compiled in VB.Net, it seems that there is a problem. I can't reference the compiled...