Search results

i know, i know!!! i do want to split it, but i am a novice at all this so it will just take me a while to work it all out, work out what will work with all the restricted folders and make sure the copied over blank Master FE "finds" their correct BE etc, etc. its going to take me a while!! :D...

Thank you The_Doc_Man. Unfortunately team members do work on multiple cases at any one time. Also its not just one person who copies over the file, again due to confidentiality issues & folder access restrictions. Most users are not competent with the details of access either. thank you though...

Thank you CJ_London So what i have is one open folder which all users can access. In there I store a blank no data master copy of the database. Users go to that folder & open the database then save a copy into a secure case members only folder. they then use to record confidential data. Its not...

thank you all so much. i have looked at fixing a few minor errors & considered spiliting etc. Unfortunately due to the nature of users i can not split it - basically users take a copy and move it to a secured folder per case. so moving the front/back end breaks the links in the master. Due to...

Basically, every case team has there own database as each team need to record confidential & different case information. So if split each team would need own back end & front end. Every year i update the database & copy over exisisting data to the new version to make sure each team has all the...

yes, sorry forgot to say...its not split.

Hello I have been developing a case management database over the past few years, every 6 months I make a few changes like new forms or reports and then a case team use it. Never had any trouble or issues. On the last update I had to convert the file to a 2007 format. The uses all have...

can't im afraid its confidential. but which properties do you need to see, the RAG field in the form, or report properties??

Hello - me again! i have just created a report on this form you helped me with but the value that we have calculated is not showing on the report, the field is just blank. i have had a look at the field/report properties & can't work out why the value is not showing?

PERFECT!!! thanks so much!

im sorry i still dont get it :-( im not sure which to use numeric or string. the "RiskRate" field on the RiskReg table/Form needs to come from the numberic results filed in the "RiskRAG" table, but i am looking up 2 text fields "probability" & "impact" from the RiskReg table to the RiskRAG...

so a table like this: IMPACT/PROB/RESULT H L 4 H ML 8 H MH 12 H H 16 MH L 3 MH ML 6 MH MH 9 MH H 12 etc, etc what lookup formular would i use then, i need to check 2 fields thanks!

sorry table not clear, but its basically impact H, Prob L then Risk Rag = 4 impact H, Prob ML then Risk Rag = 8 impact H, Prob MH then Risk Rag = 12 impact H, Prob H then Risk Rag = 16 impact MH, Prob L then Risk Rag = 3 impact MH, Prob ML then Risk Rag = 6 impact MH, Prob MH then Risk Rag = 9...

Hello I need some help with an expression for a field. I have a “RiskReg” table with a “probability” field (input options are L/ML/MH/H), an “impact” field (input options are also L/ML/MH/H) and “RiskRate” field. I need access to calculate the “RiskRate” field for me depending on the results of...

ID Login Password Access level 1 Manager *** Full Access 2 Investigator **** Full Access 3 Reviewer *** Read Only 4 Admin *** Admin

Hi CJ London, thanks so much. Please could you give me a bit more detail, i am a bit of a novice. I have an 'Access level' field on the Login table & for each user except Reviewer i have put 'full access'. on my login form this is my vba code to check the users are allowed in. Private Sub...

Hello I have been searching for hours for some help with users & permission levels. I have ready a lot about ULS (User Level Security) which doesn’t seem to be my answer as I do not have admin rights and I believe it is not suitable with Access 2010. Basically I have an 2010 Access database...

thanks very helpful

Hi CJ_London thanks so much for your response to this a year ago, I am finally getting around to adding this search as the database has been further developed. I have created a query with the fields i require but the results are incorrect and i get multiple results and it just doesnt really...

Hi Paul, i am using the above to transfer data from Access to Excel essentially because if i export a report fields are truncated to 255. Anyway, is it possible to do exactly the same but export the results of a union query, not a table? many thanks