Hello there!
I have a little problem with access, I just started my new job as Administrator for a charity (CHREC) and it seems that their database may have been set up wrong. No-one here knows what to do so I am asking you lovely people as I have never used access before….
Here are a few of my problems…
1. We can’t print the labels for every organisation on our Database, only the councils.
2. We can’t change the perimeters of the labels
3. We can’t make organisation lists of names/ addresses/ emails
4. The addresses only come up on the database’s main form when you click “Add new contact” then cancel the action
For most of these things this message appears :
“The INSERT INFO statement contains the following unknown field name: ‘SchoolName’. Make sure that you have typed the name correctly, and try the operation again.”
To be blunt, I don’t know what this means.
Also the 4th problem looks like this:
Then once I’ve clicked on “Add New Group or Organisation” and cancelled that action is shows up like this:
BUT this can very easily be edited accidentally, which I really don’t want happening.
If anyone could help me that would be great (even if you say that I should scrap this database and start again).
Thank you!
Yours in desperate hope,
Elizabeth Bennett, Chesham, 20
I have a little problem with access, I just started my new job as Administrator for a charity (CHREC) and it seems that their database may have been set up wrong. No-one here knows what to do so I am asking you lovely people as I have never used access before….
Here are a few of my problems…
1. We can’t print the labels for every organisation on our Database, only the councils.
2. We can’t change the perimeters of the labels
3. We can’t make organisation lists of names/ addresses/ emails
4. The addresses only come up on the database’s main form when you click “Add new contact” then cancel the action
For most of these things this message appears :
“The INSERT INFO statement contains the following unknown field name: ‘SchoolName’. Make sure that you have typed the name correctly, and try the operation again.”
To be blunt, I don’t know what this means.
Also the 4th problem looks like this:
Then once I’ve clicked on “Add New Group or Organisation” and cancelled that action is shows up like this:
BUT this can very easily be edited accidentally, which I really don’t want happening.
If anyone could help me that would be great (even if you say that I should scrap this database and start again).
Thank you!
Yours in desperate hope,
Elizabeth Bennett, Chesham, 20