[AccessD] Try this one again

First, the reports recordsource is this query, correct?
I would then place all the fields on the report and hide them (visible =
false).
And while Witness may work I always use me.Witness (easier for me to follow
where witness is coming from).

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
> Sent: Tuesday, December 22, 2009 8:46 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Try this one again
> 
> 
> OK, I am taking your advice, and I've started doing this. I'm 
> finding that isn't all that bad, and I think it will look 
> alright. The trouble I am now having though, is that I am 
> unable to bring the data into the paragraph. In the code, for 
> the OnLoad event of the form, I am doing this:
>  
> Dim P1, P2, P3 As String
>  
> P1 = Witness
> P1 = P1 + " - Being duly sworn, says that he/she attended as 
> a witness on behalf of the People "
> P1 = P1 + "before the above court, pursuant to a subpoena or 
> at the request of the District "
> P1 = P1 + "Attorney and that he traveled from the 
> City/Town/Village of "
> P1 = P1 + txtWitCity
> P1 = P1 + ", in the State of New York, which said place is "
> P1 = P1 + numMileage
> P1 = P1 + " miles from the Court House in the City of Lockport."
>  
> Me.lblParaOne.Caption = P1
>  
>  
> I've tried other things, but what is the code for getting a 
> field (Witness, txtWitCity, numMileage) out of the query? I 
> don't need to do this the "long" way do I?
> 
> >>> "Reuben Cummings" <accessd at gfconsultants.com> 12/21/2009 
> 11:44 AM >>>
> I would stick with Access reports.  I make all kinds of reports for
> government work all using Access.  And if the formatting is 
> tough to copy
> you'd be surprised what you can convince people to change to.
> I've nearly changed the culture of "claims" in the state of 
> Indiana.  The
> old form was ridiculous - and I couldn't match it.  So I convinced one
> county to change years ago and now it's on the verge of being 
> the standard.
> 
> And if you are placing parts of your data into pre-worded 
> paragraphs (the
> paragraph wording is pre-defined other than your data) do all 
> the paragraph
> building in code.   
> 
> Reuben Cummings
> GFC, LLC
> 812.523.1017
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>