• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Not in list Process

When entering a new name into a Combo box with the Not in list set, I am noticing I can not enter a name with an Apostrophe.  like O'Keef. It allows O"keef but not the apostophe.
0
seamus9909
Asked:
seamus9909
  • 5
  • 3
1 Solution
 
IrogSintaCommented:
I cannot reproduce your problem.  Can you upload a sample database that exhibits this issue?
0
 
Jeffrey CoachmanCommented:
You may need something like this:

replace(YourString, "'", "''")

But again, you are not posting anything for us to investigate (sample db, sample code, sample formula, ...etc)
0
 
seamus9909Author Commented:
I attached the FE and BE databases.  on the reviewer subpage is where the issue is.  Reviewer combobox
DMC-Backup-Backup.accdb
DMC-Backup-Backup-be.accdb
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanCommented:
...and the steps to reproduce this issue are...?
0
 
seamus9909Author Commented:
In the Reviewers Combobox enter  michael o'Riley, press tab or enter , it will prompt you to add a new item to the list click ok, then  you will see the error.
0
 
Jeffrey CoachmanCommented:
<In the Reviewers Combobox >
The Reviewers Combobox where?
...on what form/table?

When the database opens, I am in the "Cases" (Open Cases) form, and there is a "TextBox" for the reviewer, not a combobox.
...and I cannot enter data into this texbox anyway.
0
 
seamus9909Author Commented:
Sorry open up the Case Details Form and you will see the Reviewers Subpage.
0
 
Jeffrey CoachmanCommented:
Then change the code to:

    strsql = "INSERT INTO Provider(Reviewer) " & "VALUES (" & "'" & Replace(NewData, "'", "''") & "'" & ")"
0
 
Jeffrey CoachmanCommented:
seamus9909,
 
Where do we stand on this?
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now