Search results

Please see attached.

Here is my SQL view. I get the first couple of fields to work, but it is not filtering the middle column to only count "complete" tasks SELECT DISTINCTROW Assignments.[Category], Count(Assignments.Created) AS CountOfCreated, Count(Assignments.TaskStatus) AS CountOfTaskStatus FROM Assignments...

I haven't touched Access in a long time and can't seem to get started. I have the following report to produce. See attachment image. I'm pulling the data from a list in SharePoint. My table is called Assignments and I have the following fields; Category = "Legislative Communications", "Media...

Making a little progress. I added this to the cboPosition on the post-survey subform. "SELECT tblBaseline.ID_Base, tblBaseline.Position FROM tblBaseline WHERE (((tblBaseline.Dist_ID_F)=Forms!frmMain!Dist_ID)) ORDER BY [Position]; " It works great for the first record but does not detect when...

Thank you for your response. I appreciate the kindness in the words selected. What this is about. We have a trainer go into a school and hold a training session. They hand out a pencil and paper to the students and asks them a series of questions to see what they know about a given subject...

Matthew 22: 36-38 (Most Important Commandments - Love) Matthew 6: 14-15 (Seriousness of Forgiveness) Matthew 6: 14 drastically changed my life about 4 years ago. I never knew that about forgiveness. Love and forgiveness...

Anyone have any ideas that I should focus on?

Good question, I set it up this way because multiple folks from the same school will be completing the survey. The cboPosition on the first subform (pre-survey) pulls from a position table. The first person completing it may be a nurse, followed by a vp and so on. In short, one school may...

Okay...no responses after about 4 hours...guess I explained it wrong. Surely this is painfully easy. My post-survey subform does know what client record I have open. How do I get the subform to show data for that specific record? I've been reading about folks using SQL with a "WHERE" phrase...

I think I would ask, "Why can't humans just grasp the simple concept of love and forgiveness?" stike that... I may ask why he gave us free will to invent marketing agencies. Somewhere along our path we strayed. Now our worldly message is it is all about "Me" What's in it for me and screw...

Good morning all, I'm trying to use a subform and I cannot get the Position combo box on my Post survey form to sync with my current record. (Works great on the pre survey) Simply put, the combo box is pulling all positions from table and I need it only pull the data from my current record as...

Think I just found it Looks Like I found it. You gave me a word that I had not searched with, "Cascade" I was able to locate this site, http://www.utterangel.com/utterangel.aspx and selected the "Create Cascading Combo Box Sets" example. Looks like it will do above and beyond for what I...

Previously I've had two boxes up and running with no trouble but the third box is killing me. (more precisely the second box of the three) Oddly enough I get the first and third box working but the middle box seems to act odd for me. I'll look at what you typed up, expand it to three boxes...

First and Foremost...Thank you for hanging in there with me. I appreciate your patience. In your example, it appears there is filtering occuring in the bottom portion of the screen, however, the drop boxes have nothing in common that I could see. Another words, it does not matter what I select...

Humm, I don't doubt that I may not be doing a great job describing it, but I would have thought my screen shot or the existing 2 box working example in Access, or the 4 box example in Javascript that I provided would have done the trick. (My task is to link three combo boxes) There may be a...

Thank you for your help, but while close I don't think they are quite the same. I'm using the basic idea from this site: http://www.fontstuff.com/access/acctut10.htm but they only use two combo boxes. This would be an exaggerated example wth Javascript using multiple boxes. (Just showing...

Hope this helps -Screen Shot Screen shot... When the user makes a selection within the first box, the second box will only display associated items relating to that choice. When the user selects an option for the second box, only related items are displayed in the third box.

Hello World! Looking for Combo Box guidance please. A while back I posted a message (Combobox Brain Poot) and received lots of assistance linking two boxes. That scenario is still working great to this date. However, mgt. is now asking me to create three new linked combo boxes. (unrelated to...

I added the your line to the following existing code and it worked beautiful. Thank you. Private Sub Command4_Click() On Error GoTo Err_Command4_Click Dim stDocName As String stDocName = "Closed By Case" DoCmd.OpenReport stDocName, acPreview -->Me.Visible = False...

So I guess that means there is no code that one could add to the button on the form to execute after the button click to call the report, that would then close the form window...bummer.