[AccessD] A2K Unbound field on report error

David Mcafee dmcafee at pacbell.net
Thu Aug 4 15:52:01 CDT 2005


I would say it is a misspell somewhere. Check other
places like querires and functions that may be called.

have you tried stepping through in debug?

David

--- Bob Gajewski <rbgajewski at adelphia.net> wrote:

> Dear List
> 
> We have a report that prints one membership card at
> a time. I am probably
> missing the most obvious thing here, but I just
> can't get this report to
> print. I keep receiving:
> 
>
-----------------------------------------------------
> 
> Run-time error; '2465'
> 
> Microsoft Access can't find the field 'Firefighter'
> referred to in your expression.
> 
>
-----------------------------------------------------
> 
> Any assistance or guidance would be most
> appreciated.
> 
> Thanks,
> 
> Bob Gajewski, Assistant Chief (and db Administrator)
> Wales Center Volunteer Fire Company
> 
> 
> 
> Details:
> 
> rptMembershipCard
> Source: qryMembershipCard
> Fields:
>   MemberNumber (bound to query field 'MemberNumber')
>   txtFullName (bound to query field 'txtFullName')
>   txtClass (unbound)
>   // other fields have been not included here as
> they are not related to the
> problem
> 
> qryMembershipCard
> Source: tblMembers
> Selected Fields:
>   MemberNumber // using prompt to select one record
>   txtFullName = [FirstName] &
> IIf(IsNull([MiddleInitial]),""," " &
> [MiddleInitial] & ",") & " " & [LastName]
>   booFirefighter
>   booEMSProvider
>   booFirePolice
>   // other fields have been not included here as
> they are not related to the
> problem
> 
> The CBF is:
> 
> ***************** CODE BEGIN
> ************************
> Private Sub Detail_Format(Cancel As Integer,
> FormatCount As Integer)
> 
> Dim booFirstClass As Boolean
> 
> booFirstClass = True
> 
> txtClass = ""
> 
> If [Firefighter] = True Then
>     If booFirstClass = True Then
>         txtClass = "Firefighter"
>         booFirstClass = False
>     Else
>         txtClass = " " & "Firefighter"
>     End If
> End If
> If [EMSProvider] = True Then
>     If booFirstClass = True Then
>         txtClass = "EMS Provider"
>         booFirstClass = False
>     Else
>         txtClass = "," & "EMS Provider"
>     End If
> End If
> If [FirePolice] = True Then
>     If booFirstClass = True Then
>         txtClass = "Fire Police"
>         booFirstClass = False
>     Else
>         txtClass = "," & "Fire Police"
>     End If
> End If
> 
> If IsNull([txtClass]) Or [txtClass] = "" Then
>     lblClass.Visible = False
> End If
> End Sub
> ****************** CODE END
> *************************
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On
> Behalf Of Ervin Brindza
> Sent: Wednesday, June 08, 2005 02:13 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Insert Access Info Into Web
> page
> 
> Adam,
> try to find an article in the Database Journal:
> Convert Access Tables Into ASP Web Pages by Danny
> Lesandrini HTH,
> 
>     Ervin
> 
> ----- Original Message -----
> From: "MartyConnelly" <martyconnelly at shaw.ca>
> To: "Access Developers discussion and problem
> solving"
> <accessd at databaseadvisors.com>
> Sent: Tuesday, June 07, 2005 6:41 PM
> Subject: Re: [AccessD] Insert Access Info Into Web
> page
> 
> 
> >
> > Here are a few good ASP sites:
> > o ASP101 Samples - http://www.asp101.com/samples o
> W3Schools ASP 
> > Tutorial - http://www.w3schools.com/asp o
> Microsoft VBScript Language 
> > Reference - 
> >
>
http://msdn.microsoft.com/scri-pting/default.htm?/scripting/V-BScript/d...
> >
> > There are several 100 dollar asp IIS Access
> solutions like
> >
> > http://www.access2asp.com/
> >
> > Or for a "quick and dirty" generic ASP open source
> solution to putting 
> > databases on the Web (often works well for the
> admin area of a Web 
> > site) that just requires setting up a
> configuration page for each 
> > table or query and uploading the database to the
> Web as long as there 
> > is an autonumber field in each table (and you'll
> probably also 
> > separately want to create login capabilities),
> perhaps try something like
> this:
> > GenericDB by Eli Robillard. It has been around for
> 7 years and is used 
> > in a lot of university labs.
> > http://www.genericdb.com and then click on the
> Tips link to see an 
> > example
> >
> >
> > Mail List at
> > http://aspadvice.com/SignUp/list.aspx?l=63&c=11
> >
> > Res-Com Environmental wrote:
> >
> > >Dear List:
> > >
> > >Is there a way that Access information (such as
> names and addresses) 
> > >can
> be
> > >inserted into a website's form fields? We are
> trying to use a 
> > >businesses website that doesn't offer special
> connections so we have 
> > >to manually
> enter
> > >information from our database.
> > >
> > >Adam
> > >ResCom
> > >
> > >
> > >
> > >
> >
> > --
> > Marty Connelly
> > Victoria, B.C.
> > Canada
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> >
> http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
=== message truncated ===




More information about the AccessD mailing list