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 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: *

  1. drewson

    Find Participants who have always cancelled

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

    Find Participants who have always cancelled

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

    Custom Identity Column

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

    Custom Identity Column

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

    Stored procedure to "check out" data to a client app

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

    Automatically updating controls when db is updated

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

    Automatically updating controls when db is updated

    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?
  8. drewson

    Automatically updating controls when db is updated

    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"...
  9. drewson

    ProcessTabKey from Custom User Control

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

    ProcessTabKey from Custom User Control

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

    Pause for user input

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

    Pause for user input

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

    Pause for user input

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

    Pause for user input

    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!
  15. drewson

    Pause for user input

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

    Pause for user input

    What's the best way to pause a process for user input? Here's my situation: I open a form with a progress bar that shows images processed. If it gets to an error, the sub needs to stop, activate controls on the form for user input, then continue when the user clicks Continue. I thought that I...
  17. drewson

    After Form Load, but before Form Activate? Runs Once

    I'm trying to set up a form that automatically begins a sub as soon as it appears onscreen (thus I thought of using the Paint event), and shows a status indicator moving up, etc. But if I click off, then click back on, the process starts over again because the form is repainted. How can I...
  18. drewson

    Defunct Python Processes

    Ok, but this is the error message that's dropped in my inbox. I just assume that it's linked to all my hundreds of defunct python processes. Any ideas? Message 16781: From root Thu Sep 16 23:00:00 2004 Date: Thu, 16 Sep 2004 23:00:00 -0400 From: root@rhapsody.cedarville.edu (Cron Daemon) To...
  19. drewson

    Defunct Python Processes

    Sorry, just realized that these logs probably won't help... I'll see what else I can find.
  20. drewson

    Defunct Python Processes

    I'm getting TONS of defunct python processes. Anyone know what's going on? It also seems to be linked to a program called MRTG. Here's an excerpt of my crond log: Sep 16 21:19:00 rhapsody CROND[9006]: (mailman) CMD (/usr/bin/python -S /var/mailman/cron/qrunner) Sep 16 21:20:00 rhapsody...

Part and Inventory Search

Back
Top