Search results

I have a database with 2 main tables that I am building for managing patients. The first table contains the patient's information, and the second table contains the details of each referral. They are linked by a unique id number for each patient, so you can only enter each patient once, but have...

I am trying to calculate a percentage to display in my Access 2010 report but am having some difficulty. Basically I have 10 questions, to which users can answer with a score of 0 to 3. Users can also choose 'N/A' as an answer if the question is not applicable to them. I have the scores in...

I have a tabbed form in my database, with 21 tabs. Each tab has its own subform. When I open the form I get the error "Cannot open any more tables" several times until it opens, and when it does the subforms on tabs 1-14 are loaded, but the subforms on 15-21 are not. Each of the subforms is of...

I have a database that is to be used to survey different teams, using the same set of questions. I am creating a form for each question so I can store the scores, comments and evidence for each team. This is stored in several related tables (there was too much data for Access to store it all in...

I work for a large organisation, and I created a fairly straightforward database for recording some compliance activity in my division. It can report by each piece of compliance, and by individual teams in my division. It works pretty well and has gained me some praise. :) Anyway, the...

I am trying to add a random 'password' to each new record in a table to be used over the phone when discussing information. Basically it would be a random word that both parties in the conversatiuon would have if they needed to verify identity, as a form of low level security. I have a table...

Hello all, first time poster and just getting into the more advanced end of Access, so be gentle. :) I'll try and explain this as best I can. I am building a database for archiving paper records. The records are kept in boxes, each of which has a unique box number. I have created a database...