"fredg" <(E-Mail Removed)> wrote in message
news:1k7zt7s5hefzj.8e22b8lpidxk$.(E-Mail Removed)...
> On Tue, 30 Oct 2007 14:40:42 -0700, fredg wrote:
>
>> On Wed, 31 Oct 2007 10:25:46 +1300, Bob V wrote:
>>
>>> Fred I am getting a enter parameter error on :
>>> tblInvoice_Itmdt.HorseID.TotalAmount
>>> And then it is only showing one record and the last column is empty!
>>> Thanks For the help..............Bob
>>>
>>> lstModify.RowSource = "SELECT Format(MIN(dtDate),'dd-mmm-yyyy') AS
>>> StartDate," _
>>> & " Format(MAX(dtDate),'dd-mmm-yyyy') AS EndDate," _
>>> & "
>>> tblInvoice_Itmdt.HorseID,funGetHorse(0,tblInvoice_Itmdt.HorseID,false)"
>>> _
>>> & " FROM tblInvoice_Itmdt" _
>>> & " GROUP BY tblInvoice_Itmdt.HorseID" _
>>> & " order by funGetHorse(0,tblInvoice_ItMdt.HorseID,true) "
>>> _
>>> & ",funGetHorse(0,tblInvoice_ItMdt.HorseID,false)" _
>>> & ",tblInvoice_Itmdt.HorseID.TotalAmount;"
>>>
>>> lstModify.ColumnCount = 5
>>> lstModify.ColumnWidths = "1 in;1 in;1 in;1.5 in;1 in"
>>> lstModify.BoundColumn = 2
>>
>> Bob,
>>
>> 1) Without a reference to the previous message, this post has no
>> relevance.
>> 2) Other posters, who may have a similar need have no idea of what
>> this post is about.
>> 3) I certainly don't keep past messages in mind, so to reply to this i
>> have to go back and forth to the previous message to refresh my
>> memory. It wastes time.
>>
>> It is common courtesy to include the relevant portion of any previous
>> message when replying to a post, as I have with this message.
>>
>> That being said....
>> 4) I would expect, if the query is prompting you for a value for
>> tblInvoice_Itmdt.HorseID.TotalAmount, that you do not have a field in
>> the [tblInvoice_Itmdt] table with a name of [TotalAmount].
>> You'll have to check your table field names and data.
>
> I just noticed this in your previous message:
>> lstModify.ColumnWidths = "1 in;1 in;1 in;1.5 in;1 in"<
>
> The column width property should be written as:
> 1";1";1";1.5";1"
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
Sorry Fred about the blank page!
This may help you and me, this is a code from another form that does list
the field TotalAmount...Thanks for the help..Bob
lstModify.RowSource = "SELECT tblInvoice_ItMdt.IntermediateID," _
& " tblInvoice_ItMdt.HorseID," _
& " funGetHorse(0,tblInvoice_ItMdt.HorseID,false) AS Name," _
& " tblInvoice_ItMdt.TotalAmount" _
& " FROM tblInvoice_ItMdt INNER JOIN tblHorseInfo" _
& " ON tblInvoice_ItMdt.HorseID=tblHorseInfo.HorseID" _
& " order by funGetHorse(0,tblInvoice_ItMdt.HorseID,true) " _
& ",funGetHorse(0,tblInvoice_ItMdt.HorseID,false);
|
Similar Threads
