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!

  • Congratulations Chriss Miller 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: *

  • Users: dazzer123
  • Content: Threads
  • Order by date
  1. dazzer123

    Rotate an image

    How can I rotate an image in Crystal Reports?
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. dazzer123

    Printing ListView control

    Does anyone know how (if at all) I can print out the contents of a listview
  7. 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...
  8. 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...
  9. 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...
  10. dazzer123

    Datagrid and images

    In a list view I can have an imageindex value, can I have the same thing in a datagrid
  11. dazzer123

    Refresh list view but keep position

    I have a list view on a windows form that is populated from an SQL server database. There is a timer on the form on the tick of which the list view 'refreshes' and the data contained in the list view is updated. What I would like to happen is, when the list view is updated, the vertical scroll...
  12. dazzer123

    Problem with API and Window focus

    Hi, I have a vb.net Parent form which contains a child form, on the click of a button on the child Microsoft Excel is opened and, using some API calls and the handle of Excel and the vb.net Parent Form, Excel is then set as a child of the vb.net Parent. The problem I am having is that when you...
  13. dazzer123

    VB.Net And API Problem

    Hi, I have a vb.net Parent form which contains a child form, on the click of a button on the child Microsoft Excel is opened and, using some API calls and the handle of Excel and the vb.net Parent Form, Excel is then set as a child of the vb.net Parent. The problem I am having is that when you...
  14. dazzer123

    Strange behaviour in MDI parent

    Hi, I have an MDI Parent form which contains a child form, on the click of a button on the child Microsoft Excel is opened and, using some API calls and the handle of Excel and my MDI Parent, Excel is then set as a child of the MDI Parent. The problem I am having is that when you minimize my...
  15. dazzer123

    Updating Form1 From Form2

    I have a form Form1 that opens up Form2 as a modal type form on the click of a button. What I now need to do is update the value of a textbox on Form1 with a value that is entered into a textbox in Form2, again on the click of a button, it should then close Form2. This used to be fairly...
  16. dazzer123

    Log in computers

    We have about 40 computers that we switch on every morning using Wake-On-Lan what we would also like to do is then run something that would send ctrl-alt-del to this computers and log them in, they all have the same username and password. Is it possible to use something (possible sendkeys) to...
  17. dazzer123

    Change window border style

    I have a VB .Net application that, using Windows API, pulls Microsoft Mappoint in to it as a child window. What I now need to be able to do is change the border style of the Mappoint window so that it is no longer sizable. Here is what I have so far MpOpen = FindWindowNullClassName(0, "Map -...
  18. dazzer123

    Open File Dialog

    How can I use an Open File Dialogue box from within VBA to return the path to a file (with extension *.doc)
  19. dazzer123

    Set up new database with VB

    Can anyone tell me if it is possible to set up a new SQL Sever DB either from an Access adp or from a vb .net project. Also could anyone tell me how I can run a .sql file on this new database programaticaly
  20. dazzer123

    Unique ID Without using Identity Number

    I have a Database which contains records that need to have the unique ID NE00000001 NE00000002 NE00000003 Etc. I am unsure of how to create this unique ID field so that it is automatically entered on every insert. I dont really want to have to run some code for every insert as myself and a...

Part and Inventory Search

Back
Top