HELP with Access!

[CHREC]

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

 

[Dolph]

the first looks like you've got a mismatch in names between the name of the field and the reference used for it in the code/macros that drive it. Double check what the field name is and go back through the statement and ensure that it matches exactly. It may also be that you've referenced the wrong form, sub form or similar when picking the field

For the second one it looks you need a requery command for the organisation details attached to the selection box as an on click event, as well as making sure that the text boxes for organisationd eatils are visible as part of the same event. You can also set the editable property to no as part of the same event if you don't want people to be able to edit existing details, and change it to Yes when the add new company button is used. Alternatively you could display the information as labels rather than text boxes, but that's a messy way of doing it.