Search results

I want to count the number of patients that have duplicate records or entries that meet specific criteria. More specifically, I have a listing of CVCs. There is an entry for each CVC for a given patient. I want to count how many patients had more than 1 jugular CVC, how many patients have more...

I actually have about 13 separate fields in a table I'm trying to summarize in a single report field. Each field corresponds to a particular action taken. If the action was taken the field value is 1, if the action was NOT taken the field value is 0. The report needs to contain a single field...

So I have several main forms which contain the same subform. This one subform contains ~4 Controls / Labels that are only necessary for one of the main forms. I'd like to hide them in all instances except when the main form is named "x". I think hiding them is most efficient. Database needs to...

I do not want this! I have a multirow Tab Control (only 2 rows). If I click on the back row (or top row depending on one's visual interpretation), the entire row moves to the front (or bottom row). The concern is that this will be confusing, and tabs along w/ their respective subforms will...

Page Break after subreport Dilemma: Suggestions? Ok. So I have one report which cosists of multiple subreports (>10). The main report and the subreports are not linked nor do they need to be. I want each subreport to start on a new page. Initially I added a page break before each subreport...

I have a database. Every table in that database has a field called "Site". When the database is opened for the first time by the end user they will be prompted to enter the name of their site. I want the value entered to become the default value for the field "Site" in every table contained...

I have a database. Every table in that database has a field called "Site". When the database is opened for the first time by the end user they will be prompted to enter the name of their site. I want the value entered to become the default value for the field "Site" in every table contained...

"Documents" Table - List of documents & related info. All document #'s unique. No Duplicates "Employee Training" Table - List of document / employee relationships to identify training requirements. Duplicate records with the same document #/info. I want this Employee Training Table to...

Ok... Hopefully I'll get a response for this issue. I'll try to keep it simple. I have two multivalue fields. One field indicates who should be trained on a particular document/procedure. The second indicates who has not yet been trained on the document/procedure. So I've successfully...

INTRO: Relatively new to all of this, but really enjoying the learning process. Great fun for me. Interested in learning VBA, so despite being a "newbie" don't be afraid to provide VBA solutions. Though if time and inclination permit, please, explain what is going on! ISSUES/QUESTIONS: I have...