apostrophies in names - Microsoft Access / VBA

Denis

Hi,

I have a list box that show up all the owners I have in a table. When
I click on a name in the table it displays all their information. When
I try enter a owner name with an opostropy eg Tom O'Reilly I get a run
time error. 3077. Is there a special way of entering an apostropy in a
name without it returning a runtime error.
Regards,

Denis

Feb 7 '07 #1

Subscribe Post Reply

2262

fredg

On 7 Feb 2007 15:09:30 -0800, Denis wrote:

Hi,

I have a list box that show up all the owners I have in a table. When
I click on a name in the table it displays all their information. When
I try enter a owner name with an opostropy eg Tom O'Reilly I get a run
time error. 3077. Is there a special way of entering an apostropy in a
name without it returning a runtime error.

Regards,

Denis

The problem is not with the apostrophe in the name it's in the code
used to return the record.
If your code is like [LastName] = '" & [Lastname] & "'"
change it to:
[Lastname] = """ & [LastName] & """"

For clarity only that's
= " " " & [LastName] & " " " "

Of course change [LastName] to whatever your actual field name is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Feb 8 '07 #2

Similar topics

Opinions about underscores in names

by: Kari Laitinen | last post by:

During the past 15 years I have been writing computer programs with so-called natural names, which means that the names (identifiers, symbols) in progarms are constructed of several natural words....

C / C++

Maximum length for table names, colums etc.

by: Jens Riedel | last post by:

Hello, we are planning to port an application from one database to different others, including DB2. While reading the GettingStarted document for DB2 Personal Edition I got a little confused...

DB2 Database

Capitalising names

by: dixie | last post by:

I have recently received data for a database where there are over 1000 people's names, all in capital letters (surnames and first names). I really need to be able to convert them all to lower...

Microsoft Access / VBA

[API] Win32 Resources - List Icon Resource Names

by: Mythran | last post by:

I wrote some code that is supposed to enumerate through the specified file's win32 resources and return a string-array of all icon names. When it runs, it returns a string-array with a bunch of...

C# / C Sharp

how to get function names from the file

by: Petr Jakes | last post by:

I have got names of functions stored in the file. For the simplicity expect one row only with two function names: printFoo, printFOO In my code I would like to define functions and then to read...

Python

Getting class instance names via reflection

by: Shawnk | last post by:

I would like to get the class INSTANCE name (not type name) of an 'object'. I can get the object (l_obj_ref.GetType()) and then get the (l_obj_typ.Name) for the class name. I there any way of...

C# / C Sharp

Function Prototype - different argument names

by: cybernerdsx2 | last post by:

Hi, I notice a function prototype being declared as following: FileStream.h ========= extern void openFile(char *__ident, int __option); But, in the function declaration part shown as...

C / C++

sqlite3 error

by: John Salerno | last post by:

Here's my script: import sqlite3 con = sqlite3.connect('labdb') cur = con.cursor() cur.executescript(''' DROP TABLE IF EXISTS Researchers; CREATE TABLE Researchers ( researcherID...

Python

magic names in python

by: per9000 | last post by:

Hi, I recently started working a lot more in python than I have done in the past. And I discovered something that totally removed the pretty pink clouds of beautifulness that had surrounded my...

Python

Arbitrary definition of class names by user agents

by: Steven Simpson | last post by:

Stefan Ram wrote (in "More than one language in a page"): Is this a new trend of user-agent writers (Microformats, and now Google) staking claims on the @class namespace? I'm surely not the only...

HTML / CSS

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice