Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: StevePB
  • Content: Threads
  • Order by date
  1. StevePB

    Excel Date Issue with AutoFilter

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

    Windows 7 Firewall Domain Group Policy

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

    Activesync + Certificates

    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"...
  4. StevePB

    YouTube for a single user

    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"...
  5. StevePB

    Remove character at EOL

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

    Largest disk for motherboard

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

    Viewpoint Souce User

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

    CRT Screen Coating Flaking

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

    temp dbspace

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

    Problem with OnChange event in TextBox

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

    Lost Switchboard Form

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

    Convert CHAR to numeric ?

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

    jre 1.1.8 and winxp tablet edition

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

    How to override text import for CSV ?

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

    How to estimate table size

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

    Datebook hotsync problem

    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?
  17. StevePB

    Passwd not recognised after hibernation, must reboot

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

    Excel Window Size

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

    Win NT 4 sp 6 + Office 97 file association problem ?

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

    Listbox for more than 256 items (Excel 97)

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

Part and Inventory Search

Back
Top