[AccessD] Try this one again

Yes, it is Reuben. Actually, what I am doing, is running a query based on a form, which queries the main table, based on the current voucher number...the one distinguishing field. This will allow me to have one single record, and all of its fields, for the report. It was really the only way I could think to do it...to print a voucher for the active record..
 
I did the 1st paragraph this morning, and I got it all working...except for the number to text conversion that I put off until later. Now, it seems that nothing wants to work. I didn't do anything, but move on to paragraph #2

>>> "Reuben Cummings" <accessd at gfconsultants.com> 12/22/2009 9:47 AM >>>
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 
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com