Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » MS Access - apostrophes

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

MS Access - apostrophes

Resolved · Medium Priority · Version 2007

Reply Fri 19 Nov 2010, 10:30Delegate Brian said...

Brian has attended:
Access Introduction course

MS Access - apostrophes

I have an MS Access 2007 that does not like apostrophes, which is a bit of a nuisance for recording organisations that have appostrophes eg. The Prince's Trust, National Farmers' Union. Is there a way of Access accepting them or any reason why my database does not?

Many thanks.

For upcoming training course dates see: Pricing & availability

Reply Tue 23 Nov 2010, 15:23Trainer Simon said...

RE: MS Access - apostrophes

Hi Brian,

Thank you for your question and welcome to the forum.

I believe there is an issue with Access 2007 when entering data into a table or form.

What I will do is have a look at a few forums on the net tonight and see if there is a workaround without using VBA code.

Regards

Simon

Reply Fri 15 Apr 2011, 11:13Trainer Rodney said...

RE: MS Access - apostrophes

Hello Brian,

Just a quick update on your question regarding using apostrophes in Access 2007.

After checking a number of forums etc. it appears that this is a problem in certain versions of 2007. My version of Access 2007 is the Enterprise version with all updates including SP2 MSO. I do not experience any issues when entering text into a table or a form using an apostrophe.

Check your version and make sure all updates are installed.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Reply Fri 15 Apr 2011, 11:13Trainer Rodney said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Access articles

· Supersizing your databases via Microsoft Access
· Learn About Action Queries In Access
· Microsoft Access: Unleash the True Potential Today
· Why Do I Need To Use Access?
· Manage Your Macros With Access 2010

Please browse our web site to find out more about
access courses and other Microsoft training courses.

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips