Search results for query: *

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

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

Perfect. 2/2 earth. Thanks again!

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

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

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

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

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

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

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

Can you tell me how to do that please?

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!

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!

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

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

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.

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.

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

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.

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