Thank you, Plog. Your suggestion is closer to what I need. Plus, I can also just create the first query you suggested, name it "MULTI_CVC", and then use the following function in the other query I've already been working with to summarize all of the CVC conditions/information...
Thank you, jdorste.
However, is there no way to do this with a function similar to:
Val(DCountDistinct("SUBJECTNUMBERSTR","FCRD_CVC01_ACTIVE","[CVCSITE] Like 'Subclavian*'")) AS SUBSUBCLV_PLACED
There are so many conditions and combinations that I need to summarize. I'm trying to minimize the...
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...
Thank you so much, CJ! Changing "And" to "&" (per your 2nd example) allowed me to do exactly what I wanted.
Also appreciate Plog's response as well. Useful info for future projects.
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...
Thank you though! Your suggestion did help. I put it with the first Tab Index Event, and just repeated the condition for each control.
Private Sub Text51_GotFocus()
On Error Resume Next
For Each frm In Forms
If frm.Name = "Daily" And Len([Forms]![Daily]![Combo139]) > 6 Then...
I tried your suggestion. Still no effect. Does it matter that the control is on a subform?
Regarding your second comment, I am not familiar with either. Would have to look into it.
Maybe an additional observation to note:
In other instances in this database when my "action items" are placed below the If statement, following a For Statement, nothing I want to happen happens.
WORKS:
"For Each frm In Forms
If frm.Name <>"meh" Then blah blah blah"
DOESN'T WORK:
"For Each...
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...
Ah... bummer.
Well, I initally considered the single row, but then some of the form windows are just obnoxiously wide.
I guess people are so maxed out with their other responsibilities they don't want to have to exert their minds in the slightest bit if they can help it. Oi.
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...
Thank you so much! For some reason this wasn't an option I had considered. I did a test with an unbound copy of one of my reports,and it did indeed print. Seems a tad odd that it will print subreports that are unbound, but not bound supreports.
I will keep this in mind for future projects...
So after scouring the internet without success and realizing that I probably wasn't going to get a response, I did some brainstorming and devised a solution. Sharing here.
It will require some additional work, but achieves the objective.
Basically, I created a query that counts the number of...
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...
Also, a second study may take place later which will require multiple user access. Do you have any advice on how to make an access database multi user friendly & protect data(base) integrity? This may be an even bigger issue than the one at hand.
I will admit that I am still familiarizing myself with what "proper" design entails exactly.
I did create the database from ground up. Unfortunately, I'm unable to share a copy of the database. However, I'll try to give some detail.
Data will be collected at multiple sites. A separate, raw...
Ok, I see. So then I can just do something like an update query based on that one site name table. But still I want an efficient way to update every table. Suggestions? Or is my only option to do an update query for every table via wizard?
I guess regardless of where I store the site name -...