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