Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- VBA Using Access Form with SQL Data
- I am trying to figure out why the below VB Code is not working. I do not get any errors just an hour glass for a few seconds and then nothing. I tested the SQL script and it returns the correct data. I also tested the VB...
- Tags: Error GoTo Err_RDPSystemInfo_Click Dim WshShell Dim stAppName, programming, SQL, String stAppName, systeminformation, twhite@..., VBA
- Q&A 2005-08-03
- How do I... Fill Word form fields with Access data?
- How do I... Populate Access data with Word fields?Is it possible to create an Access database from data entered into word form fields?Just what I've been trying to do... Now if only I could get it to workI've been using the script below with Office 2003 Professional to send...
- Tags: Word processors, Microsoft Office, Databases, charles.levea@..., Doc, Word.Application, Microsoft Access, Microsoft Word
- Discussion threads 2007-07-11
- Got an error with this script, cannot connect to computer...
- PLEASE HELP!!!The computer list was created manually.'-------------------------------------------------------------------------------' Initialization - Declare variables'-------------------------------------------------------------------------------Dim fsoIn, fsoOutDim inFile, outFileDim arrComputerNamesDim objUserDim strComputerDim newPasswordDim ErrorOccurredConst ForReading = 1Const ForWriting = 2Const ForAppending = 8Const inFilename = "computers.txt"Const outFilename = "ChangePwdcomputers.log"'-------------------------------------------------------------------------------' Main script'-------------------------------------------------------------------------------On Error Resume NextErrorOccurred = False' Insert WARNING here...Msgbox ("WARNING: This script will change...
- Tags: julliadarc@..., strComputer, password, Now & vbTab, newPassword Dim ErrorOccurred Const ForReading, outFile.writeline Now & vbTab, computer
- Discussion threads 2007-06-15
- Access 2000 Date Function
- All I wanted to do on a FORM was:If the date is null Not entered then enter the System Date. Here is ny code which for some reason WILL NOT recognize the Date Function...Private Sub Command12_ClickOn Error GoTo Err_Command12_Click‘ THIS SECTION DOES NOT WORKIf IsNull([Forms]![Form1]![Dates subform]![DateServ]) Then'[Forms]![Form1]![Dates subform]![DateServ] = #1/1/2222#...
- Tags: abramowitza@..., Form1, Forms, IBM Lotus Notes, Microsoft Access, MRA2, Notes Subform1, programming
- Q&A 2005-09-22
- Attach employee photo to database
- I want to link an employees photo to their record in MSAccess 2000. How can I do this?How to Link a Picture to an Access Form:Use an unbound image frame named: ImageFrameand add a field to your table called ImagePath.To add the picture to a report just use code like...
- Tags: database, dliby@..., ImagePath, Me!, photograph, Picture, software
- Q&A 2004-11-30
- 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
- Diskspace VBScript Help needed
- How do I edit this script so that it will output the diskspace for each computer?To run the script the syntax is cscript diskspace.vbs computernameHere is the code: On Error Resume NextConst CONVERSION_FACTOR = 1048576Const WARNING_THRESHOLD = 100If WScript.Arguments.Count = 0 Then Wscript.Echo "Usage: FirstScript.vbs server1 [server2] [server3] ..." WScript.QuitEnd...
- Tags: computer, Err.Number, keebmachine, Microsoft VBScript, programming, Wscript.Echo Computer
- Q&A 2004-12-10
- 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
- I can't use the Common Dialog Control for Ms_Access
- haiI need the clarification for Common Dialog Control in Ms-Access.am doing the Ms-Access application, in this application, i need to send and receive email. Now am doing the send mail, it's working fine. But the attachment is not working. Am using the coding for send mail as follows ...
- Tags: ActiveX/COM/COM+/DCOM, ttamilvanan81@..., ActiveX Control, Common Dialog Control, MS-Access, MsgBox, error message
- Discussion threads 2007-04-03
- MsgBox Enhanced (exe)
- Bored with the standard MsgBox provided by Windows? Purple Parrot MsgBoxEnhanced ActiveX DLL improves on the standard MsgBox by adding the ability to change colors, display a gradient pattern, control where the message box appears on the screen, a timer to have the message box automatically close, and many other...
- Tags: Purple Parrot MsgBoxEnhanced ActiveX DLL, Microsoft Windows, Operating Systems, Software
- Software downloads 2005-06-03
- 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
- 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]
