Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Access 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Access 2003 VBA Programmer's Reference by Patricia Cardoza, Teresa Hennig, Graham Seach, Armen Stein; ISBN: 9780764559037
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2003 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 21st, 2004, 01:15 PM
Wrox Author
 
Join Date: May 2004
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Welcome!

Hi everyone, I'm Patricia, Lead Author for Access 2003 VBA Programmer's Reference.

Thanks for visiting the Wrox p2p forums.

We'll do our best to answer any questions posed about the book as well as questions on Access programming. We're all quite busy these days, so if it takes us a day or two to respond, please forgive us.

We'll do our best to answer all questions as completely as possible!

Thanks for visiting the Wrox p2p forums!



Patricia Cardoza
Outlook MVP

Lead Author, Access 2003 VBA Programmer's Reference
__________________
Patricia Cardoza
Outlook MVP

Lead Author, Access 2003 VBA Programmer\'s Reference
  #2 (permalink)  
Old July 13th, 2004, 09:26 AM
Authorized User
 
Join Date: Jun 2004
Location: Cumberland, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can you please read my "Book's Audience" post?
Thanks

Terry Waltz
  #3 (permalink)  
Old August 16th, 2007, 12:00 PM
Registered User
 
Join Date: Aug 2007
Location: Los Angeles, CA, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default


Hi, I need some help. I am a beginner.
Could you please look at the code below.
I am trying to write a simple function that will calculate a total record count based on a simple query (with two part where clause). The functions only half works. I get a result, but it is always the wrong result. It’s as if the second criteria in the where clause is ignored. Why would this be?
Thank you in advance for any help you can give.


Public Function f_work_count(artistID As Long, intWork_type As Integer)
Dim sqlString As String


sqlString = "select id, work_type, production_type, production from t_work_main where work_type = " & intWork_type & " and ID = " & artistID

Dim db As DAO.Database
Set db = CurrentDb

Dim rs As DAO.Recordset
Set rs = db.OpenRecordset(sqlString)

f_work_count = rs.RecordCount






Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.