Search:

Ok sorry to say when I used this it didn't work. It wants to split the first variable into two different ones instead of sending 2 separate variables. I tried changing things around a bit and it just...

Hello

I have a report in CR9 that has to stay the original size. However when I view it in CR Viewer I need it to drop in size to fit the Viewer window. I can't find a switch in the settings and I...

Never mind I found the formatting on the page as was able to make it work good enough

this is the script I am using to capture the form. Is there a way to set perimeters that will cut out the menus. I'm using the " Set Picture1.Picture = CaptureClient(Form8)" to get the...

Thats the problem I need an RPT file from CR to work. and all my files in my program are DSR and all these scrips I get won't read them.

Hello

I need to convert a crystal report to a file that can be sent via e-mail. After many hours of searching and coding I came up with a way to copy the CR viewer page to a picture box and save...

Very nice, thank you very much

I need to pass 2 variables in a shell command that opens another program I have written. I have successfly passed one variable but can't seem to get two to get thru. Here is my code.

******* In...

When I change the number of copies in the print dialog during run time I still only get one copy. How do I enable multiple copies in vb code code.

As I stated all my other forms print perfect. I'm not sure what this will do to help but here it is.
CR14 on the top is the problem.

If Check5.Value = vbChecked Then CrystalReport14.PrintOutEx...

Every time I tell CR (within VB6) to print one of my forms it will print the one page form properly but then it prints 2 other forms with only the text fields showing and the data fields are blank....

Thank you Si
That was very good info. Much better then what I have receive in the past. My employer wanted to use excel because of data corruption in the past where data was lost. So instead of...

OK I found a fix, How ever I don't know why.
I went to my Excel database and opened the "Notes" field up to about 100 characters wide and 20 rows deep, then I placed a period at the beginning and...

Might be best if I attack this myself. Everyone tells me not to use Excel however I have to for this application and it's a very small database. I am also using a dao data control. Something everyone...

I have a rich text box that is only saving around 80 characters. The database I am using is Excel. I can go to Excel and type in 500 characters and the rich text box in my program will display it....

I found the problem in the drill down option. I have no idea how that got checked to "no drill down". Heck I don't even know what they mean by "drill down", but when I unselected it, the page came up.

The field "jobtot1" is a field from and excel db that I drag and drop on the form. You say create a formula that converts the field "jobtot1" field. You then place it on the report.

OK what is...

I am using CR11. I have a field that is populated by a database "jobtot1". I need it currency formatted. Every thing I have read tells me to right click the field and then go into the set up and...

I have a CR report in VB6. Only one page. The Header shows up proper but the detail section is blank. I tried to delete the fields one at a time to see if one of them was causing the problem. I ended...

Can someone look at this code and tell me why it won't release the database after it fills the flexgrid and I close excel. I have tried everything.
Dim xapp As Excel.Application
Dim xsheet As...

After taking a good long look at my situation I have come to the conclusion that a connection of just a few seconds for each user is possible. The chance that 2 users will access the same file at...

I need the connection to stay connected for the current user in that database. If they make changes while not connected and another person gets in and makes a change before they get back in , when...

I have a program that will have multiple users accessing a database on a server. I'm new to this and have a question about access.

If the database is already in use and another users tries to...

the clipboard clear worked. I had that already in the program but I put it in after Excel closed. When I moved it to the line before Excel closed the problem was gone. Thank you for your help.

Here is a screen shot. Sorry it took so long i had other issues to deal with. Now I seriously need help with this problem. How can I disable this message.

Ya DUDE, you da man. That did it. Thank you much

I know you have me going in the right direction but I seem to keep going down the wrong trail. nothing I have read tells me how to pass a variable in a shell command, only command line passing. It...

WOW great stuff guys. Thank you so much for the help.

Thank you for the replies

The first program that needs to pass the variable, will already be running. It needs to pass the path to the database to the second program, that will be shelled by the...

Thank you

That makes sense now, I know what to do

I have a combo box that I can delete and add items using a command button, however when I run the program the next time the changes are gone.

Since I have to ask here for help i will go all out...

How do I parse this path

C:\Program Files\Denali\Databases\2010\asdasdasdasd2010652\

I want it to return

\Denali\Databases\2010\asdasdasdasd2010652\]

I need everything before "\Denali"...

I need to pass a variable from one stand alone program to another. How do I set up a command line for this. i have written both of these programs so there isn't anything already built in to accept...

I have reached column "IV" not sure the number of columns but in reading I know the max column is 65536 in Excel 2003. For some reason I can't insert any more and i know I am well below that number....

I have been all over the internet to find a way to get CR to close the data connection without closing the whole program. I have seen many posts saying programmers have abandon CR because of this...

I have a problem with Crystal Reports closing the data connection after it's finished being used. I have posted this and had no response so i am trying it a new way.
Question:
How can I close a...

Never mind I found it. I set the max length on the text box to 3 and the number showed up and was used in the calculation. Thanks anyway

I have a text box linked to an excel spreadsheet. I see when viewing the spreadsheet in excel the cells with letters in them justify left and the cells with only numbers justify right. When these...

Thank you that was it

I'm sorry for asking such a simple question. I know the answer is so simple I just can't find it on the net and tired of looking for it. I'm using the commondialog in VB6 and when i hit cancel it...