Show All Related Tags
Did you mean
Texas Instruments Inc. (51 results), instrument (36 results), instruction (18 results), instrumentation (9 results), Network Instruments (8 results)more...
Show Fewer Related Tags
Did you mean
Texas Instruments Inc. (51 results), instrument (36 results), instruction (18 results), instrumentation (9 results), Network Instruments (8 results), National Instruments Corp. (4 results), financial instrument (4 results), mainstream (1 results)fewer...
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- sql:find domainname
- I want to extract a domainname from an emailaddress by sql from an sql database (the name after the '@'). By example: hotmail.com The addressfield is textbased. How can i achieve this?something likeGiven it's X@Y.ZSelect Substr([emailaddress],Instr([emailaddress],'@'),DataLength([EmailAddress]) - Instr([emailaddress],'@'))From ContactsNote assumes emailaddress is a varchar, DataLength would return fieldwidth for char...
- Discussion threads 2007-07-26
- Find Similiar MS Access Records
- When I try to execute the following VB I get a complie error:Invalid use of key word meCan any help?ThanksPrivate Sub cmdProcess_Click On Error GoTo err_end Dim conn As ADODB.Connection Set conn = CurrentProject.Connection Dim ssq1 As String Dim ssq2 As String Dim ssq3 As String Dim rs As New...
- Discussion threads 2007-01-11
- VB File Copy script failing
- Can anyone otut there tell me why this ain't working? The echo's are so I could see how far it was getting. I have a 'Expected If' error but have had all sorts. Need to be able to pass it the filename from the command line. ...
- Q&A 2006-06-28
- 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...
- Q&A 2006-01-22
- Prevent bugs by filtering input in VB6
- Slight improvementIn the first couple of conditional statements, you wisely used ASC(".") and ASC("-") instead of hard coding the numerics to check for valid characters. This same method should be done on the last conditional to maintain the flexibility and readability of the code.That is, the lineElseIf key...
- Discussion threads 2005-06-17
- MS Project - iif this can be done?
- I want to create in MS Project a formula in a custom field to test for the existance of certain resources. This works fine:iif([Resource Names] = "Technician","Yes","No")The problem is it will only pick up the resource if it is the only one. If Technician is allocated with another...
- Discussion threads 2005-05-12
- Split String in VB .net ?
- Hi..I have the following string :-E:VB.NET PROJECTSERPbinI want to get the path :-E:VB.NET PROJECTSERPHow this is possible..How to remove "bin" from my string ?Pl. guide..Left$ or Mid$ should do it if its always going to beE:VB.NET PROJECTSERP at the startIf this could vary then look up INSTR which will give...
- Q&A 2005-04-26
- 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...
- Q&A 2005-03-01
Additional Resources
- Access 2000 Delete Select Record
- I have a table where a field is Text format.The values in the field can be numbers and text.How would I delete only records that have a text value.Thanks for the solution, it helped me a great deal....This question was closed by the authorThat's going to be a pain.instr (http://www.techonthenet.com/access/functions/string/instr.php)might...
- Q&A 2006-04-27
- Modify .ini files to reflect system-side updates with this admin script
- Admin scriptsWhat do you think of Kurt's script? Do you have a script that we'd be willing to pay you $100 for?Very NiceA documented admin script!!! BooYah!!An immediate use comes to mind.Thanks(I mistakenly panned it initially, after trying to cut'n'paste from the AcroReade download.)Is there a downloads section where we...
- Discussion threads 2005-10-13
- ACCESS 2000 LINKED TABLE
- Can anyone tell me how to link to a table in another database that may get moved and automatically update link. Both databases will stay together in the same directory, but the two of them will get moved occasionally.ThanksCall the following function either as an Autoexec macro or as an...
- Q&A 2005-03-08
- Simulate variable arguments in PL/SQL
- Variable IN ListOften, we need to pass variable arguments to "IN" clause. The most used workaround is to pass a string and split it inside PL/SQL to create a table that can be used as the expression for IN clause. This has a no. of limitations - e.g., it affects...
- Discussion threads 2005-06-15
- 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...
- Q&A 2005-05-26
- Invalid procedure call or argument: left
- I am using an ASP page running on IIS6 using VBScript as the programming language. I am trying to display the first part of body text from a freetext field as part of a news headline section on the home page. The code I have is: if not isnull(objRSNews("tblNewsTitle")) or objRSNews("tblNewsTitle")""...
- Q&A 2005-02-02
- How to remove network printers via a VBS script?
- Hi all,I need to create a VBS logon script for users here to remove network printer conncections if they exist for a user's AD account. I've figured out how to add network printer connections, but I've run into a brick wall with removing them. I'd like the script to remove...
- Q&A 2005-03-30
- Drive Label Says Network Drive
- Here's the snippet of code I'm using:If InStr(strGroup, lcase(Staff_Group)) Then objNetwork.MapNetworkDrive "H:","\blahGeneral" objShell.NameSpace("H:").Self.Name = "General"Now when I login as someone in the Staff Group and I open windows explorer I for a share name I see "Network Drive (H:)" rather then "General (H:)" any ideas why?Thanks for the help.-Chris Matera
- Discussion threads 2007-01-17
- Normalizing spaces in VB6 strings
- The term normalizing spaces refers to removing excess spaces in a string. If you're working with a text processing routine in VB6 that requires you to normalize spaces, check out this code sample and see how easy it is to accomplish this task. In VB6, the phrase "normalizing spaces"...
- Technical articles 2005-10-13
- VB Login Script Help needed
- Please forgive me, but i'm extremely new to VBScript. I need to write a login script to map drives based on group membership in a windows 2003 AD Domain. I've found numerous examples all over the net, but none of them has seemed to work properly for me.Here...
- Discussion threads 2006-10-18
- MCSE and VMWare Help
- Yip, a newbie! and need help please!Have just purchased dualcore dell desktop and loaded VMWare evaluation copy onto it.Have started my MCSE at home studying, and have run into a little glitch, which me being new is probably not that serious :-) and that where your help will be most...
- Q&A 2006-10-05
- An Access delete query with a composite key.
- I ran into a little problem with a project of mine. I need to run a delete query, called up by a form, to delete records using a composite key. I can't find the syntax for this anywhere.The form has a text box for entry of the Last...
- Discussion threads 2006-08-15
- << Previous
- page 1 of 1
- Next >>
