Search results for query: *

Excel 2016 on Windows 10. I have some code which filters the data in a worksheet by date. The date is entered into a user form and populates a date variable. The date format is: dd/mm/yyyy When I activate the autofilter in the code, it reads the date as US format and therefore does not display...

I can't get the "firewall with advanced security" to work on Windows 7 machines through group policy. The existing policy has settings for the Windows XP firewall which are working OK. I followed the Microsoft TechNet guidance on the additional settings required for Win7...

I've just got a Win Mobile 6.5 phone, previously had Win Mob 5 phone. The new phone won't sync with my work Exchange server. All settings match those on the old phone. I copied the SSL certificate from the server to the phone and installed it, but it will only install in the "intermediate"...

We have a SonicWall Pro 4060 and are using the SonicWall Content Filtering Service. I need to block access to YouTube and Web TV sites, but have found the CFS only offers "MP3/Streaming" which doesn't appear to work for these sites. The current, far from ideal, solution is to block the ".tv"...

I need to use a script (/usr/bin/ksh) to remove certain characters from a data file. The format is plain text. I want to remove the last character on a line only if it is the one specified in a parameter to the script. The specified character often needs to be the pipe character. I find I can...

I have an Asus A7A266-E Socket A motherboard, running an AMD Athlon XP1800+ processor. I have come across suggestions in support forums that there is a limit to the IDE (PATA) disk size this will support (could be 120 GB max). I can't find anything in the manual or on the Asus web site about...

I am trying to use Viewpoint to check which web sites are being accessed at what times of day. I have created a custom report, based on the Web Activity template, but the Source User/Hostname column always says "N/A". I am able to see web usage by IP address in the standard summary reports (but...

I have a Mitsubishi Diamond Pro 920 CRT monitor that is just under 4 years old. Just recently I have noticed flakes of the screen coating are coming off leaving lighter areas on the screen. As this continues it is becoming more noticable/annoying. Is there anything that can be done to repair or...

We have a problem with our temp dbspace. There is a known bug with IDS where temp dbspace can get corrupted and can't be recovered without restoring the database. This happened to us and we had extra temp dbsapce added, because at the time we could not restore (due to another bug). When the...

Hi, I have a form with several controls that must be populated before the OK button is enabled. The controls are either combo boxes or text boxes. In the OnChange event of each of the relevant controls I run a function. The function tries to check that each of the controls is populated. The...

Hi All, I have been a bit rash ! I created a switchboard with the switchboard (s/b) manager, and added a couple of buttons, then decided to get rid of it and start again. When I tried to delete it in the s/b manager, it said "..can't delete default switchboard" so, undeterred, I went and...

Hi, can anyone tell me if it is possible to convert a character field to numeric when I don't know what the character part is going to look like ? Maybe I'm expecting too much, but I'd like to convert the data in a column formatted as character, to numeric by simply dropping all the alpha...

Does anyone know of an incompatibility between jre 1.1.8 and Windows XP Tablet Edition ? We have a java application that requires jre 1.1.8 and has been running fine on Win95, Win98 and WinXP Pro. I recently tried to install the jre on an eval. tablet from Fujitsu running XP Pro Tablet...

I receive files from a customer, which are pipe (|) delimited (as required by my specification) but this particular customer's file names end with ".csv" (in fact they are like: "order1.txt.csv"). I have written code to import the file into a workbook, using the pipe symbol as the delimiter...

This sounds like it should be a simple task, but I have not been able to find a simple explanation. I need to create a new table, which will grow to be quite large (approx. 500,000 records). I want to calculate how many pages to assign to the table at creation, and what the next extent size...

Hi, I've just bought a Palm 500. Everything is working OK except for sync-ing the Datebook. When I go to Hotsync > Custom in the Desktop application, the Datebook doesn't appear in the list, so I can't configure its behaviour. Can anyone tell me where I'm going wrong?

I have an intermittent problem where when my PC comes out of hibernation and I enter my password it is not recognised. None of the user passwords are recognised (this includes the admin account). This includes accounts that were logged on when it went into hibernation, or fresh logins. If I...

I am using forms for user input (which run from the Workbook_Open event), which modify the characteristics of a file. I don't want the user to see the file in the spreadsheet (which is an imported text file, and will be written out as a text file after required changes are made). I have tried...

I have an odd problem which has the following symptoms: 1. In Explorer, and Word/Access/Powerpoint 97 file / open dialogs the .doc/.mdb/.ppt files have Windows default icons, instead of their own, although the files open ok via Explorer and Office 97. 2. I can not use "send to" from...

I need to be able to display a listbox on a form, which will accept up to 999 items in the list (populated by an array or from a range on a spreadsheet). Does anyone have a suggestion for the best way to do this, as I have found that the listbox will not accept more than 256 items ? (I would...