On The Insider: Paris Says Palin Has a Hot Bod
1 Resources for

string dim strcriteria

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

dao.recordset.FindFirst
I have a syntex errormissing operator in expression for the FindFirst statement in following code which run in access form vba routineOption ExplicitPrivate Sub Form_Load On Error GoTo errAddNode Const strTableQueryName = "Quantity" Dim db As DAO.Database,...
Tags: strParentField, DAO.Recordset Dim strParentField, String Dim strCriteria
Q&A 2005-07-29

Additional Resources

Error 1026 Using SHFileOperation
I am using SHFileOperation to copy some files from an Install CD to the Target folder. The program works fine on W2K and XP, but under W98, I get a File System Error (1026).I know that this Function needs to have the Null characters added properly, & I have done...
Tags: Error 1026 Using SHFileOperation, Long Dim, icscomputersaz@..., programming, SHFileOperation, String, String Dim
Discussion threads 2005-01-26
Split String
Dear all,I want to split a string into twoparts.How to do it?For example, If I assigned variable called usrnm having string "QWUSM0392".But I want to split into two parts or I need only "M0392" from the string.How can I get it?Will Mid or Replace function help for this?Please help...
Tags: bsmgopal1984@..., programming, String
Q&A 2006-07-30
Replacing a full string in VB.net
I have a hangman project to do for school and I can't figure out how to parse through the whole string and replace it with a character like " * "I wanna replace every character in the word with "*". So far I only replaced the whole word with...
Tags: polishthug@..., Microsoft Visual Basic.Net, hangman, String Dim
Discussion threads 2007-08-22
Using VBScript to send printout to printer
I have the a printer that connect to one of the computer in the network, and I have the other computer running the Proficy Ifix SCADA. The SCADA machine have build-in Scheduler, and the script below works if the scheduler running in the Forground and will not work if...
Tags: Printers, Enterprise software, bobbyhoangvu@..., String Dim, printer
Discussion threads 2007-04-23
Split String
Dear all,I want to split a string into twoparts.How to do it?For example, If I assigned variable called usrnm having string "QWUSM0392".But I want to split into two parts or I need only "M0392" from the string.How can I get it?Will Mid or Replace function help for this?Actually I am...
Tags: QWUS\M0392, Split String, bsmgopal1984@..., programming, String
Q&A 2006-07-30
visual basic challenge
hi, i am developing a application in which i want to give a area in which user can draw a image and sava it to database with its id.please solve my prblem as soon as possilble.use the doodle example that comes with VB and study up on ADODB. here...
Tags: Doctor List, String Dim, sudeep_395@..., programming, String
Q&A 2005-03-19
VBA Expert..urgent help
****** Following code giving run time error 438 *** how to fix that error..pls help..its urgent'Dim Cell As RangeDim myWord As ObjectDim PathDocu As String Set myWord = CreateObject("word.application") 'Set myWord = GetObject(,
Tags: fanku@..., myWord.ActiveDocument.Bookmarks, programming, software, VBA
Discussion threads 2006-11-03
VBA Expert..urgent help
****** Following code giving run time error 438 *** how to fix that error..pls help..its urgent'Dim Cell As RangeDim myWord As ObjectDim PathDocu As String Set myWord = CreateObject("word.application") 'Set myWord = GetObject(,
Tags: fanku@..., myWord.ActiveDocument.Bookmarks, programming, software, VBA
Discussion threads 2006-11-03
update,delete,cancel buttons in datagrid using vb.net....
can anybody plz tell m -whats the error in the code for update button in datagrid-where table name is "table1"its has fields "ID","Name","Age","Sex","Area"..in the code its giving error has::----------------------c:inetpubwwwrootsampleprj1WebForm1.aspx.vb(151): 'Textbox' is ambiguous, imported from the namespaces or types 'System.Web.UI.WebControls, System.Windows.Forms'.------------------------------The code is as followsProtected Sub datagrid1_UpdateCommand(ByVal source As Object, ByVal...
Tags: preethams_venkatesh4@..., TextBox, CType
Discussion threads 2007-06-06
urgent help from VBA Expert
'Dim Cell As RangeDim myWord As ObjectDim PathDocu As String Set myWord = CreateObject("word.application") 'Set myWord = GetObject(, "Word.Application") Set myWord = GetObject("g:globalmaheshoffer letter.doc") myW
Tags: fanku@..., myWord.ActiveDocument.Bookmarks, programming, software, VBA
Discussion threads 2006-11-03
Learn the best way to combine strings in VB.NET
Irina Medvinskaya explains why you should usually opt for using the & operator over the + operator to combine strings. She also provides a simple example of how to combine stings in VB.NET. Combining strings in VB.NET is a simple operation. You can utilize the & operator to...
Tags: Microsoft Visual Basic.Net, Irina Medvinskaya, Microsoft development tools, Programming languages, .NET, strNameFirst & strNameLast, Visual Basic Tips Newsletter, String, Development Tools, Software Development, Software/Web Development
Technical articles 2006-05-25
Autonumber the workbooks in folder
i have this macro added in excel, this macro prints the excel files one by one in a specified folder, thsi works finethe problem is that i need to add the increment number in all the workbooks( suppose i have 200 workbooks, i need to add 1, 2 , 3...
Tags: get2santosh@..., sFile, UBound, String Dim, workbook
Discussion threads 2007-07-28
autonumber the workbook header
i have this macro added in excel, this macro prints the excel files one by one in a specified folder this works finethe problem is that i need to add the increment number in all the workbook header( suppose i have 200 workbooks, i need to add 1, 2 ,...
Tags: get2santosh@..., sFile, UBound, String Dim
Discussion threads 2007-07-28
Using Activex control inet
I have written an MS access module that uses the inet activex control to ftp a file from one of our mainframes to a pc.The file is a consecutive file with a record lenght of 350 chars. If I use ftp through the dos prompt the file downloads fine....
Tags: char, Bentz, programming, String, String Dim
Q&A 2005-07-26
How to generate random letters in vb6.0
Hi Just wondering how I would generate random letters in VB 6.0?CheersMarkUse Rnd to get a number from 0 to 1. Multiply by 25, add 1, round to nearest integer. Convert 1 to A, 2 to B, etc.Mark, try this out.....Private Sub MakeRandomDim theNum As DoubleDim theUpper As StringDim theLower...
Tags: random letter, Asc, Rnd, markjenkins74@..., programming, Use Rnd
Q&A 2006-05-25
Sql Quriery in Visual Basic
Software DeveloperADODBYou need to use ADO DB ActiveX Data Objects components to use sqle.g.Dim con as new ADODB.ConnectionDim cmd as new ADODB.CommandDim recs as new ADODB.RecordsetSet con=Open "connection string"cmd.ActiveConnection = concmd.CommandText="Select * from MyTable"Set recs = cmd.Execute
Tags: Programming languages, amolsuryansh@..., SQL, Microsoft Visual Basic
Discussion threads 2007-10-03
How to check if a File Exists
Hello, I am just starting to get into VBA and have come across the need to write some VB code that checks for a file and then needs to delete that file. I have been reading up on FSO but I must be missing something as I can not...
Tags: POSTER, End Function, String, Try This
Q&A 2005-06-01
Code runs but doesn't save the file
I have a file which opens in one directory and when closed the user is presented with a different directory to save in.The code attached lets me present the user with the proper name, allows you to click all of the right buttons but doesn't save the file.if I click...
Tags: rroylance@..., Dim sQ, sFileName
Discussion threads 2007-07-25
Number of records in a table with VBA
How can I determine the number of records in a table programmatically using VBA?This is crude, bu it works...Function NumberOfRecordssTableName as String as integer Dim MyRecordset As RecordsetDim MyQueryDef As QueryDefDim MySQL As StringNumberOfRecords = 0On Error GoTo ErrHandlerSet MyQueryDef = NothingSet MyRecordset = NothingMySQL = "SELECT * FROM "...
Tags: darrellrisley@..., software, Error, String, Nothing, Set MyRecordset, VBA
Q&A 2006-09-13
  • << Previous
  • page 1 of 1
  • Next >>


Windows XP vs. Mac OS X
This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...
Buy Now
Lock Down the IT Department
Safeguarding your company's systems and information assets requires vigilance on many fronts, but it's difficult to stay on top of every vulnerability ...
Buy Now