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
- 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
- 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
- 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
- Can you have more than 3 conditional formats in Excel?
- Excel allows for only 3 conditional formats - that I can see. I have a client who wants to know if you can have more than 3 conditional formats to a worksheet. Anyone have any ideas?With VBA, conditional formats are unlimitedI have researched this issue at great length....
- Tags: Cell, conditional format, conditional formatting, CurrentCol, excel, Integer Dim CurrentCol, Integer Dim CurrentRow, kz2000@..., Microsoft Excel, programming
- Discussion threads 2005-11-21
- Cell keyboard entry problem
- For some reason the program (Beta 2TR) refuses to accept keyboard entries beyond Lenany data type=1. For example, given variable for entry "123...n" - "1" is entered and when the next character, "2" is keyed in "2" replaces the "1" and so on leaving a final entry of "n"....
- Tags: Cell, excell cell entry problem, keyboard, software, ted-p@...
- Discussion threads 2007-01-11
- VBA DATE FORMAT VALIDATION
- I have a macro that has a number of application input boxes requesting a user to key data into specific fields in a workbook. There are about 6 that request dates and I want to validate the format of the date the user is inputting to stop them keying in...
- Tags: ActiveCell.FormulaR1C1, david_j_will@..., NUMBERDATE, NUMBERTEXT, Select NUMBERTEXT, software, VBA
- Q&A 2005-08-01
- Help with vb / getting info from HTML
- I need to be able to pull information from an html web site and pull that information into a Visual Basic App.Such as pulling the Temperature off of the Noaa web site ??? any help Appreciated.Point value changed by question poster.You want to post the local temperature on your intranet?You...
- Tags: HTML, InStr, palmc@..., programming, SHTML
- Q&A 2006-01-22
- Can't see pictures in E-Mails
- I'm running Office 2003 and when I get a e-mail with a picture in it, it is always Xed out!! I have loked at the options and looked at them and can't figure out what should be checked or shouldn't be checked! Tried everything, at least I think I have!!HELP!!...
- Tags: bratnell@..., e-mail, software
- Q&A 2005-02-09
- Send an e-mail from a table in Access without switching to an e-mail client
- emails from AccessI would like to send a form letter from Access to a group of people identified in the database with a personalized touch by adding their name to the form letter and a field from a table. How can I do this?ResponseAdd this code to a module...
- Tags: access, Add, aston@..., AttachmentPath, e-mail, emails, form letters, hardware, Microsoft Access, Set objOutlookRecip, sRecipientCC, String
- Discussion threads 2005-09-07
- Access Forms in XP
- Field in database requires Vehicle VIN#'s - want a message to pop up on the form for that field to ask if the data is correct if under 17 characters.The field is a maximum of 17 digits, but depending on the type of vehicle it could be less.for the On...
- Tags: Access Forms, LF King, Microsoft Access, Microsoft Windows XP, software
- Q&A 2004-12-08
- Build temporary tables to optimize SQL queries
- Learn how to build a table from a list of values and join the table to the target table. You'll also discover how to build the temporary table to hold the values. Applications often present a way to allow a user to select a number of values. These...
- Tags: Databases, Arthur Fuller, SQL Server Newsletter, TechRepublic Inc., SQL, Table, SET, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-26
- Royal Sonesta Hotel Enhances Art Collection With Wireless, HP iPAQ Pocket PC-Enabled Tour
- Royal Sonesta Hotel Boston is known widely for its longstanding commitment to the arts. Newbury Networks Inc., a software solutions provider specializing in WLANs - and a frequent HP partner - suggested the hotel use its wireless capabilities to add value for guests, increase access to information and enhance the...
- Tags: Hewlett-Packard Co., PC, Sonesta Hotel, Royal Sonesta Hotel Boston, Wi-Fi, Wireless LANs, Wireless, LANs, Networking
- Case studies
- << Previous
- page 1 of 1
- Next >>
