1 Resources for

len.chabot@...

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Plate check overload: blog root; Tags: Blogging, len.chabot@...; Discussion threads 2006-08-22

Additional Resources

Access 2000 Data field update: How do you remove the “ – and the number” at the end of various length identifierslike these D848697A-1 2408824-1 80176992-7 in an Access data field?Point value changed by question poster.If the identifier ends with a - and a single number then use (where...; Tags: devmann, Len, Microsoft Access, software, strID; Q&A 2005-03-11
VB6 ToolTipText: How do I produce a "wrap round" in the text inputfor the ToolTipText property. Would like to produce a "box" of text not one complete line of text.You may want to try the carriage return vbCr preceeded and followed by ampersand. I've never tried using in this context, but it...; Tags: Len, Me.txtMsg.SelLength, Me.txtMsg.Text, Microsoft Visual Basic 6.0, programming, stokecity, TempMsg, Text1.Text, trapper, vbCr; Q&A 2005-05-13
Sort in Excel and replacing chars: I have 18000+ rows in excel, each row has a different value on it. For Example:PTH03020WAZPTH03030WAZPTH03030WADPTH03050WAZPTH03050WADPTH03050WAH.PTH03060WAZPTH03060WADPTH03060WAHPTH03060WAH.Now if the first 8 chars are the same, I want to remove the remaining chars and replace with "Space Series"Can anyone help with this?!Thank you in advance!RossNeed a little more infoAre you wanting a...; Tags: rmurgatroyd@..., Microsoft Excel; Discussion threads 2007-11-21
how to generate Autonumber with Date together in Access 2002: I have a field call PIR No, in this field I want a Date and a autonumber appear in this field....thanks.This might help....Thanks to Wayne for this formula. SELECT Format([TableName]![DateField],"yy") &IIf(Len([TableName]![AutoNumberField])=1,"00",IIf(Len([TableName]![AutoNumberField])=2,"0")) & [TableName]![AutoNumberField] AS NewNameFROM TableName;This will work up to record 999 (after that you will have to alter theformula...; Tags: Microsoft Office, Microsoft Word, Databases, Microsoft Access 2002, TableName, AutoNumberField, Microsoft Access; Discussion threads 2008-04-05

Assistance with formula: Could anyone assist me with a formula in excel that could reverse names - which appear last name, first name - in column A and place first name in column B - and last name in column C - I receive lists of hundreds of names in the format last,first...; Tags: A2,1, A2,Find, Pearson, Charles, first name; Discussion threads 2008-08-27
Error 3075 due to apostrophe: I am using Access VBA to create a recordset. The code works fine until I try to read in a field containing the name O' Donnell. I get the above error due to the apostrophe. My code to open the recordset is: strStaff = "SELECT * FROM...; Tags: rsMailingList!Last, Chr; Q&A 2005-05-26
MS Access Search Form: I'm hoping someone can help. I decided to cut back my detailed search form since we have many users that are not very adept at computers. I've since instilled a very easy user friendly search form that is utilized through a comand button on the exact form they're trying...; Tags: Microsoft Access, Coding, Microsoft Corp., txtSearchString, MsgBox; Discussion threads 2008-06-13
Intellistation Z-Pro won't boot: I'm building up a server for a client using a barebones IBM Intellistation Z-Pro model 6221.I installed two good Xeon 2.6Ghz CPU'sand 2Gb of RAM..again tested and working.On startup I first get beep error code of2-2-3CMOS power failure and checksum checks failed. Then when the machine posts I get these...; Tags: Memory, Workstations, stonetree1@..., CMOS, IBM IntelliStation, error code; Discussion threads 2007-09-20
Intellistation Z-Pro won't boot: I'm building a new workstation from a barbones IBM Intellistaton Z-Pro. I installed dual 2.6GhzXeons and 2Gb RAM all tested and working. On startup I get a beep error code of 2-2-3: CMOSpower failure and checksum checks failed. It then starts to post and reports the followingerror codes: 162: Invalid...; Tags: Memory, Workstations, stonetree1@..., CMOS, error code, IBM IntelliStation; Discussion threads 2007-09-21
IBM Intellistation Z-Pro Won't Boot!!: I'm building a workstation from a barbones IBM Intellistaton Z-Pro. I installed dual 2.6Ghz Xeons and 2Gb RAM all tested and working. On startup I get a beep error code of 2-2-3: CMOS power failure and checksum checks failed. It then starts to post and reports the followingerror codes: 162:...; Tags: Memory, Workstations, stonetree1@..., CMOS, error code, IBM Corp., IBM IntelliStation; Discussion threads 2007-09-27
Cisco 2611 DSL problem: I am trying to connect to SBC dsl using a Cisco 2611 router, I created my dialer and it tries to connect and is unable to. I used the Debug ppp Authentication command and can watch it dial out and I receive the authentication failed. I will copy and paste...; Tags: NETWORKING, citydave@..., Cisco Systems Inc., PAP, PPP; Discussion threads 2007-08-10
Cannot Copy Error: I am in the process of creating a VBSCript that creates a folder and then copies files from one folder on my C drive to the new folder created on my C drive. When trying to copy or move the files I get a "Cannot Copy: Access is Denied,...; Tags: husweety@..., strMonth End, strDay End, strFolderName, strDay, strMonth; Discussion threads 2007-09-24
Scripting: Looking for a script that will rename and change password on all of the local administrators user accounts. I can do this through GPO I know, but I want to run this particular script on a list of servers without having to reboot. I have found a couple...; Tags: arrSubAut, BlitzSonik, bSID, CStr, err.description, Hex, oUser.objectSID, password, security; Q&A 2005-05-19
Using software installed on old hard drive: My old emachine crashed last night. I have a temporary laptop replacement but I would like to use software on my old hard drive as an external drive. I assume I can use an external drive with an appropriate enclosure. The question: Is there any way I can...; Tags: modemjunkie, software, hard drive; Discussion threads 2007-04-10
Sorting character strings using SQL Server: You are probably familiar with the built-in sorting abilities of SQL Server for columnar data, but what if you need to sort character strings stored in SQL Server fields?Â Even thoughÂ this may not be a common need for most users, this issue may come up from time to time. I'll demonstrate...; Tags: Algorithm, Function, Microsoft SQL Server, Server, String, Character, VARCHAR, Tim, Engineering, Databases, Enterprise Software, Software, Data Management, Tim Chapman; Blog posts 2008-03-03
DOWNLOADING XP STARTUP TO FLOPPIES: I HAVE BEEN TRYING TO DOWNLOAD XP STARTUP ONTO FLOPPIES.THE ADS ON MS SITE AND OTHERS SAY THIS IS FOR COMPUTERS WITHOUT CD ROM AND THAT IT IS DEFINITELY SUPPOSED TO LOAD ONTO FLOPPIES.IT JUST WON'T HAPPEN. JUST KEEPS SAYING THE FILE'S TOO LARGE FOR FLOPPIES.PERVERSELY, I DOWNLOADED XP PRO...; Tags: Windows XP Startup Disk, floppy disk, Microsoft Windows XP, disk, startup disk; Discussion threads 2008-03-18
Move Email To Folder: Hi,I am trying to create a VBA to run in Outlook to move email to a folder by the email DomainNAme. Can anyone help?Re: VBA to run in Outlook to move email to a folder.This is easily done using the script below. Follow these instructions to set up...; Tags: Microsoft development tools, e-mail, szPath, szDir; Discussion threads 2008-09-29
Create DSN to SQL server: Hi,I have a Access database (2003) that is linked to the SQl server, through upsizing.I made a new table on the sqlserver and linked it to my access database.Therefor I needed to make an user dsn or System DSn. When I copy the database to another computer the one link...; Tags: Databases, Storage, String Dim, Microsoft SQL Server, database, System DSN, server; Discussion threads 2008-11-04
"Automatic" Set Focus based on field length: I have a user who finds it inconvenient to or to get to the next field on a form. The first field must be 12 characters long. I have tried: Private Sub txtEmpNum_ChangeIf Len(Me!txtEmpNum) = 12 Then Me!txtDeviceID.SetFocusEnd SubBut the field length doesn't seem to be...; Discussion threads 2008-06-24

<< Previous
page 1 of 1
Next >>

Quick Reference: PC Troubleshooting Pack: Help desk and IT support professionals need the fastest and most complete answers to keep every PC in action. Get the PC troubleshooting solutions you ...; Buy Now

Microsoft Word Crash Course: This pre-packaged presentation contains everything you need to instruct end users about how to get the most out of Microsoft Word -- even if you don't consider yourself a public speaker.; Buy Now

len.chabot@...

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Additional Resources

CIO Sessions