Search results for query: *

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 =...

Thanks Ben, that works a treat.

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...

Yes, that's exactly it...thanks so much.

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...

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...

Hi again Tony, Managed to sort this now. I have used your SUMIF suggestion, and am now dynamically contructing the SUMIF string within a loop in my VBA code, and pasting this string straight into the necessary cells in the "results" sheet. Thanks again, bishman

Hi Tony, Thanks for the quick reply. Unfortunately, each time the VBA is run, there will be a differing number of rows in the excel sheet. I would really like to be able to automate this process from VBA. Is it possible? Thanks again

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...