Recent content by SpyderMan1234

I have a SQL Server 2005 server which exists to only run 1 application. Late yesterday, when activity would have been mininal, I set up an alert to notify me of the number of SQL user connections. This morning the number of user connections has ballooned up to 135 and counting. However, when...

Thanks guys. This has given me some valuable insight. I appreciate the comments.

I'm part of an organization running a Netware 6.5 network for several hundred users. Lately, they have been clamoring for remote access to the applications on their computers. I'm not the network admin and know very little specifics about our network. All that I know is that whether it be...

Excellent. This works perfectly. Thank you very much! JH

PH When I try this: SELECT A.CaseID, A.Crime, A.CrimeTime FROM yourTable AS A INNER JOIN ( SELECT CaseID, Min(CrimeTime) AS FirstCrime FROM yourTable GROUP BY CaseID ) AS F ON A.CaseID = F.CaseID AND A.CrimeTime = F.FirstCrime I get an error stating "Syntax error in from clause." I am using...

Thanks for the quick reply. I've actually tried this one myself and it just returns the orginal, full recordset. It does not JUST return the first, logged instance of each CaseID like I'm wanting it to do. I'll keep looking. Thanks

I have a table that has information that looks like the following: CaseID Crime CrimeTime ------ ----- --------- 1 Aggravated Assault 01/01/01 12:00 PM 2 First Degree Murder 01/15/02 12:00 PM 2 Aggravated Assault 01/15/02 12:05 PM...

Well, not using Word isn't an option. It must be used. Thankfully, I've found a way to deal with my problem. Thanks for the comments.

Does anyone know of way to capture the event that fires off when a dialog box is opened in Word? I'm trying to disable the "Organizer" dialog box from being available to users. I know that many of the menu commands can be intercepted by using procedures such as "Sub FileSaveAs" but I do not...

This probably isn't the best forum to ask such a question but... This is the setup. It's simple. I have a Windows 2003 server running SQL Server 2000. I have a Netware 6.5 server that is running software which accesses the SQL database on the Windows server. The software uses an .ini file...

I'll try to copy/paste the controls and all into a new form and see how that works. I do have a backup if all else fails. It seems that some setting in the form is not getting reset or something. But I've gone through every property on the form and everything is as it should be. Thanks

I have a straight-forward form. The recordsource is a SQL statement which pulls from two tables using a left join. The recordset type is Dynaset (Inconsistent Updates) so that they user can edit all information in the fields. Now, this form HAS been working perfectly fine. However, I added a...

Does anyone know of a way to capture the "Tools, Options..." event in Excel? I'm trying to capture this menu click action in an effort to hide several tabs on the options menu that I don't want my users to have access to. I know that I can do this with a customized tool-bar button, but...

Thanks Tony I never would have thought of something as simple as ToolsRecordMacroToggle. I'll see how this works with what I've got going. Many, many thanks Jeff

My office has recently deployed Office 2003 to all users. This includes a very stripped-down version of Word. I have had to disable many of Word's features using both group policies and VBA. I have been able to hide/disable everything I've wanted with the exception of one thing...The status...