Recent content by drewson

The event is cancelled by individual, the entire event is not cancelled. Thanks!

Hi, I have two tables, participants and events. For every participant, there are many events. I am trying to figure out how to select all of the participants who have always cancelled events. There is a "Cancelled" boolean field in the events table which is True or False, so I need to select...

Thanks everyone for the input. I think this will solve my issue completely. I put it in a stored procedure, and it works great! Although, I considered making it a scalar-valued function. Any recommendations on the best way to implement it? To take it a step further, I'd like to keep the...

I want to create a custom identity column or at least a way of setting IDs in my table based on the following format: YYYYDDDXXXXX YYYY = Four digit year DDD = the day of the year, in numeric form XXXXX = an incremental integer that restarts at 00001 every day. So, on January 1, 2007, I would...

I have a client app where I am checking in and out records often for about 10 clients. Every time an individual opens a record for editing, the client app sets a flag that indicates the record is checked out and assigns a username that the record is checked out to. After they close the record...

I think the only updating changed rows will work best for me! Thanks!

That's great, and I'm currently using a timer to refresh the list, but when I have a few hundred records in the list, it drastically slows the UI every time it is updated. Is there a way to update the listview without clearing and refreshing everything?

Hi, I've been searching for awhile on this topic and I may be posting in the wrong forum, but would someone just point me in the right direction? I think I may need to use COM+, which I have zero experience with. Basically, I have a distributed data entry system. I have an "administrator"...

Got it. MyBase.ProcessDialogKey(Keys.Tab) Won't work for shift-tab, but that's ok.

Hi, I've created a custom user control in VB.NET called kTextBox for a data entry application that includes a textbox and a picturebox in the control. The picturebox is just used to show the user whether the textbox has been validated. Every time the user hits ENTER while in the textbox, I...

All right, that's what I thought I'd have to do... thanks for all the help!

Well, let me explain more of what I'm doing... My program loops through images and reads barcodes off of any image with a barcode. Those barcodes are read into an arraylist. If a barcode is read incorrectly, it gives the user the ability to key in the barcode number from the image. Thus, I...

I think I'm going to go with option 1 for now. It'll save me some headache. Thanks!

I guess I should have added this caveat: I'm doing double key entry for data entry and have to not only bring up a box to type it in, I have to display an image as well. Opening up a new form would force me to pass the image between forms, etc. Is this still the best way? Thanks again!

That's one way, but I need to have my users enter into a textbox before the sub can continue.