Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Commondialog in VB6
- how do i use commondialog in VB6 for the openfiledialog function?I tried to program it as below, but didnt work.Dim openFile As New Commondialogcommondialog.showopenbut I do not get commondialog class from IDE and get a syntax error at the Dim openfile.... line-TIAMparamDIM var as New typevar.methodas inDim MyLabel as New...
- Tags: Label
- Q&A 2005-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
- 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
- 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
- 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
- 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
- Deleting Reg Key
- I need to delete a registry keys through a login script . I am not sure I have the right syntax.=========================================DelRegKey.vbs'' This script should handle deleting a registry key which may, or may not, exist' and does, or does not, have subkeys.Option ExplicitConst HKEY_CURRENT_USER = &H80000001Dim strComputerDim strKeyDim strValueNameDim strValueDim...
- Tags: aSubKeys, ByVal strKey, Deleting Reg Key, networking, rocky5689, strKey, strKey End, vbs, Wscript.Echo
- Discussion threads 2006-01-11
- Windows assigning drive letters
- I have mapped a network drive and used the letter F but now every time I connect a usb device it assigns the usb device the letter F so I can't access it unless I go in to disk management and change the drive letter of the usb device, is...
- Tags: Microsoft Windows, deerek11@..., network, usb device, CreateObject
- Discussion threads 2007-07-26
- 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
- Visual Basic 6.0 help
- I'm getting an error Run time error '6' overflow. Help me!! Tell me what's wrong.Private Sub cmdbutton_ClickDim population As IntegerDim years As Integeryears = 0population = 6000000Do While population > 10000000population = population * 0.014years = years + 1LooppicWhen.Print "In"; years; "Population will be"; population;End SubDear Friend,It is very...
- Tags: dodotwilson@..., it management, Microsoft Visual Basic, Microsoft Visual Basic 6.0
- Discussion threads 2004-10-20
- 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
- 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
- Error "Macro Not found" VB - Urgent Help
- xlApp.Run "SetparentForm", Me while executing the above line in the Windows XP,we are getting error Macro "Setparentform" not found.But the same piece of code gets executed in the NT machine.SetParentForm is property in the excel vba.The macro call works fine the very first time and will not work later....help is...
- Tags: bhaskar.bhaskar@..., Macro, Microsoft Visual Basic, programming, SetparentForm
- Discussion threads 2005-01-26
- 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
- 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...
- Tags: GW0001, LL, Microsoft Access, software, tbl.Connect
- Q&A 2005-03-08
- 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
- 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
- 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
- How can I schedule a autologon script to run at a specific time and date
- I have the following script that I need to run at a specific time and date. Can anyone help me with this? Here is the script.Option Explicit'''Declarations'''Dim objShellDim RegLocAutoLogonDim keyDefaultDomainNameDim valDefaultDomainNameDim keyDefaultUserNameDim valDefaultUserNameDim keyDisableCADDim valDisableCADDim keyAutoAdminLogonDim valAutoAdminLogonDim keyForceAutoLogonDim valForceAutoLogonDim keyDefaultPasswordDim valDefaultPassword''''Define keys and values''''RegLocAutoLogon = "HKLMSoftwareMicrosoft" & _"Windows NTCurrentVersionWinlogon"keyDefaultDomainName =...
- Tags: bigdog4579@..., RegLocAutoLogon, REG_SZ
- Discussion threads 2007-06-28
- << Previous
- page 1 of 1
- Next >>