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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running SELECT statement in VBA
I have an Access form where a user enters a value into a text field. I can get this value through VBA no problem. However, I want to run a check on this value. How can I run a SELECT statement in VBA code. What I want to do is the following: SELECT COUNT(Records) FROM Table WHERE Records =...- bishman
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Split function in Access 97
I've got some VBA code in an Access 2000 database that works fine. However, when I convert it to Access 97 one of the functions I've used (Split) fails. The code is: monthAndYear = "April 2003" month = Split(monthAndYear, " ") This gives month a value of...- bishman
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Opening report based on drop down selection
Hi Here's some Access VBA: Dim found As Boolean Dim frm As Form found = False For Each frm In Forms If frm.Name = "SelectType" Then found = True End If Next strReportType = Forms!SelectType!ReportTypeCombo.Value Now depending on what has been chosen...- bishman
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
Opening report based on drop down selection
Hi Here's some Access VBA: Dim found As Boolean Dim frm As Form found = False For Each frm In Forms If frm.Name = "SelectType" Then found = True End If Next strReportType = Forms!SelectType!ReportTypeCombo.Value Now depending on what has been chosen...- bishman
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Summing fields depending on other field values
Hi, First post here - please be gentle! I've got some VBA code that outputs some results as follows into an Excel sheet: Name Class Grade Grade total John Biology 80 John Biology 76 John Maths 65 John...- bishman
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
