Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
Ajax Application Generator Generate database and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
  #1  
Old October 9th, 2003, 05:30 PM
woody Hall woody Hall is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2003
Posts: 1 woody Hall User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
print report for current record

Let me say this up front. I'm a novice using MS Access. But here's my problem. I have a database created with Access 97 that I have code to run a report for only the current record. It works fine. But when I try to copy the code to another database created in Access 2000, it won't run. I get a run time error "2465 Microsoft Access can't find the field 'I' referred to in your expression".

Here's the code

Dim strWere As String
If Me.Dirty Then 'Save any changes.
Me.Dirty = False
End If
If Me.NewRecord Then
MsgBox "SELECT A RECORD TO PRINT"
Else
strWhere = "[ID] = " & Me.[ID]
DoCmd.OpenReport "rptPrintRecord", acViewPreview, strWhere
End If

Do I need to change something in the expression or is it because code for 97 is different then 2000.

Reply With Quote
  #2  
Old October 11th, 2003, 04:41 AM
ansentry's Avatar
ansentry ansentry is offline
Access amateur
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Melbourne, Australia
Posts: 494 ansentry User rank is Corporal (100 - 500 Reputation Level)ansentry User rank is Corporal (100 - 500 Reputation Level)ansentry User rank is Corporal (100 - 500 Reputation Level)ansentry User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 5 Days 19 h 49 m 55 sec
Reputation Power: 7
Look at the first line of your code!!

you have Dim strWere As String don't you mean Dim strWhere.

??????


Regards,
__________________
Regards,


John A


Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > print report for current record


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway