Search results for query: *

I have a named range on a sheet that is used to populate a data validation drop-down box. In my range I have blank cells so the user can easily add something to data validation drop-down without having to worry about increasing the size of the range so that data validation picks it up. The...

When a user enters a value into a cell and hits enter, the activecell is no longer the cell that the user entered a value into. My question is, how can I delete the contents of the cell that the user just entered data into? Thanks.

I need an Excel formula that adds up specific cells in column H that meet the following conditions. If the cell in column D = 100 or 800 AND if the cell in column G does not equal "CA", "FML", "FMU" or "ULW". A B C D E F G H I J K 100 CA 2...

My organization has Excel 97 (Yeah, I know, the stone age!) I've encountered a documented bug in Excel 97 whereby if you freeze panes on a section of the worksheet that has data validation drop-down boxes, they stop working. Is there any programmatic workaround to get around this problem, like...

I would like to know how you align a table to the very top of the screen. I don't want to see any space between the top edge of the screen and the table and it seems that Internet Explorer, by default, is doing that.

We are on the verge of installing Microsoft Office 2003 on all the computers in our organization. Currently we have Outlook 2000 and automatically generate outlook profiles in our log-in script (kixtart), code snippet follow: system1.kix code: shell ol-prof.bat @userid ol-prof.bat code...

Where can I find on the internet a table of all the task scheduler error codes for windows 2000 server? I'm getting an error code of 0x407 and I have searched all over the net and can't find any decent article or documentation telling me what task scheduler error codes are. I checked...

I have an Outlook form where I have drop-down boxes. The drop-down boxes are bound and populated from a text file on the network. The text file is a list of employee names which constantly changes. This is working fine except for when they want to archive the e-mail messages sent and review...

thread216-539453 I'm using the following Javascript command in an HTML page. What it does is bring up the save file dialog box, to which a user uses the drop-down to tell it where to save a file. document.execCommand('SaveAs'.... What I would like to do is determine what path the user...

We use the following command line to robocopy files from one server to another. "c:\program files\resource kit\robocopy.exe" \\server1 \\server2 /e /np /secfix /purge /W:0 /r:0 /log:e:\backup\logs\weekly.log The files are copied over with no problem. What is happening though is that the...

I have an HP4100TN printer installed on a Windows 2000 Terminal Server. When a Windows 2000 terminal server user prints from an application they sometimes encounter the problem I'm describing here. Half of the page prints normally then prints the following: []P[]L SET RET[]ON []P[]L SET...

I am a newbie at SCSI. The network admin asked me to install an external tape device to the server. In the registry I examined the HKEY_LOCAL_MACHINE\HARDWARE\DEVICEMAP\SCSI key and it had the following subkeys: Scsi Port 0 Scsi Port 1 Scsi Port 2 If I go into Start-Settings-Control...

When printing a report from an outside vendor system, a print job gets stuck in the queue Document Name Crystal Reports ActiveX Designer--report.rpt Status: Mismatch: User selected a tray that has not been installed. User can print from outside vendor fine if the document in question is not...

I have a Windows 2003 server. Why is it I can log on to one domain and have the log-in script execute and when I log into another domain I don't have the log-in script execute? In user manager for domains they are pointed to the right place to read the log-in script. Is this simply a group...

On Windows 2003 Server, where is system policy editor (poledit.exe), where can I download it? I want the version of system policy editor for Windows 2003 server.

I am brand new to MIVA and am really stumped. I'm getting the following error: LINE 1306: Syntax Error: Attribute '</MVFUNCTION' begins with a non-alpha character. First of all, what does this mean? What red flag should I be looking for in the code? Any help would be greatly appreciated.

With check boxes what do the following states mean? -1 0 1 Which one means checked and which one means unchecked?

I have set-up my recordset as follows: Set rst2 = da_dbs.OpenRecordset("SELECT Services_Rendered.*, CrimeVictim.*, Crime_Case.* FROM Courts INNER JOIN (CrimeVictim INNER JOIN (Crimes INNER JOIN (Crime_Case INNER JOIN Services_Rendered ON Crime_Case.Crime_Case_ID =...

I have a msflexgrid on a form which is bound to a recordset. How do I get the msflexgrid to refresh itself to reflect changes in a recordset? I tried msflexgrid.refresh and msflexgrid.redraw = true to no avail. Can anyone help?

I'm using Visual Basic 6.0 to generate folder labels in Microsoft Word 97 with the data source for the labels being a table in a Microsoft Access 97 database. The labels are generating fine, my only problem is that an instance of Access is started and remains open until the Word Document is...