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

    distinct

    What am I missing? i think it's simple, but i can't grasp it. From my SQL pasted below, I get a list of contractors that are listed before 10/1/2005, but not after 2005. This is exactly what I want, but I only want to return 1 value for each contractor (So if contractor XYZ has 5 rows...
  2. trk1616b

    Quick SQL help

    I think this is fairly easy, but i'm far from a SQL expert. Use these fields in my table: -Date -Customer_nm I'm trying to get a list of rows with this criteria: -The customer must have a row before 10/1/2005 -The customer must NOT have a row after 10/1/2005 -List them by alphabetically...
  3. trk1616b

    OpenFileDialog

    Perfect. 2/2 earth. Thanks again!
  4. trk1616b

    OpenFileDialog

    Absolutely, they have been great. The feedback you helped with yesterday solved my problem. Thank you.
  5. trk1616b

    OpenFileDialog

    I'm using an OpenFileDialog box on my app. When the form loads, i want the system to go and see if a hard coded path exists AND if a hard coded file exists in that path. If the file exists, I want to assign the file to OpenFileDialog.FileName. Anyone know any good ways to do this? I've tried...
  6. trk1616b

    Time Display

    I am trying to calculate a time to be displayed in a label (Minutes & Seconds) from a given # of seconds. So, if the seconds returned is 125, I want the label to read 2:05. I'm having a hard time due to integer rounding. Below is what I have right now: s_timemn = lDuration / 60 s_timesec =...
  7. trk1616b

    MainForm

    I unwisely created my entire program w/o renaming everything from "WindowsApplication1" first. I now went in and renamed everything to what I wanted, but I am receiving an error when trying to run the app. The error I get is "NoStartupFormException was unhandled"....."Make sure there is a...
  8. trk1616b

    Windows Media Encoder

    Might be a long shot, but does anyone out there have any experience with Encoding videos using VB .Net? My program encodes a digital tape from a video camera that is plugged into the computer using a firewire port. My question is how to set the bit rate information?? I have a successful run...
  9. trk1616b

    Hover and gray out an item in a drop down list

    2 Questions... 1- i want to hover over a text box and diplay a string. I can't figure out how to do this in .NET. 2- is there a way to 'dither' and item in a combo box? Basically, i have 3 items in my list, and i want to be able to select 2 of them, but I want the 3rd to be displayed, but...
  10. trk1616b

    Runstate change?

    I've got a video camera hooked up to my computer through a firewire port. I'm trying to play the tape in the camera and encode it on my computer using Windows Media Encoder. I've got everything working, but I cannot capture when it has stopped encoding. I'm using a 'MyEncoer.start' command to...
  11. trk1616b

    setup

    Can you tell me how to do that please?
  12. trk1616b

    setup

    I've included a 3rd party dll in my program. However, when I send the .exe I created in my project to another machine, it doesn't see the 3rd party dll and does not run. How can i incorporate the dll into my exe? Do I need to create some kind of setup file that includes it? Thanks!
  13. trk1616b

    Internet Connection

    I'm looking for an easy way to verify whether the user has an internet connection or not. I'm building an app and I just want to make sure the user is connected to the internet before proceeding. Any ideas? thanks!
  14. trk1616b

    Browse for a file

    Beautiful...at first try this seems to work like a charm. Thanks Tip and Shorty...great help!
  15. trk1616b

    Browse for a file

    EXCELLENT! You guys are great...I was looking for Windows Forms in the Add Items from the top tool bar instead of the toolbox....nice work, thanks! A couple quick questions while I have your attentions. My next task is to take the take the file selected and rename it. If I use...
  16. trk1616b

    Browse for a file

    Thanks for the quick response, Shorty. I can't find the 'OpenFileDialog' form you mentioned. I'm assuming it's a from already within VB, but I don't see it anywhere. Where can I find it? Thanks again.
  17. trk1616b

    Browse for a file

    Is there a way with vb.net to browse for a file on the computer? I want to make a button the user clicks and it brings up Microsoft's normal browsing windows so they can browse and select a file off their C drive. Any ideas? Thanks.
  18. trk1616b

    Easy Update Question

    This should be an easy question, but I rarely mess with SQL. I need to update the results from the following query: select * from table 1, table 2 where table1.field_ID = table2.field_ID and table2.field_flag = 'y' My problem is I can't get the syntax to update a field in table 2 above...
  19. trk1616b

    Return multiple Values

    Ticket_no is from a txt field on a form. I have 2 records in my database that have a ticket_number field of 123. When I enter in 123 for Ticket_No, the recordcount is only 1. That's why I'm confused.
  20. trk1616b

    Return multiple Values

    I've got a Access form and i'm trying to write code to return a set of records based on an SQL query. The below code only returns 1 record. Anyone know how I can return multiple records? Thanks! Dim db As Database Dim rs As Recordset Dim strSql As String Dim TICKET_NUMBER As Long...

Part and Inventory Search

Back
Top