Recent content by dazzer123

How can I rotate an image in Crystal Reports?

I see, thanks for your help.

I just came up with this, however how would TimeSpan work I've tried it but I couldn't seem to get it to do what I wanted. Thanks for your help Private Function ReturnSeconds(ByVal strTime As String) As Integer Dim strHours As String Dim strMinutes As String Dim...

Hi, I'm having a real problem with something a though would be fairly simple! I have a time in the format "hh:mm:ss" and I want to convert this into seconds but I just can't work out how to do it. For example I may have 01:02:04 and I need to convert this into seconds (I thinks its 3724 for...

Excellant, Thanks a lot, I didn't realise this but now you've pointed it out its fairly obvious when you think about it. Thanks again for your help

Hi I need to write a query that will show a list of retailers and a count of all of there orders. I came up with this; SELECT Retailers.NA_ID, Count(Orders.NA_ID) As countOfOrders FROM Retailers Left Outer Join Orders ON Retailers.NA_ID = Orders.NA_ID WHERE (Orders.JointOR_ID <> '' OR...

We appear to have a performance issue with one of our systems, after some analysis I belive that the bottleneck appears to be Access, it just cant read and right the volume of data fast enough, however the company we have purchased this software from insist this isn't the problem. I'm almost...

I don't know if this is the right forum or if I should post on the Crystal one. I have a crystal report that's datasource is a stored procedure on an sql server database. One of the field in the procedure is a path to a bmp. I would like my report to show the image the path points to however I...

Thanks for your help, found the control and it seems to work well

Does anyone know how (if at all) I can print out the contents of a listview

Don't know about doing this in VBS but you could certainly do it in VB .Net or VB6, simply create a program that contains a timer, on every click of the timer it counts the number of files in the folder. If this number has gone up since the last count then process your script. You could sit...

Does anyone know if there is an article like the one udo321 posted above that relates to VB .Net, I cant seem to find one but it might help with another issue i'm having. With regards to this problem, I've decided to write a web based asp .net app that can sit on our intranet and contains the...

I have a win form app that I would like my users to access through a URL and no touch deployment. However the big problem I am having is that my app needs to use some DTS .dlls and resource files. When i try to acces my app from the url I get an error that the dlls its looking for aren't...

It's ok, I got it ;-) =Replace([Fieldname], ' ', '')

Hi, I have a database of about 12,000,000 rows and on one particular field I have a need to remove all spaces from the left, right and middle of the string. I've used LTrim and RTrim to complete the first bit however i'm having trouble removing the spaces from the middle of the string, I can...