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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Larryboybird
- Order by date
-
Use code to close a program
This Code Works for me when I want to close the program I am in. Sub CloseProgram Dim I As Integer, j As Integer j = Forms.Count - 1 For I = j To 0 Step -1 Unload Forms(I) Next End Sub- Larryboybird
- Post #3
- Forum: Visual Basic (Classic)
-
ActiveWorkbook.Path ???
This works for Me! Private Sub PrintOpenExcelFiles() Dim oXL As Excel.Application, I1 As Integer Set oXL = GetObject(, "Excel.Application") With oXL I1 = .Workbooks.Count While I1 > 0 S1 = .Workbooks(I1).Path If Right(S1, 1) <> "\" Then S1 = S1 +...- Larryboybird
- Post #5
- Forum: Visual Basic (Classic)
-
Using NOT or <> in a query
Change your code like this and the value you are evaluating will never be null! ([Accident Data].[CD Code] & "")- Larryboybird
- Post #4
- Forum: Microsoft: Access Other topics
