Recent content by D-Angle

I tried using an unbound textbox in a nother subform which was set to show the most recent referral. Again, no joy. The patients' info is held in TBL_Patients and the referral infomation is held in TBL_Referrals, and it's the most recent entry in the field Discharge_Date in TBL_Referrals that...

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...

Got it to work within the report! :) The Dz function helped a lot, thank you. To get the number of questions I managed to count the number of fields that didn't contain N/A, but it didn't include any blank fields, so I counted those separately and added them together.

I'm hoping to avoid doing it in the query if possible, for various reasons it would be better to calculate it in the report. I can get it to sum and count easy enough, what I'm mostly struggling with is the additional criteria.

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...

Took a little bit of work to figure out the coding, but it works beautifully now, it loads each subform as the tab is clicked, closes the one that was open before it, and no more errors. Runs faster too. Thanks for your help guys. :)

Thanks, I'll try that. You're not far off. The information is currently held in an excel spreadsheet and I have been asked to move it to an Access format. The problem is the 63 questions need to be asked of about 15 different teams, and each question will have 3 answers, a self-assessment...

Not an option, the data being captured has had to be spread across 3 tables, Access wouldn't let me save it all in a single table as there were too many fields (63 questions, with 3 answers for each, plus a comments box for each question, plus the option to attach documents as evidence for each...

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...

Looks like I've got it, thanks. :)

That's still not working, the field is still blank. In the continuous forms view, the row displays '#Name?' on the bottom row that is for creating a new record. It then goes blank once you start entering data on that row.

This is great, but how do I employ it in the form? I tried creating a module called pwdGenerator with the code above, then making a plain text box for the Password field, and setting the validation rule as pwdGenerator(), but the field is blank when I try it. I also tried creating an unbound...

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...