Search results for query: *

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...

Thanks for you help, I had never investigated the timespan class before, thats a far simpler way of doing it.

Ok I got it but I cant seem to work out the milliseconds bit, any ideas? Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Dim Holiday As New System.DateTime(2004, 10, 7) Dim dtNow As System.DateTime Dim Days...

I'm looking to write a program that displays a digital countdown in hous:minutes:seconds and possibly milliseconds to a particular date and time either set in the code or by the user. I started this with the idea that it must be fairly simple but so far i'm stumped, I have no idea how to go...

Bit of a late post on this but I have only just had the chance to look at it. The problem was I wasn't setting the WS_CHILD Style bit before calling SetParent. The below example uses Microsoft Mappoint and not excel but the theory is still the same. MpOpen =...

Thanks a lot, i've currently got a list view on my form that is populated from a dataset created from an sql server DB, i'm thinking of changing this to a datagrid because of the extra functionality you get with this but it really is a mystery, i'm begining to wonder if its worth all the extra...