msimatch error 13- someone posted a question as an answer - repost

[Guest]

Posted a while ago and haven't heard anything?? Most recent below and
previous items listed below that.


Did the pull data from the quote record- when just did it with the cost field
it worked great with not errors. Than added the rest and have problems -
anything wrong with the If code???????

See Below:

Private Sub cbquoteid_AfterUpdate()
If (Me.cbquoteid <> 0) Then
[cost] = Me.cbquoteid.Column(8)
[ClientId] = Me.cbquoteid.Column(2)
[Job] = Me.cbquoteid.Column(4)
[Divisor] = Me.cbquoteid.Column(5)
[GrossWeight] = Me.cbquoteid.Column(6)
[Pit] = Me.cbquoteid(7)
[TaxRate] = Me.cbquoteid(9)
[FuelperRate] = Me.cbquoteid(10)
[Markup] = Me.cbquoteid(11)
[OverallMarkup] = Me.cbquoteid(12)
[CartageRate] = Me.cbquoteid(13)
[AltCartageRate] = Me.cbquoteid(14)
[nontax] = Me.cbquoteid(16)
End If
End Sub

Also tried putting If on ONE LINE seperated by colons. Getting a number of
type mismatch erros. Check data type, size and format for
fields(taxrate,job, pit)and can't find anything. Something wrong with
syntax???

If [cbquoteid] <> 0 Then [cost] = Me.cbquoteid.Column(8): [ClientId] =
Me.cbquoteid.Column(2): [Divisor] = Me.cbquoteid.Column(5): [GrossWeight] =
Me.cbquoteid.Column(6): [Markup] = Me.cbquoteid(11): [OverallMarkup] =
Me.cbquoteid(12): [CartageRate] = Me.cbquoteid(13): [AltCartageRate] =
Me.cbquoteid(14): [nontax] = Me.cbquoteid(16)



Please help!

Thanks so much,
Barb






I have created a form to enter records for invoicing for shipment of trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There is
a step previous to this where some companies are receiving a quote based on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and how
can it fill for only some of the records and how can I let the user input for
the other records. Do I have to go through ALL of my calc. and put the form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb


Was this post helpful to you?
Reply Top





mscertified 11/30/2005 9:21 AM PST



It depends what you want.
All you really need in the invoice record is the quote id which links to the
quote table. If you want to have the data from the quote record actually
placed in the invoice record, you need to handle that yourself. When a quote
is selected, you will need to set up an event procedure to go out and pull
the data from the quote record and place it in the desired form controls. The
quote control would be an unbound combo box and its rowsource would be the
quotes table.
Presumably there is some way to relate invoice records to quote records (by
company name or something).

Dorian

:

Click to show or hide original message or reply text.

I have created a form to enter records for invoicing for shipment of trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There is
a step previous to this where some companies are receiving a quote based on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and how
can it fill for only some of the records and how can I let the user input for
the other records. Do I have to go through ALL of my calc. and put the form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb

Did this post answer the question?
Reply Top





babs 11/30/2005 1:56 PM PST



What would the event procedure look like? where do you put the event
procedure ? on each field or can you add a string after update for the quote
id from the drop down. the quote id would be the common field however not
every record for the invoice may have a quote id. quote id is primary in the
quote table but the invoice # is primary for the invoice table.

Thanks,
Barb



:

Click to show or hide original message or reply text.

 

[Wayne Morgan]

I see nothing in what you have posted. Without knowing the data types of the
fields and what data is being assigned to them all I can do is guess.

1) Remember that the Column property is zero based, that means that column
one is 0, column two is 1, column three is 2, etc. If you are off on this,
you may be assigning the value from the wrong column to the field.

2) Try some Debug.Print statements to see what is actually being assigned.

Example:

Private Sub cbquoteid_AfterUpdate()
If (Me.cbquoteid <> 0) Then

Debug.Print "[cost] = " & Me.cbquoteid.Column(8)

[cost] = Me.cbquoteid.Column(8)

Debug.Print "[ClientId] = " & Me.cbquoteid.Column(2)

[ClientId] = Me.cbquoteid.Column(2)

'etc

This will print the values being assigned to the Immediate window so that
you can see what it is doing.

--
Wayne Morgan
MS Access MVP

Posted a while ago and haven't heard anything?? Most recent below and
previous items listed below that.


Did the pull data from the quote record- when just did it with the cost
field
it worked great with not errors. Than added the rest and have problems -
anything wrong with the If code???????

See Below:

Private Sub cbquoteid_AfterUpdate()
If (Me.cbquoteid <> 0) Then
[cost] = Me.cbquoteid.Column(8)
[ClientId] = Me.cbquoteid.Column(2)
[Job] = Me.cbquoteid.Column(4)
[Divisor] = Me.cbquoteid.Column(5)
[GrossWeight] = Me.cbquoteid.Column(6)
[Pit] = Me.cbquoteid(7)
[TaxRate] = Me.cbquoteid(9)
[FuelperRate] = Me.cbquoteid(10)
[Markup] = Me.cbquoteid(11)
[OverallMarkup] = Me.cbquoteid(12)
[CartageRate] = Me.cbquoteid(13)
[AltCartageRate] = Me.cbquoteid(14)
[nontax] = Me.cbquoteid(16)
End If
End Sub

Also tried putting If on ONE LINE seperated by colons. Getting a number of
type mismatch erros. Check data type, size and format for
fields(taxrate,job, pit)and can't find anything. Something wrong with
syntax???

If [cbquoteid] <> 0 Then [cost] = Me.cbquoteid.Column(8): [ClientId] =
Me.cbquoteid.Column(2): [Divisor] = Me.cbquoteid.Column(5): [GrossWeight]
=
Me.cbquoteid.Column(6): [Markup] = Me.cbquoteid(11): [OverallMarkup] =
Me.cbquoteid(12): [CartageRate] = Me.cbquoteid(13): [AltCartageRate] =
Me.cbquoteid(14): [nontax] = Me.cbquoteid(16)



Please help!

Thanks so much,
Barb






I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There
is
a step previous to this where some companies are receiving a quote based
on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID
and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and
how
can it fill for only some of the records and how can I let the user input
for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb


Was this post helpful to you?
Reply Top





mscertified 11/30/2005 9:21 AM PST



It depends what you want.
All you really need in the invoice record is the quote id which links to
the
quote table. If you want to have the data from the quote record actually
placed in the invoice record, you need to handle that yourself. When a
quote
is selected, you will need to set up an event procedure to go out and pull
the data from the quote record and place it in the desired form controls.
The
quote control would be an unbound combo box and its rowsource would be the
quotes table.
Presumably there is some way to relate invoice records to quote records
(by
company name or something).

Dorian

:

Click to show or hide original message or reply text.

I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There
is
a step previous to this where some companies are receiving a quote based
on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID
and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and
how
can it fill for only some of the records and how can I let the user input
for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb

Did this post answer the question?
Reply Top





babs 11/30/2005 1:56 PM PST



What would the event procedure look like? where do you put the event
procedure ? on each field or can you add a string after update for the
quote
id from the drop down. the quote id would be the common field however not
every record for the invoice may have a quote id. quote id is primary in
the
quote table but the invoice # is primary for the invoice table.

Thanks,
Barb



:

Click to show or hide original message or reply text.

It depends what you want.
All you really need in the invoice record is the quote id which links to
the
quote table. If you want to have the data from the quote record actually
placed in the invoice record, you need to handle that yourself. When a
quote
is selected, you will need to set up an event procedure to go out and
pull
the data from the quote record and place it in the desired form controls.
The
quote control would be an unbound combo box and its rowsource would be
the
quotes table.
Presumably there is some way to relate invoice records to quote records
(by
company name or something).

Dorian

 

[Guest]

I have added the code but don't know how to RUN it??? When I try to open the
form I get a syntax error. Don't I do something in Visual basic to Run it-
no macro not sure how to do it????

I see nothing in what you have posted. Without knowing the data types of the
fields and what data is being assigned to them all I can do is guess.

1) Remember that the Column property is zero based, that means that column
one is 0, column two is 1, column three is 2, etc. If you are off on this,
you may be assigning the value from the wrong column to the field.

2) Try some Debug.Print statements to see what is actually being assigned.

Example:

Private Sub cbquoteid_AfterUpdate()
If (Me.cbquoteid <> 0) Then

Debug.Print "[cost] = " & Me.cbquoteid.Column(8)

[cost] = Me.cbquoteid.Column(8)

Debug.Print "[ClientId] = " & Me.cbquoteid.Column(2)

[ClientId] = Me.cbquoteid.Column(2)

'etc

This will print the values being assigned to the Immediate window so that
you can see what it is doing.

--
Wayne Morgan
MS Access MVP

Posted a while ago and haven't heard anything?? Most recent below and
previous items listed below that.


Did the pull data from the quote record- when just did it with the cost
field
it worked great with not errors. Than added the rest and have problems -
anything wrong with the If code???????

See Below:

Private Sub cbquoteid_AfterUpdate()
If (Me.cbquoteid <> 0) Then
[cost] = Me.cbquoteid.Column(8)
[ClientId] = Me.cbquoteid.Column(2)
[Job] = Me.cbquoteid.Column(4)
[Divisor] = Me.cbquoteid.Column(5)
[GrossWeight] = Me.cbquoteid.Column(6)
[Pit] = Me.cbquoteid(7)
[TaxRate] = Me.cbquoteid(9)
[FuelperRate] = Me.cbquoteid(10)
[Markup] = Me.cbquoteid(11)
[OverallMarkup] = Me.cbquoteid(12)
[CartageRate] = Me.cbquoteid(13)
[AltCartageRate] = Me.cbquoteid(14)
[nontax] = Me.cbquoteid(16)
End If
End Sub

Also tried putting If on ONE LINE seperated by colons. Getting a number of
type mismatch erros. Check data type, size and format for
fields(taxrate,job, pit)and can't find anything. Something wrong with
syntax???

If [cbquoteid] <> 0 Then [cost] = Me.cbquoteid.Column(8): [ClientId] =
Me.cbquoteid.Column(2): [Divisor] = Me.cbquoteid.Column(5): [GrossWeight]
=
Me.cbquoteid.Column(6): [Markup] = Me.cbquoteid(11): [OverallMarkup] =
Me.cbquoteid(12): [CartageRate] = Me.cbquoteid(13): [AltCartageRate] =
Me.cbquoteid(14): [nontax] = Me.cbquoteid(16)



Please help!

Thanks so much,
Barb






I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There
is
a step previous to this where some companies are receiving a quote based
on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID
and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and
how
can it fill for only some of the records and how can I let the user input
for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb


Was this post helpful to you?
Reply Top





mscertified 11/30/2005 9:21 AM PST



It depends what you want.
All you really need in the invoice record is the quote id which links to
the
quote table. If you want to have the data from the quote record actually
placed in the invoice record, you need to handle that yourself. When a
quote
is selected, you will need to set up an event procedure to go out and pull
the data from the quote record and place it in the desired form controls.
The
quote control would be an unbound combo box and its rowsource would be the
quotes table.
Presumably there is some way to relate invoice records to quote records
(by
company name or something).

Dorian

:

Click to show or hide original message or reply text.

I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There
is
a step previous to this where some companies are receiving a quote based
on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID
and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and
how
can it fill for only some of the records and how can I let the user input
for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb

Did this post answer the question?
Reply Top





babs 11/30/2005 1:56 PM PST



What would the event procedure look like? where do you put the event
procedure ? on each field or can you add a string after update for the
quote
id from the drop down. the quote id would be the common field however not
every record for the invoice may have a quote id. quote id is primary in
the
quote table but the invoice # is primary for the invoice table.

Thanks,
Barb



:

Click to show or hide original message or reply text.

It depends what you want.
All you really need in the invoice record is the quote id which links to
the
quote table. If you want to have the data from the quote record actually
placed in the invoice record, you need to handle that yourself. When a
quote
is selected, you will need to set up an event procedure to go out and
pull
the data from the quote record and place it in the desired form controls.
The
quote control would be an unbound combo box and its rowsource would be
the
quotes table.
Presumably there is some way to relate invoice records to quote records
(by
company name or something).

Dorian

:

I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id,
client
address, dates, and some calculations of ex. cost*quantity of matl.
There is
a step previous to this where some companies are receiving a quote
based on
which would fill some(most-not all) of the fields for this form. I
would
like the existing form (Invoice Entry) to have a drop down for a
QuoteID and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc.
and how
can it fill for only some of the records and how can I let the user
input for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb

 

[Wayne Morgan]

You run it the same way you run the code you already had. When you run that
procedure, the Debug.Print statements will automatically "print" the values
to the Immediate window (usually docked under the coding window).

 

[Guest]

Wayne,

Just wanted you to know that I do know that the column property is zero
based and the column count matches- not sure where to check for mismatch-
check table drop down is based off of - for data type, size, format,dec. -
what has to match that the properites of text box on form or the field for
other table it will dump it into and or both???

thanks

I see nothing in what you have posted. Without knowing the data types of the
fields and what data is being assigned to them all I can do is guess.

1) Remember that the Column property is zero based, that means that column
one is 0, column two is 1, column three is 2, etc. If you are off on this,
you may be assigning the value from the wrong column to the field.

2) Try some Debug.Print statements to see what is actually being assigned.

Example:

Private Sub cbquoteid_AfterUpdate()
If (Me.cbquoteid <> 0) Then

Debug.Print "[cost] = " & Me.cbquoteid.Column(8)

[cost] = Me.cbquoteid.Column(8)

Debug.Print "[ClientId] = " & Me.cbquoteid.Column(2)

[ClientId] = Me.cbquoteid.Column(2)

'etc

This will print the values being assigned to the Immediate window so that
you can see what it is doing.

--
Wayne Morgan
MS Access MVP

Posted a while ago and haven't heard anything?? Most recent below and
previous items listed below that.


Did the pull data from the quote record- when just did it with the cost
field
it worked great with not errors. Than added the rest and have problems -
anything wrong with the If code???????

See Below:

Private Sub cbquoteid_AfterUpdate()
If (Me.cbquoteid <> 0) Then
[cost] = Me.cbquoteid.Column(8)
[ClientId] = Me.cbquoteid.Column(2)
[Job] = Me.cbquoteid.Column(4)
[Divisor] = Me.cbquoteid.Column(5)
[GrossWeight] = Me.cbquoteid.Column(6)
[Pit] = Me.cbquoteid(7)
[TaxRate] = Me.cbquoteid(9)
[FuelperRate] = Me.cbquoteid(10)
[Markup] = Me.cbquoteid(11)
[OverallMarkup] = Me.cbquoteid(12)
[CartageRate] = Me.cbquoteid(13)
[AltCartageRate] = Me.cbquoteid(14)
[nontax] = Me.cbquoteid(16)
End If
End Sub

Also tried putting If on ONE LINE seperated by colons. Getting a number of
type mismatch erros. Check data type, size and format for
fields(taxrate,job, pit)and can't find anything. Something wrong with
syntax???

If [cbquoteid] <> 0 Then [cost] = Me.cbquoteid.Column(8): [ClientId] =
Me.cbquoteid.Column(2): [Divisor] = Me.cbquoteid.Column(5): [GrossWeight]
=
Me.cbquoteid.Column(6): [Markup] = Me.cbquoteid(11): [OverallMarkup] =
Me.cbquoteid(12): [CartageRate] = Me.cbquoteid(13): [AltCartageRate] =
Me.cbquoteid(14): [nontax] = Me.cbquoteid(16)



Please help!

Thanks so much,
Barb






I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There
is
a step previous to this where some companies are receiving a quote based
on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID
and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and
how
can it fill for only some of the records and how can I let the user input
for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb


Was this post helpful to you?
Reply Top





mscertified 11/30/2005 9:21 AM PST



It depends what you want.
All you really need in the invoice record is the quote id which links to
the
quote table. If you want to have the data from the quote record actually
placed in the invoice record, you need to handle that yourself. When a
quote
is selected, you will need to set up an event procedure to go out and pull
the data from the quote record and place it in the desired form controls.
The
quote control would be an unbound combo box and its rowsource would be the
quotes table.
Presumably there is some way to relate invoice records to quote records
(by
company name or something).

Dorian

:

Click to show or hide original message or reply text.

I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id, client
address, dates, and some calculations of ex. cost*quantity of matl. There
is
a step previous to this where some companies are receiving a quote based
on
which would fill some(most-not all) of the fields for this form. I would
like the existing form (Invoice Entry) to have a drop down for a QuoteID
and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc. and
how
can it fill for only some of the records and how can I let the user input
for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb

Did this post answer the question?
Reply Top





babs 11/30/2005 1:56 PM PST



What would the event procedure look like? where do you put the event
procedure ? on each field or can you add a string after update for the
quote
id from the drop down. the quote id would be the common field however not
every record for the invoice may have a quote id. quote id is primary in
the
quote table but the invoice # is primary for the invoice table.

Thanks,
Barb



:

Click to show or hide original message or reply text.

It depends what you want.
All you really need in the invoice record is the quote id which links to
the
quote table. If you want to have the data from the quote record actually
placed in the invoice record, you need to handle that yourself. When a
quote
is selected, you will need to set up an event procedure to go out and
pull
the data from the quote record and place it in the desired form controls.
The
quote control would be an unbound combo box and its rowsource would be
the
quotes table.
Presumably there is some way to relate invoice records to quote records
(by
company name or something).

Dorian

:

I have created a form to enter records for invoicing for shipment of
trucks.
It includes the cost of the matl shipped the quantity, client id,
client
address, dates, and some calculations of ex. cost*quantity of matl.
There is
a step previous to this where some companies are receiving a quote
based on
which would fill some(most-not all) of the fields for this form. I
would
like the existing form (Invoice Entry) to have a drop down for a
QuoteID and
have it fill the ex. cost, quantiy etc. Not all of the Invoice Entry
records
will have had a quoteid or a quote for them and they would need to be
manually input. I am getting confused do both the QuoteForm and the
Invoice
Entry form have to have the same field names ex. cost, quantiy, etc.
and how
can it fill for only some of the records and how can I let the user
input for
the other records. Do I have to go through ALL of my calc. and put the
form
name in front of all ex. cost fields???

Confused -
Thanks,
Barb

 

[Guest]

REturning correct values for beginning columns -Got it showing mismatch for
the column(9) thru 16 - is there a max # of columns you can have in a combo
box?????? not sure what to look for

 

[Gina via AccessMonster.com]

From [Pit] down you are missing the call to the Column property after the
name of the combobox.

Gina

 

[Wayne Morgan]

Gina,

Good catch. However, I tested this and it returns runtime error 451, not the
mismatch error. I suspect he typed the code into the message rather than
copying and pasting it.

 

[Wayne Morgan]

The column count must be between 1 and 255. To test this, try setting a
number outside this range in the Column Count property of the combo box with
the form open in design mode. You'll get an error message that gives you the
limit.

What value did the Debug.Print give for the Column(9) entry? Was that value
correct? What is the Data Type and Size in the table for the TaxRate field?

 

[Guest]

THAT'S WAS IT GINA!!!!! I CAN'T BELIEVE I MISSED THAT-OLD AGE SETTING IN!!
Thanks for trying to help also Wayne.

You made my day,
Barb

 

[Gina via AccessMonster.com]

Very glad that I can help! Usually I just find help here.

Have a great weekend!
Gina

THAT'S WAS IT GINA!!!!! I CAN'T BELIEVE I MISSED THAT-OLD AGE SETTING IN!!
Thanks for trying to help also Wayne.

You made my day,
Barb

From [Pit] down you are missing the call to the Column property after the
name of the combobox.

Gina