Search results

My list of people that we need different staff to assess and key in data changes every year and i need to keep previous data on record so i was thinking of just archiving each year's file and copy and paste to create a new file with a new list of people each year rather than have all the data...

The purpose of my database is more for people to key in data on on a group of people for us to generate reports and maybe analyse the data. Once the data is all keyed in, i will remove the front end since there is no need for it anymore and create a new backend and front end for the following...

All i need users to do is to key in data in the forms on the front end. Does that causes any versions etc to change since i should not be making any changes to the database anymore? Will i still need an auto update tool or just copy and paste the front end file to individual desktops will do?

Do i just ask everyone to copy the front end database file on to their own computers and run the file from there? First time creating a database for multiple users so unsure about how to get the whole thing running well.

Its already shared. I've also enabled all marcos as adviced from another site but it doesn't seem to work as well.

Hi, I've prepared a front end database with forms that allow data to be keyed into linked tables to my main databse. However, currently the front end database only allows 1 user to do it at 1 time and when another user tries to open the file, an error "The Database Has Been Placed in a State...

That field would be a text field instead of a number field

That works. Thanks alot and it saves the effort required to manually enter each rating :)

Hi, The formulas given above is used if for example [Staff], [Student] or [Peers] is blank. However, if i want to fill in a number for 2 of them and write NA for the 3rd, can the formula be modified to allow that since its no longer a blank field but a text field to get the average of 2...

All the calculations are done already in a query. I just need to use a form or any other method to fill up rating base on that score which can then be printed on a report with all the results and rating. Sorry quite a noob with Access so totally clueless about SQL or VBA stuff...

Hi, I have created a query to calculate an average score of a list of attribute used to grade a list people and from this average score, i need to give them a rating. Is there any way for me to give each individual a different grading either using a dropdown list or manually keying in the...

Hi, If i want to do something similar to the above but instead of leaving the value empty, i want to write NA so that its understandable when i print the information out in a report. Can that be done?