Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Access: Find 2nd occurence of a string
- In a field named 'File' in MS Access XP I have text representing 'Artist - Album - Title'. I need to pull everything left of the second ' - ' string to create a directory path named ArtistAlbum. I can use "SELECT Left([File],InStr([File],' -')) AS DirName" but that pulls from...
- Tags: ByVal FieldValue, DirName, File, InStr, Maricaibo, Microsoft Access, programming, SELECT Left, Variant Dim sPath
- Q&A 2005-03-01
Additional Resources
- Print Margins in Outlook
- I have a computer that when ever the person prints an email part of the left side is not printed. How do I change the print margins.Thanks BunchesHere is how I do it in Outlook 2003.With the e-mail you want to print open, select File>Print Preview. In the Print Preview...
- Tags: Microsoft Outlook, Microsoft Office, e-mail, Page Setup, Print Preview
- Q&A 2005-01-31
- auto loading program when restarting
- I am running XP Media Edition - there are programs that I want to automatically load like AdAware when I reboot. I have searched Help but can't any reference. Programs like NAV do this as an option during install must do not. Any help would be appreciated...thanks...ronPlace the programs icon...
- Tags: left click
- Q&A 2006-03-13
- Desktop Task Pane
- Recently, a task pane showed up on the left side of my desktop. Not an application, the basic desktop. How do I get rid of it?ThanksRight click the Taskbar......in the grey space, or between tasks, then select the line Toolbars at the top and de-select Desktop from the pop-up list....
- Tags: desktop, james.downs@...
- Discussion threads 2007-01-25
- Use Word to create an organizational chart in minutes
- You don't need special software or advanced design abilities to create an organizational chart. Here's how to make a quick-and-easy org chart in Word. When you need to come up with an organizational chart in a hurry, you don't have to sacrifice a professional appearance in order to...
- Tags: Microsoft Word, Microsoft Office, Mary Ann Richardson, Word processors, Click OK, Insert Shape, organizational chart, Organization Chart, Microsoft Office Suite Word Tips Newsletter, Toolbar, Chart, Office Suites, Software
- Technical articles 2006-08-15
- SQL retrieving only rows of a size
- I want to examine the grades of students only if there are at least 10 students in the class. I think I should be able to write something like this, but I get all classes. What am I doing wrong?selectshrtckn_subj_code,shrtckn_crse_numb,shrtckg_grde_code_finalFROM shrtckn LEFT JOIN shrtckg ON shrtckg_pidm = shrtckn_pidmWHERE (SELECT count(b.shrtckn_pidm)...
- Tags: Banner, SELECT, SELECT COUNT, john.a.wills@..., programming, SQL
- Q&A 2006-07-18
- Arrowstick (zip)
- Arrowstick is a utility that turns your joystick x and y axis into the arrow keys. Once loaded, forward is up arrow, back is down arrow, left is left arrow, and right is right arrow. Features one single small executable file. To close, simply right-click on the tray icon and...
- Tags: Arrow, Arrowstick
- Software downloads 2006-08-24
- SQL Join
- HiI have 2 tables that I want to join, the two fields I wish to join on are both the same data type "VARCHAR2(20)" however field one contains data in the format "99999999" while field two contains data in the format "99999999/9". There is a unique match on characters 1-8...
- Tags: graemeduncan@..., inner join, join, software, SQL
- Q&A 2005-02-08
- display chinese in Firefox browser
- How do I read chinese words in Firefox browser. Do I have to install anything?thanks and regards,Select Tools--Options--click General in the left column--on the right side click the "Languages..." tab--this brings up the "Languages and Character Encoding" dialog box--click the down arrow by "Select a language to add..."--click the Add...
- Tags: choywg@..., click ok, Languages, Mozilla Firefox, software, Web browser
- Q&A 2005-11-28
- How can I find my old questions I have posted?
- How can I find my old questions I have posted?Depends on how old they areClick on my forum posts, there's a filter for questions asked.Otherwise you might get luck with Search.History QuestionsSign-In to TechRepublic then select My Workspace,on the left side you select My Forum Posts,you will then make another...
- Tags: bldsm@...
- Discussion threads 2007-01-16
- Store Result of SELECT stament to be used to UPDATE another table
- Hi, im trying to update a field of a table which is done through the results of a select statement. I need to be able to a store the results of the select statement which can then be used to determine if an update another table is initiated. This is...
- Tags: Notebooks, twanstall@..., laptop computer
- Discussion threads 2007-03-24
- File association
- I tried to open a file and a window poped up called "Open With". I accidentlly clicked Adobe Reader, now everytime I try to open the file the Adobe Reader window opens and says the the Adobe Reader is unable to open this file, it is invalid or corrupted. How...
- Tags: window, software, Ralenm, Adobe Acrobat Reader
- Discussion threads 2006-11-27
- Rolling out a scheduled task
- How do I roll out a scheduled task to my workstations?I've created a scheduled task, and have a script to copy this to the tasks folder on the workstations, however it doesn't take the security information with it and therefore it doesn't run properly.It needs to run as administrator.Thanks...You just...
- Tags: scheduled task, workstation
- Q&A 2006-06-29
- Open Windows 2000 Professional network folders quickly
- I quickly get around the network by1. select the WINDOW key on the lower left of your keyboard and while holding select 'R' for run2. when the run box opens, select the UNC ex. \servershareIt's very fast, and I don't map a drive.what if the share has a different password?What...
- Tags: jakesty, network
- Discussion threads 2007-10-16
- Cannot open help and support
- When I try to open any help related link I keep getting error messagecannot open help and support because a system service is not running. to fix this problem, start the service 'named help and support.Course I can't do this cause I keep getting error message. I am running xp...
- Tags: supersimes@...
- Q&A 2005-10-29
- Full HD not showing, why?
- I upgraded to a 160gb hd and made a 20gb partitionfor my XP install. It runs fine but only shows a 20gb drive. Where is the rest of my HD?It's still there, but presently unallocated.Navigate as follows:Start > right click on My Computer > left click on 'Manage' > left-hand...
- Tags: ssgt_perez@...
- Discussion threads 2007-10-19
- MouseEasy (exe)
- MouseEasy allows mouse wheel directly take effect on the non-activated window, which allows you directly browse as you turn the pages, and significantly reduces the times of misclicking particularly in the Web page; MouseEasy not only can use the "click wheel" to replace "Ctrl + click the left button", but...
- Tags: Window, ACrosscut Software, MouseEasy, Construction, Mice, Hardware, Peripherals
- Software downloads 2008-04-08
- Can't change G drive to C drive
- My hard drive went bad and I had to replaced it before by warranted part came in. I named this drive C. When my replacement drive came in, I installed it and left the other new one in my drive. The replacement drive was named G. Now...
- Tags: disk, Disk Management, G, Microsoft Windows XP, nlyons15129@..., windows
- Q&A 2005-01-31
- AlterJig (zip)
- AlterJig is a set of tile-based jigsaw games and puzzles in which you can select graphics supplied with the games or create your own puzzles from any bitmaps. When you select 'new game,' AlterJig scrambles the puzzles and challenges you to restore the pictures by rotating groups of four tiles...
- Tags: Tile, AlterJig, Games, Personal Technology
- Software downloads 2007-07-16
- how to remove write protection form jumpdrive
- i need to remove write protection from my jumpdrive... it never happen until someone borrowed it and rerurned it...cannot do any editn' to the documents i saved in there, even tranfern' file from jumpdrive to the pc....Try this...with your drive plugged in, open Windows Explorer. In the left-hand pane...
- Tags: mdaley@...
- Discussion threads 2007-04-22
- << Previous
- page 1 of 1
- Next >>
