Sponsored White Papers, Webcasts, and Downloads
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
- We the Robots Issue 1 1.0 (Mobile)
- We the Robots takes place in a world just like ours...only with ROBOTS! LAUGH at their feeble attempts to negotiate a complex society without benefit of free will or self-knowledge! CRY as they make important decisions based purely on pre-programmed fear and suspicion! FEEL UNCOMFORTABLE as you watch them endure...
- Tags: Mobile, Apple iTunes, UCLICK LLC, Robots, Digital Music, Digital Media, Emerging Technologies, Personal Technology, Consumer Electronics
- Software downloads 2008-12-12
- 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
- Book review: Rain Making: The Professional's Guide to Attracting New Clients
- Trainers typically don't think they need to know marketing fundamentals. Contrary to that popular opinion, marketing is essential to the success of your training career and business. Bob Potemski reviews a book that you'll find to be a keeper for your library collection.Today's business environment is markedly different. Magazines testify...
- Tags: Marketing research, Bob Potemski, marketing, Ford Harding, Rain Making
- Technical articles 1999-10-22
- 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
- WMI: Output to a file
- HI, Does anyone knows how to output the data to a file in the script below? I tried to find info on this but so far no luck. Thanks.-------------------------------------Option ExplicitDim strComputer, strKey, strSubKeyDim objRegistryDim arrSubKeysDim strDisplayName, strDisplayVersion, strInstallLocationConst HKEY_LOCAL_MACHINE = &H80000002strComputer = "."strKey = "SOFTWAREMicrosoftWindowsCurrentVersionUninstall"'*'* CALLOUT A'*Set objRegistry = GetObject("winmgmts:"...
- Tags: programming, psvoboda@..., strKey, strSubKey, strSubKey Dim objRegistry Dim arrSubKeys, WMI
- Q&A 2005-04-21
- << Previous
- page 1 of 1
- Next >>
What it takes to stay on the edge of innovation
Going green and managing costs during tough economic times
Taking chances with the core brand
Transforming the company and developing new delivery platforms