Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

ms+access+courses - access formsprimary numbers

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms+access+courses - Access forms/primary numbers

ms+access+courses - Access forms/primary numbers

ResolvedVersion Standard

Joanna has attended:
Access Introduction course

Access forms/primary numbers

I want to delete an entry from my database. Previously I did this through the forms, however I now get the message coming up that I cannot delete a primary number. What has caused this to happen and how can I rectify it.

RE: access forms/primary numbers

Hi Joanna

From the detail that you provided, I can guess that you cannot delete the record because the record that you are trying to delete is linked to another record within the database, within the settings there are options where you can select to cascade delete, I would advise that you check these settings so that you may be able to delete records.

Hope this helps
David

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.