Search results for query: *

Thanks! that article was great!

I have a stored procedure returning the image field from the table. How do I get the result from the stored procedure to a byte so I can convert it and display on my form?

Thanks, I knew it was there just wasn't clicking for me. I know it's in the books, but I could remember the Identity part of it so trying to find it was driving me insane. Thanks again

I know this is probably out there already, but the search feature is down. Anyway How do you create an autoincrementing field in a table. I know the answer is in front of my face, but it hasn't slapped me yet.

Thanks for the help, that worked great. My brain just wasn't functioning straight.

I feel realy stupid right now but here it goes. How can I check if a dataset's table current row is the last row? I'm trying to create a application that will allow the user to navigate a datagrid but only allow edits in text boxes. Right now, when the user clicks on the last row in the...

Does anyone know how to open a crystal report that is not part of the "project/solution" in the CrystalViewer? I've tried mulitple things and I can't find a method to call to allow me to do it. Thanks in advance.

Thanks for all your help everyone. I ended up using Crystal for this piece, but I think I'll try adjusting the image quality for some of the more intensive reports.

The printscreen/screen shot option still converts the form into a bitmap to print.

Is there a way to print a form in VB.Net without converting it to a bitmap? The code that prints as a bitmap, works, but the printed document is blurry and not very professional looking. I need to be able to print a form that will be handed in to the human resources department. Any help would...

Thanks this subtracted the date/times and gave me back the number of minutes from midnight. IE( "07/14/2004 12:15:00 PM" to "07/14/2004 12:30:00 PM" this gave me and answer of 07/14/2004 12:15:00 AM) Do you have any idea how to get to a decimal format. I tried using...

This is probably something very simple, but its just not clicking with me. I'm trying to subtract 2 dates/times from each hoping to result in the "system" tranlsation of the dates/times. IE("07/14/2004 08:00 AM" - "07/14/2004 00:00 AM" = 0.33333) Does anyone know of away to do this? When I...

Thanks kris11, I was just seraching for about 45 min to an hour for this. Works great. I gave you a star for it. Thanks!!!!

Currently, we have a third party vendor that uses Crystal Reports 8.5 to deliver its reports. We are currentlt working on a VB6 application that uses version 9. Does any one know a way to install crystal 9's components without effecting 8.5's? Unfortunately, we don't have the option of using...

This is the exact error message I get. This is coming up when VB6 gets to Report.Export False line. Run-time error '-2147190548 (800478ec)': Error in File ?? : Missing or out-of-date export DLL.

When I tried using that, it gave me an error. It said that the Dll was missing or out-of-date. What does that mean? I just installed Crystal 9 not even 2 weeks ago.

I need to be able to export a reports contents into an CSV file at the time of running the report. Does anyone know how I can do this without the built in crystal prompts coming up? Thanks, Randy Christian

Thanks everyone for you help, I finally got the view created. It appears that on the 2nd WHEN, I forgot the closing parenthesee. I also ad to change the double quotes back to single quotes. Thanks again

The PEOPLESOFT_ID is just a column in the table, it resides on a SQL Server 2000 box.

Here is what I have in the Query Analyzer: SELECT PEOPLESOFT_ID, Department, [Date], TotalRawScore, TotalRawGoal, ProductID, DEPARTMENTEx = CASE WHEN (ProductID = "1" AND DEPARTMENT = "LOST STOLEN") THEN "LOST STOLEN" WHEN (ProductID = "2" AND...