Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Oriental Text in Query (2003 SR 3)

    i have a query that uses the value from a control on a form which is a date field ([Forms]![frm_IReports]![txtReportEndDate]). When I preview the query with the value as one of the data elements, I get what appears to be two oriental something or others instead of the date. I have attached a copy of the query in datasheet view. The date in the control is "11/30/2007", and the cursor focus is on another control.

    Any ideas what would cause this?

    Thanks in advance for your ideas,

    Ken
    Attached Images Attached Images

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oriental Text in Query (2003 SR 3)

    Hi Ken

    Back up your database and then try a Compact and Repair on it. It may just be a corrupted table.
    Jerry

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Oriental Text in Query (2003 SR 3)

    Jerry,

    Thanks! I had already compacted and repaired. Compacting and repairing doesn't help.

    Note that the query is displaying the value in a control on a form, and not a field in a table. I thought it might be something with the form, but the Expr1 in the column immediately to the left of Expr2 is a calculated field using the value in Expr2 as a part of the calculation.

    I removed the control and recreated it, with the same results. Feng Shui?

    Jerry, thanks again for sharing.

    Ken

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Oriental Text in Query (2003 SR 3)

    Can you post a zipped comp-acted data base in here for people to look at.

  5. #5
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Oriental Text in Query (2003 SR 3)

    Patt,

    Thanks for taking a look.

    Ken
    Attached Files Attached Files

  6. #6
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oriental Text in Query (2003 SR 3)

    Your attached database does not have Query1 nor the table is is based upon.
    Thanks
    chuck

  7. #7
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Oriental Text in Query (2003 SR 3)

    That's weird. The one I uploaded has a single query (sqQuery), a single form and a single table. I downloaded it from the site here and tested it, and the query worked (including the oriental characters).

    FYI, to get the characters visible, open the query in datasheet view and then click in the Expr1 column first row, then click into the second row.

    Thanks for taking time to view this.

    Ken

  8. #8
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oriental Text in Query (2003 SR 3)

    Sorry. I was looking for the query in your screen shot. I do not get the oriental characters but I get 4 squares.

    Did this ever work?
    Thanks
    chuck

  9. #9
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Oriental Text in Query (2003 SR 3)

    I have used this form and the date control for a long time, without problems. I used it from Access 97 through Access 2003 with no problem going as far back as Aug 2000. The ONLY variable that is different now then when I used it in the past is my Operating System. I hate to be one of those Vista complainers, but that is the only change, although I do seem to recall something similar occurring when I went from Access 97 to Access 2000 running on the same PC.

    A couple of weeks ago, I upgraded my hard drive and loaded Windows VISTA instead of WindowsXP. Then I reloaded all my software. Last week I had an issue with missing reference in VB, which with Hans help, I resolved. Do you think this problem may be related to the change in operating systems?

  10. #10
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oriental Text in Query (2003 SR 3)

    I am using XP so I do not think Vista is at fault. I imported the table and query into a new database and built a new form...same problem. This is a good one.
    Thanks
    chuck

  11. #11
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oriental Text in Query (2003 SR 3)

    I just built a new query and no longer get the squares, but I do not get the date either.
    Thanks
    chuck

  12. #12
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oriental Text in Query (2003 SR 3)

    Chuck

    I have downloaded this database and the query I have doesn't look anything like the screen shot......have I missed something? Also the code doesn't work as the text boxes are name differently. Can you add what you have as it is driving me nuts <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  13. #13
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Oriental Text in Query (2003 SR 3)

    Jerry,

    I'm sorry, but the original screen shot was from a large database. I just recreated the form in Access, added a small table and created a quick query "sqQuery".

    Sorry for the confusion.

    Ken
    Attached Images Attached Images

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Oriental Text in Query (2003 SR 3)

    You can't use a control on a form as a column in a query "as is". You can, however, use it in the criteria, or in a calculated column, even if it is as simple as this:

    DateAdd("d",0,[Forms]![frm_IReports]![txtReportEndDate])

  15. #15
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Oriental Text in Query (2003 SR 3)

    Thank you Hans.

    Is there any significance to the characters presented in the query?

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •