Search results for query: *

Hello! Is there any way I can capture when a user tries to delete a specific worksheet and cancel the delete or display a message stating they cannot delete a specific worksheet? Thanks!

Hello! Is there any way to detect if the user is in Edit Mode in Excel (double-click a cell and the cursor is flashing within it)? I need to either disable my custom CommandBar buttons or display a message when this happens. Currently, if the user is in Edit MOde and goes to click a button on...

Does anyone know how to programmatically detect when Excel's Formula Bar has focus? I need to disable a custom CommandBar when the the cursor is in the Formula Bar. Thanks!

Hello! I am working on an Excel application with a form for user input. I found that when I am on the last control on the form (a cancel button) and hit the Up arrow on the keyboard, the VB Control Toolbox displays. How can I catch this and prevent the toolbox from displaying? Thank you in...

Hello! Does anyone know if there is a maximum number or words/strings you can use in regex alternations? (Ex: OH | Ohio | PA | Pennsylvania | RI | Rhode Island |...) I know regex's are fast but if there is a limit or if hundreds of words in the alternation would slow it down to a crawl, I would...

Hello! Does anyone know if there is a maximum number or words/strings you can use in regex alternations? (Ex: OH | Ohio | PA | Pennsylvania | RI | Rhode Island |...) I know regex's are fast but if there is a limit or if hundreds of words in the alternation would slow it down to a crawl, I would...

Hello! Does anyone know if you can grab the Line Number on a page where a table starts in MS Word programatically?

I need to detect whether or not several applications are installed on a local PC. After researching the subject, I found a few API calls (GetFileVersionInfoSize and GetFileVersionInfo) that will give info if it finds the application in the DEFAULT path for that application (which has to be...

Hi! Does anyone know what's wrong with this ASP code? Set objCommand=Server.CreateObject("ADODB.Command") With objCommand .ActiveConnection=objConn .CommandText="{?=CALL dbo.usp_parm_CheckIfEntityExists (' " & Request.Form("company") & " ',' " &...

Hello! I am using client variables and JUST found out (after testing 3 different PC's) that they are not saving correctly. Everything works properly on the developer PCs (2 of them)but not on other boxes. It seems that it saves one client variable, but when a DIFFERENT client variable is set, it...

Hi! I'm new to JavaScript and I have been painstakingly searching for info on how to grab all the items (values) in a listbox. The issue is that I need ALL the values; I'm using a calendar control's click event to populate days selected into a listbox. On form submit, I need to grab all of the...

Hi! Does anyone know if you need to manually include msado15.dll in a setup package for a Word2000 Add-In? I reference it in my add-in project however, the Package and Deployment Wizard did not bring that file (or the fm20.dll or msaddndr.tlb files) into the package. Are these files...

Hi! Does anyone know how to programatically capture the line number (of a Word document that uses Line Numbering) that a specific word is found? I need to build an AddIn that will display the line number (and page number the line number is on) for every occurence of a specific word in a...

Hi! Does anyone know what is returned by the COUNT function if there are no records in the table? I thought a zero would return but when I place my formula on the report to view the value, it is blank when there are no records in the selection. I have tried the IsNull function and it does not...

Hi! I'm a newbie to Word programming and I need to create an Add-In that will create an index of unique words in the document, give their respective counts and page numbers. My first issue I encountered is how to store a list of pre-determined words to exclude from the search (like a, an, the...

Hi! I'm creating a 6+ page report that needs it's subreports to be laid out specifically on each page, record independent. For example, if there are no records in one of the subreports, I still need to print 10 blank 'lines'; or if there are only 3 records, I need to print 7 blank 'lines' after...

I'm a Windows programmer and need to throw together quickly several web pages. The forms have many, many controls (at least 100 checkboxes and at least 70 textboxes)and will change every month. I don't want to create a different table in SQL Server every month to accomodate the responses for...

I need to DELETE an entire SQL Server 7.0 database (about 16GB) and was wondering if there are any cleanup procedures to run in SQL Server after deleting the database that size. Any info would be greatly appreciated! Thanks!

Hi! My company emails monthly surveys created as a Word Form document. Currently, the document is Password Protected (using Tools | Protect Document) which should allow the user to enter information into the fields ONLY. For the most part, the user has no problem opening, entering and saving...

I am developing a VB6 application with a SQL Server 7 backend. I have a stored procedure that creates a local temporary table to insert records to be queried from the front-end. My VB code uses the ADO Command object to run this stored procedure and I am using 'Set rsObject=cmdObject.Execute'...