Koerean Character displayed in other forms

[Anticephalous]

Dear All,

I need your help to determine why I'm having this issue. The Character appears on my billing history subform, and Invoice List form, but does not on my Invoice entry/edit form, even the query has the same issue. But the back end doen't. I tried Compact and repair but it's still the same. Please see attached images. :banghead:

 

[NauticalGent]

Try this:

https://access-programmers.co.uk/forums/showthread.php?t=247087

 

[Cronk]

It could also result from a corruption in the corresponding memo field. In my experience, this is normally for only one or a couple of records, not all for a grouping query on the memo field.

 

[Anticephalous]

It could also result from a corruption in the corresponding memo field. In my experience, this is normally for only one or a couple of records, not all for a grouping query on the memo field.

Could be,but I've tried compact and repair and nothing happenned. How can I resolve this? Should I delete my union query and make fresh one?

 

[gemma-the-husky]

you have some corrupted data. Try editing the record - you will most likely get a curious error message.

you need to sort this, as it may start causing worse problems

 

[NauticalGent]

Are you using Group By on a memo filed in your queries?

 

[Anticephalous]

Are you using Group By on a memo filed in your queries?

I did use group by... I made this query last year and there were no issues, till yesterday.

SELECT InvoiceFinalMain.CompanyName, InvoiceFinalMain.InvoiceNum, InvoiceFinalMain.Invdate, InvoiceFinalSUB.Product, InvoiceFinalSUB.Particulars, InvoiceFinalSUB.Amount, FinalTotalBill.TotalBill, InvoiceFinalMain.Chargedby, InvoiceFinalMain.Closed, InvoiceFinalMain.Preparedby
FROM (InvoiceFinalMain INNER JOIN InvoiceFinalSUB ON InvoiceFinalMain.InvoiceNum = InvoiceFinalSUB.InvoiceNum) INNER JOIN FinalTotalBill ON InvoiceFinalMain.InvoiceNum = FinalTotalBill.InvoiceNum
GROUP BY InvoiceFinalMain.CompanyName, InvoiceFinalMain.InvoiceNum, InvoiceFinalMain.Invdate, InvoiceFinalSUB.Product, InvoiceFinalSUB.Particulars, InvoiceFinalSUB.Amount, FinalTotalBill.TotalBill, InvoiceFinalMain.Chargedby, InvoiceFinalMain.Closed, InvoiceFinalMain.Preparedby, InvoiceFinalSUB.InvoiceNum
HAVING (((InvoiceFinalSUB.Amount)>0))
UNION ALL SELECT InvoiceAdvanceMain.CompanyName, InvoiceAdvanceMain.InvoiceNum, InvoiceAdvanceMain.Invdate, InvoiceAdvanceSUB.Product, InvoiceAdvanceSUB.Particulars, InvoiceAdvanceSUB.Amount, AdvanceTotalBill.TotalBill, InvoiceAdvanceMain.Chargedby, InvoiceAdvanceMain.Closed, InvoiceAdvanceMain.Preparedby
FROM AdvanceTotalBill INNER JOIN (InvoiceAdvanceMain INNER JOIN InvoiceAdvanceSUB ON InvoiceAdvanceMain.InvoiceNum = InvoiceAdvanceSUB.InvoiceNum) ON AdvanceTotalBill.InvoiceNum = InvoiceAdvanceMain.InvoiceNum
GROUP BY InvoiceAdvanceMain.CompanyName, InvoiceAdvanceMain.InvoiceNum, InvoiceAdvanceMain.Invdate, InvoiceAdvanceSUB.Product, InvoiceAdvanceSUB.Particulars, InvoiceAdvanceSUB.Amount, AdvanceTotalBill.TotalBill, InvoiceAdvanceMain.Chargedby, InvoiceAdvanceMain.Closed, InvoiceAdvanceMain.Preparedby
HAVING (((InvoiceAdvanceSUB.Amount)>0));

 

[Anticephalous]

you have some corrupted data. Try editing the record - you will most likely get a curious error message.

you need to sort this, as it may start causing worse problems

Did you mean re-enter the records which has this weird characters? The back end is ok, the particulars are all in English. The issue is only in the forms which record source is the Query "ADVFINBillingHistory", which is by the way a union query.

 

[NauticalGent]

Change "Group By" to "First" on you Memo fields. I am 92.9% that it will fix your issue...

 

[Anticephalous]

Change "Group By" to "First" on you Memo fields. I am 92.9% that it will fix your issue...

Sorry, it didn't work. It says The Microsoft Office Access database engine could not find the object ". Make sure the object exist and that you spell its name and the path name correctly

 

[NauticalGent]

I assumed that you were doing this in the Query grid and not in SQL. If this is not accurate, than a simple replace of Group By with First will not work.

Try this:

SELECT InvoiceFinalMain.CompanyName, InvoiceFinalMain.InvoiceNum, InvoiceFinalMain.Invdate, InvoiceFinalSUB.Product, First(InvoiceFinalSUB.Particulars) AS FirstOfParticulars, InvoiceFinalSUB.Amount, FinalTotalBill.TotalBill, InvoiceFinalMain.Chargedby, InvoiceFinalMain.Closed, InvoiceFinalMain.Preparedby
FROM (InvoiceFinalMain INNER JOIN InvoiceFinalSUB ON InvoiceFinalMain.InvoiceNum = InvoiceFinalSUB.InvoiceNum) INNER JOIN FinalTotalBill ON InvoiceFinalMain.InvoiceNum = FinalTotalBill.InvoiceNum
GROUP BY InvoiceFinalMain.CompanyName, InvoiceFinalMain.InvoiceNum, InvoiceFinalMain.Invdate, InvoiceFinalSUB.Product, First(InvoiceFinalSUB.Particulars) AS FirstOfParticulars, InvoiceFinalSUB.Amount, FinalTotalBill.TotalBill, InvoiceFinalMain.Chargedby, InvoiceFinalMain.Closed, InvoiceFinalMain.Preparedby, InvoiceFinalSUB.InvoiceNum
HAVING (((InvoiceFinalSUB.Amount)>0))
UNION ALL SELECT InvoiceAdvanceMain.CompanyName, InvoiceAdvanceMain.InvoiceNum, InvoiceAdvanceMain.Invdate, InvoiceAdvanceSUB.Product, InvoiceAdvanceSUB.Particulars, InvoiceAdvanceSUB.Amount, AdvanceTotalBill.TotalBill, InvoiceAdvanceMain.Chargedby, InvoiceAdvanceMain.Closed, InvoiceAdvanceMain.Preparedby
FROM AdvanceTotalBill INNER JOIN (InvoiceAdvanceMain INNER JOIN InvoiceAdvanceSUB ON InvoiceAdvanceMain.InvoiceNum = InvoiceAdvanceSUB.InvoiceNum) ON AdvanceTotalBill.InvoiceNum = InvoiceAdvanceMain.InvoiceNum
GROUP BY InvoiceAdvanceMain.CompanyName, InvoiceAdvanceMain.InvoiceNum, InvoiceAdvanceMain.Invdate, InvoiceAdvanceSUB.Product, InvoiceAdvanceSUB.Particulars, InvoiceAdvanceSUB.Amount, AdvanceTotalBill.TotalBill, InvoiceAdvanceMain.Chargedby, InvoiceAdvanceMain.Closed, InvoiceAdvanceMain.Preparedby
HAVING (((InvoiceAdvanceSUB.Amount)>0));

 

[Anticephalous]

I assumed that you were doing this in the Query grid and not in SQL. If this is not accurate, than a simple replace of Group By with First will not work.

Try this:

SELECT InvoiceFinalMain.CompanyName, InvoiceFinalMain.InvoiceNum, InvoiceFinalMain.Invdate, InvoiceFinalSUB.Product, First(InvoiceFinalSUB.Particulars) AS FirstOfParticulars, InvoiceFinalSUB.Amount, FinalTotalBill.TotalBill, InvoiceFinalMain.Chargedby, InvoiceFinalMain.Closed, InvoiceFinalMain.Preparedby
FROM (InvoiceFinalMain INNER JOIN InvoiceFinalSUB ON InvoiceFinalMain.InvoiceNum = InvoiceFinalSUB.InvoiceNum) INNER JOIN FinalTotalBill ON InvoiceFinalMain.InvoiceNum = FinalTotalBill.InvoiceNum
GROUP BY InvoiceFinalMain.CompanyName, InvoiceFinalMain.InvoiceNum, InvoiceFinalMain.Invdate, InvoiceFinalSUB.Product, First(InvoiceFinalSUB.Particulars) AS FirstOfParticulars, InvoiceFinalSUB.Amount, FinalTotalBill.TotalBill, InvoiceFinalMain.Chargedby, InvoiceFinalMain.Closed, InvoiceFinalMain.Preparedby, InvoiceFinalSUB.InvoiceNum
HAVING (((InvoiceFinalSUB.Amount)>0))
UNION ALL SELECT InvoiceAdvanceMain.CompanyName, InvoiceAdvanceMain.InvoiceNum, InvoiceAdvanceMain.Invdate, InvoiceAdvanceSUB.Product, InvoiceAdvanceSUB.Particulars, InvoiceAdvanceSUB.Amount, AdvanceTotalBill.TotalBill, InvoiceAdvanceMain.Chargedby, InvoiceAdvanceMain.Closed, InvoiceAdvanceMain.Preparedby
FROM AdvanceTotalBill INNER JOIN (InvoiceAdvanceMain INNER JOIN InvoiceAdvanceSUB ON InvoiceAdvanceMain.InvoiceNum = InvoiceAdvanceSUB.InvoiceNum) ON AdvanceTotalBill.InvoiceNum = InvoiceAdvanceMain.InvoiceNum
GROUP BY InvoiceAdvanceMain.CompanyName, InvoiceAdvanceMain.InvoiceNum, InvoiceAdvanceMain.Invdate, InvoiceAdvanceSUB.Product, InvoiceAdvanceSUB.Particulars, InvoiceAdvanceSUB.Amount, AdvanceTotalBill.TotalBill, InvoiceAdvanceMain.Chargedby, InvoiceAdvanceMain.Closed, InvoiceAdvanceMain.Preparedby
HAVING (((InvoiceAdvanceSUB.Amount)>0));

yes Query Grid. I'm using MS Access 2007.

 

[NauticalGent]

Is it possible to zip your DB and post it here? We can have a look at what you have and it will go much faster...

 

[The_Doc_Man]

By any chance is that text box set for RTF rather than plain text?

 

[Anticephalous]

Issue resolved. I compact and repair the back end and my Union Query is okay. Earlier, I only compacted and repaired the front end.

Thank you All!