Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Default Path for shellapplication.BrowseForFolder??
I don't know if this helps but this is what I use. BrowsFolder = Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE " & "YOUR FILE PATH", vbNormalFocus YOUR FILE PATH= the path to the folder you would like to open.- Gravins
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Connecting to A/S 400 with ADO
Here you go. Here is the way I use it in my code: Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim cmd As ADODB.Command Dim cnndb As ADODB.Connection Dim rstdb As ADODB.Recordset Dim var As Variant Dim i As Long 'Get Plants Set cnn = New ADODB.Connection cnn.Open...- Gravins
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Automated Function Calls
Hello All, I currently have a large Access database that needs to be updated daily. The updating process consists of logging on to several servers and then consolidating key data within this database. Would there be code that would automate this process to run at 7:00 before I get to work? Just...- Gravins
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
