1 Resources for

variant dim spath

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

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...; Tags: ByVal FieldValue, DirName, File, InStr, Maricaibo, Microsoft Access, programming, SELECT Left, Variant Dim sPath; Q&A 2005-03-01

Additional Resources

Gain data storage flexibility in VB6 with dynamic arrays: too simplifiedThis article should be fuller to show that redimming 2-dim arrays is MUCH more cumbersome and has severe limitations such that the first dimension cannot be redimmed. ( I guess that's why MS put the .GetRows in the recordset to account for that).I do:Dim arData as variantRedim arData(10,1) ...; Tags: data storage, Microsoft Visual Basic 6.0, programming, storage, tjc_tek@..., vb6, vb6 arrays; Discussion threads 2005-07-01
Access - form to sub form automatic entry: I'm trying to refine my Invoice Tracking program to have to vendor name automaticly entered on the parts sub form. Made a text box on the subform and clicked on the table line in the data box to the vendor table on the sub form. Then tried [Form]![Name...; Tags: access, automatic entry, form to sub form, Goto, Microsoft Access, ricky4143@..., software, vName; Discussion threads 2005-12-03
Comparing Double vs. Single data types in VB6: Decimal datatype claimPeter,I must disagree with your Decimal datatype claim that "unfortunately, it was never actually implemented." It and the scaled integer datatype, Currency, are actually variant objects that behave as a particular datatype. As such, they don't perform as well as the intrinsic numeric data types.===================================Try the...; Tags: aikimark@..., CDec, datatype, Microsoft Visual Basic 6.0, programming, vb; Discussion threads 2005-12-02
MSAccess Refresh Active record: Hello all. I would like to ask if anyone knows how i can refresh my form without the focus being changed to the first record, essentially refreshing the form and subform while keeping my cirrent record as the active record.I am entering data into a form, I have a command...; Tags: jim@..., Dim Buckets; Discussion threads 2007-07-17

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
Can you please help me to run this script. I am finding difficulties: Public Function ISOWeekNum(AnyDate As Date, _ Optional WhichFormat As Variant) As Integer'' WhichFormat: missing or 2 then returns week number,' = 2 then YYWW'Dim ThisYear As IntegerDim PreviousYearStart As DateDim ThisYearStart As...; Tags: Kamlesh_waghela2000@..., AnyDate, Date Dim YearNum; Discussion threads 2007-08-04
Help me to run this script in excel: Public Function ISOWeekNum(AnyDate As Date, _ Optional WhichFormat As Variant) As Integer'' WhichFormat: missing or 2 then returns week number,' = 2 then YYWW'Dim ThisYear As IntegerDim PreviousYearStart As DateDim ThisYearStart As...; Tags: Kamlesh_waghela2000@..., AnyDate, Date Dim YearNum, Dim ThisYear; Discussion threads 2007-08-04
Please help me run this script in excel.: Public Function ISOWeekNum(AnyDate As Date, _ Optional WhichFormat As Variant) As Integer'' WhichFormat: missing or 2 then returns week number,' = 2 then YYWW'Dim ThisYear As IntegerDim PreviousYearStart As DateDim ThisYearStart As...; Tags: Kamlesh_waghela2000@..., AnyDate, Date Dim YearNum, Dim ThisYear; Discussion threads 2007-08-04
Define VB6 procedure arguments with the ParamArray keyword: In times when you don't know how many arguments will be passed to a procedure, you might want to think about using the ParamArray keyword. Learn how to use ParamArray in this VB6 tip. In some situations, you may not know ahead of time exactly how many arguments...; Tags: Microsoft Visual Basic 6.0, ParamArray, Peter Aitken, Visual Basic Tips Newsletter, Argument, Corporate Communications, Microsoft Development Tools, Programming Languages, Marketing, Development Tools, Software Development, Software/Web Development; Technical articles 2005-09-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
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
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
My autologon script won't when scheduled to run at startup.: I am using the following script to auto logon about 20 stand alone xp workstations not attached to a server which all have deep freeze installed on them. I need to be able to auto logon to the workstations so I can run applications. Does anyone know a way I...; Tags: bigdog4579@..., RegLocAutoLogon, REG_SZ; Discussion threads 2007-06-28
Dim the variables: In VBA under Access (A2K) when IDim myStr AsString------------^- no space as you did in your code listing - it throws a error. Same for your second variable; Tags: Scripting languages, ray.learmond@...; Discussion threads 2007-05-18
Get the most out of Variants in VB6: VB6's Variant data type is able to hold any other data type, including numbers, strings, dates, and object references. Check out a couple of useful tricks for using Variants. Visual Basic 6's Variant data type is able to hold any other data type, including numbers, strings, dates, and...; Tags: Microsoft Visual Basic 6.0, Peter Aitken, Microsoft development tools, Visual Basic Tips Newsletter, TechRepublic Inc., Data, Value, Variant, Programming Languages, Corporate Communications, Development Tools, Software Development, Software/Web Development, Marketing; Technical articles 2005-09-15
monitor is dim: I have a HP ZV5000 pavilion laptop. When the a/c adapter was plugged in, the screen was bright and if I worked directly off the battery the screen would be dim. Now from out of nowhere, when the a/c adapter is plugged in, the screen is very dim...; Tags: dlwojo@..., monitor, A/C adapter, A/C, adapter; Discussion threads 2007-08-29
Halo 3 Spartan C.Q.B. Variant 3D screenshot (zip): This is a three-dimensional screenshot featuring the Spartan MJOLNIR/C variant that allows for user-controlled rotation using Quicktime.; Tags: 3D, Variant, Screenshot, Digital Music, Digital Media, Personal Technology, Consumer Electronics; Software downloads 2007-09-21

<< Previous
page 1 of 1
Next >>

Microsoft Excel Intermediate Skills: This Microsoft Excel Intermediate Skills presentation is a preformatted solution for training staff to get more out of Microsoft Excel. The accompanyi ...; Buy Now

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now