Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dazzer123

    Rotate an image

    How can I rotate an image in Crystal Reports?
  2. dazzer123

    Convert time to seconds

    I see, thanks for your help.
  3. dazzer123

    Convert time to seconds

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

    Convert time to seconds

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

    Joins and Aggregate Functions

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

    Joins and Aggregate Functions

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

    Microsoft Access Performance Monitor

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

    Crystal and vb .net

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

    Printing ListView control

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

    Printing ListView control

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

    Copying files

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

    DTS and no-touch-deployment

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

    DTS and no-touch-deployment

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

    Remove spaces in middle of string

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

    Remove spaces in middle of string

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

    Countdown Clock

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

    Countdown Clock

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

    Countdown Clock

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

    Problem with API and Window focus

    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 =...
  20. dazzer123

    Datagrid and images

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

Part and Inventory Search

Back
Top