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 bkrike 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: SwordMonkey
- Content: Threads
- Order by date
-
Inner Join property not found...
Dim stDocName As String stDocName = "rpt_rev_sum" Dim db As Database Dim dbf As QueryDef Dim records As DAO.Recordset Dim BPDef As TableDef Dim BPRecs As DAO.Recordset Dim period As Long Dim strQry As String Set db = CurrentDb()...- SwordMonkey
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Problem running query with VBA
OK, I'm a little stumped. Here's the code: Dim stDocName As String stDocName = "rpt_rev_sum" Dim db As Database Dim dbf As QueryDef Dim records As Recordset Dim startdt As Date Dim enddt As Date Set db = CurrentDb() Set dbf =...- SwordMonkey
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Convert range of text to number in VBA?
I'm importing some ID's from an Oracle DB into Excel. They come over alright, but when I go into the spreadsheet, there's a little ! next to the cells and says "Number stored as Text" I can then manually convert these to Numbers which fixes the problem. However, I'd like to know if...- SwordMonkey
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
