Search results for query: *

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

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

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

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

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

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

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

I am embedding a Windows Media Player object in my web page and I need to output the status information as it updates from the plugin. Can javascript monitor the plugin status properties and detect when they change? There's also a StatusChange event that fires every time the status changes on...

I've written a sub procedure to fill a listview with a query that I pass to it. I can't remember out how to dynamically reference the listview with the lvwItem so I can perform the procedure on different listviews. How can I do this? Private Sub FillList(strSource As String, lvwItem As...

How do I format the column of a ListView control? I want to make the entire column a different color or make the text bold. Thanks.

I'm trying to set up a password protected section of a PHP based site. I am using the require function at the beginning of a file to include a file that checks the user's session credentials and then redirects them to an access denied page if they aren't the right user type. This check and...

I want to have a button on my form that prints off a report. I've figured out to use this line of code to just print it to the default printer: stDocName = "RepairOut" DoCmd.OpenReport stDocName, acViewNormal But I want the printer dialog to come up so I can let the user select the...

Is there any way to detect which control the focus is moving to in the LostFocus of the control that is losing focus?

I have two tables: labusers fields: userid (key), email, firstname, lastname... etc labresults fields: userid (key), surveyid (key)... etc survey info I need to select email from labusers when their userid does not exist in labresults for a specified surveyid. (Basically, list the...

I'm creating a database for an audio-visual services dept at a small university, and we're tracking equipment from room to room with the EquipHistory table. EquipInfo stores the data about each individual piece of equipment, and the two are related by SerialNum. I want to put a combo box on a...

I'm working on a press release movie, and I've coded the page to load headlines from a text file. They are all neatly displayed in separate dynamic text boxes when I view the code in the standalone Flash player, but when I view it in the browser, all except the last one loaded disappears. My...

I am loading a number of variables from a text file: news1 news2 news3 ... I want to cycle through them to manipulate their values until I get to the last defined variable (so I can put as many variables in the text file as I please. I've tried using a for loop, but I think I've got the wrong...

I'm trying to find the height of a dynamic text field after I load text into the field from a text file. So far, the textHeight and _height properties seem to give me bogus numbers. (Like 307 when the field is actually around 1500) Thanks