Search results for query: *

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

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

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

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

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

I am applying a template to a new document in Word using Documents.Add Template:="MyTemplate" _ , NewTemplate:=False, DocumentType:=0 But whenever I type some text and save and close Word, I'm asked if I want to save changes to MyTemplate. I was under the impression that using Documents.Add...

Does anyone know of a permanent way of disabling the document echo feature in groupwise. It can be found by going to tools/options/documents/general... Of course, I know that it can be simply unchecked, but I would like to completely disable the option entirely (grey it out) so that it will...

Does anyone know... When a change is made to a toolbar setting in Word by using VBA such as commandbars("menu bar").controls("file").controls("permission").visible=false where at in the registry is this change reflected?? I appreciate any help! Thanks in advance.

I have an input box that accepts a Docket Number (among other things) via an input message box. The code looks like this: MyDocketNo = InputBox("Please enter a valid Docket Number for this case.", "Enter Docket Number") When I later try to INSERT this mydocketno value into a table using an...

OK guys...basic question here I know, but I just cannot figure out what's going on. I have a simple combobox and listbox setup where the user selects values from the combobox and as they are selected, they appear in the listbox. My problem is that I cannot get the combobox's selection to...

I need to create a report that lists all account numbers, but there are some numbers that are exceptions to the rules and do not need to appear on the report. What is the best way to handle this? Create a table called "Exceptions" for keeping all of the account numbers that do not need to...

I have quite a few reports that need to be printed on a weekly/monthly/quarterly basis. I know how to use DoCmd to print out reports via VBA, but I don't have the time to hardcode the name of each report into the code. I wondered if there was a way of telling MS Access to print all reports...

I am using Access, in part, to send out welcome emails to new customers via Groupwise's API. What I'm doing now is setting this welcome message as a string variable and then using that variable to fill in the body of the email before it is sent. This works great, but the only thing is that it...

I have a recordset that looks something like this: CISKEY DescCD MLE6456 32 MLE6456 32 JBH1123 10 JBH1123 10 JBH1123 32 JAD5546 10 JAD5546 10 What I need is a way to go through the recordset and for each grouping of CISKEYs if...

I'm fairly new to VBA, but I've managed to create a DB that sends out emails to addresses obtained through a form. After an email is sent to a certain individual I need to flag the record so that you cannot send anymore emails. I understand the logic on how to do this, but I cannot figure out...

I have a large database of email addesses and it would be great if I could use a VBA Novell Groupwise control to put code behind a command button and automatically send an email to all of the addresses in my Access table. Does anyone have any experience with this? Any help is greatly...

I am looking for a way for Excel to insert a new row when a certain series of numbers changes. e.g... From this: 1234 1234 5546 5546 5465 7895 7895 To This: 1234 1234 5546 5546 5465 7895 7895 I'm assuming that this can only be done via VBA. Anyone have any clues on...