Recent content by hoialmen

Thanks to all for the prompt replies! Denny - thanks for your suggestion. I think that'll work. ESquared - my question exactly. It is my understanding that this naming convention is the result of the way this company has evolved over the years. At one point each development group managed...

Greetings All! I could use some thoughts on how to deal with capturing values in a Stored Proc that is being run on various SQL Servers where the same database has different names. What I'm dealing with is an environment where the naming convention for my main database is reflective of the...

Hi again, In addition to the content of my previous post, I would also like this SP to kill any SPIDs that meet certain criteria. Example: != to certain LoginNames(some we don't want to kill), > a specified number of blocked users, > than a specified blocking duration, etc. I guess this would...

OK, here's one for you... I have a Stored Procedure that I run which returns key information on production database blocking. Whenever we put out a new release of our software, the DBA group spends a lot of time monitoring blocking to isolate any problems with data access in the new release...

Terry, You're a Rock Star! Your logic works well for this simple example. I hope I can use it in my MUCH more complex scenario. The problem I am dealing with is that I currently have 5 conditional JOINS and 4 conditional selection criteria. This could complicate things a bit because there...

Greetings All! I am working on a Stored Proc for a ColdFusion development team and am running into a few issues that I was wondering if anyone could help me with. The SQL being passed to the server by the ColdFusion pages is currently being generated dynamically on the client side. The...

Thanks to all for the good advice! This particular stored proc is becoming more complex than I imagined. There are some additional problems but I am going to create a new post for them as they are really not related to this topic. Thanks again! Nathan C. Hoialmen President Encephalon...

Thanks for all the prompt feedback! Unfortunately the coding standards implemented by our DBA group don't permit dynamic SQL so it looks like multiple SPs is going to have to be the answer. Thanks again for the feedback. Sincerely, Nathan C. Hoialmen President Encephalon Business Solutions...

Greetings All! Wondering if anyone knows if it is possible to pass a database name into a Stored Proc and assign it to a variable to be used in a SQL statement. I am writing a Stored Proc that needs to reference a group of databases that are the same structurally but contain different data...

OK, I seem to have at least partially answered my own question. I found an article on Adobe's website explaining how to create custom formattings. Basically you simply create a text file under C:/Program Files/Adobe/Photoshop Elements 2/Presets/Formattings/(your_file_name).txt using the specs...

Greetings All! I have a user that uses Photoshop Elements 2.0 to format and print images captured using a digital camera. What the user is asking for is the ability to have the file name print as the default label when printing an image. This feature already exists as an option under...

Greetings All! I have seen a few threads regarding this topic but have not yet found an acceptable solution to this challenge. Here's my challenge: I have an editable government form that has pre-defined fields and is in a PDF format. I have an Access database table that has roughly 500...

Thanks Roy! Yeah, I think you're right. I discovered that making a copy of the label resolved the problem (previous post). The form I am working on was created by someone else and it's possible that they dragged the fields and labels from the field list (as you explained). I usually make all...

Interesting... Just out of curiosity, I tried copying one of these dysfunctional labels and pasting a copy of it onto the form. Guess what? The copy has event properties. So, for now, I am just going to copy, paste and replace the labels that are giving me trouble. I would still like to...

Hi All! I am working on a user form in Access and seem to be experienceing some odd behavior. I have one form where NONE of my labels have event properties(?). I have checked all the other forms in the application and they seem to be functioning properly. Has anyone ever seen this behavior...