Re: "no current record" error in custom report in Access 2003
- From: "Nick via AccessMonster.com" <u13819@uwe>
- Date: Thu, 29 Jun 2006 13:52:10 GMT
Beth,
I'm not entirely sure what's going on now with the last record because I
don't have a feel for what is supposed to be achieved through your code. A
few questions:
What is contained in your [tbl Main]? (Fields / data types)
Regarding the 'Do Until Len >= 50' and 'Do Until Len >= 12'
Why the 50 and 12? Are those length restrictions on an output, or some
kind of qualifier?
What is the textbox (Text0) supposed to display?
I just want to be sure I understand the code's purpose before I throw out
some suggestions; I don't want to dig you further into a hole. Once I
understand the above questions I think that we can get this figured out
pretty quickly.
-Nick
BethHill wrote:
Nick,
Thank you for your help. The error message did go away but the report is
only printing the last record in the record set over and over. What am I
doing wrong?
BethHill,[quoted text clipped - 73 lines]
Once I click OK and stop the debugging process, the report opens in design
view. What am I doing wrong?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200606/1
.
- References:
- Re: "no current record" error in custom report in Access 2003
- From: Nick via AccessMonster.com
- Re: "no current record" error in custom report in Access 2003
- From: BethHill
- Re: "no current record" error in custom report in Access 2003
- Prev by Date: RE: Tracking Log In and Log Out times of Users
- Next by Date: Re: xml using reading caracters
- Previous by thread: Re: "no current record" error in custom report in Access 2003
- Next by thread: Re: memo field corruption
- Index(es):
Relevant Pages
|