gnawoncents,
In order to cut down on confusion (which is my fault), and to not waste your valuable time (cause you've been awesome devoting so much of it helping me), I've gone ahead and included my database in this thread.
Now this is obviously a stripped down version for many reasons, mainly because the normal version couldn't be zipped down enough to be posted, but you should have all you need. The crew van records...
wordbrew
Last Activity: Feb 18 '11, 03:53 PM
Joined: Oct 5 '09
Location:
-
Wow gnawoncents, I can already see the brilliant way you are tackling my problem. I'm still encountering problems, but I fear they are a lack of information on my part.
My row source for Combo21 looks like this:
SELECT tblEmployees.Ge msID, [Last] & ", " & [First] AS Expr1 FROM tblEmployees ORDER BY [Last] & "," & [First];
I don't think I included the [First] as relevant to...Leave a comment:
-
Wow. It would make me so happy if this were possible. You would = awesomeness. :)
1) I do have an employees table to store only one instance of each employee. It's simply titled [tblEmployees]. This includes the fields [NumberDaysWorke dPerWeek], [HireDate], [GemsID](which I should have included as relevant in the [tblVacationsubf orm] since it is a primary key), and [Last]. The table [tblVacations] which the subform pulls from uses...Leave a comment:
-
gnawoncents you have it exactly correct. Only one day is assigned to each record and the layout is just as you put in your example.
And yes, for my needs, what John Doe has would constitute a full week block, but Jane Smith (if she is a five day a week employee) having only 4 days together consecutively still wouldn't count as a full week since she has a fith day she is essentially breaking up and taking apart from the others. ...Leave a comment:
-
Thanks for taking a look at this gnawoncents.
In the table [tblVacations] that the subform is pulling from, the data type [VacationDate] is formatted in is Date/Time.Leave a comment:
-
How to count consecutive vacation dates for employees in text box?
Hello all,
I’m beginning to get a pretty good foundation in VBA, but I can’t wrap my head around this problem, even after trolling around the net searching through other posts that seemed remotely related. So I am hopeful that some (always) awesome and helpful Bytes brain power can be thrown my way.
If it’s even possible, I would like to be able to count the vacation dates that my employees have taken consecutively... -
NeoPa,
Just wanted to get back to you to thank you bigtime with your help earlier this week. I took your advice and used the report's query instead. Beside the query's field for [Rush], I added another column and put in the expression Expr1: IIf([Rush],"Yes",""), and then just referenced this expression instead of the original one pulling directly from the [Rush] query column.
And it's works great...Leave a comment:
-
Sorry NeoPa, I should have been more specific. That's my fault.
I tried your first solution, so that instead of having a control source of [Rush] in the properties box, I now have the control source set to =IIf([Rush],'Yes',Null). Currently, this is having all of the results return as "Yes", even the one's the used to return as "No".Leave a comment:
-
Thanks NeoPa for helping with this NeoPa. I've put this into the control source, but now instead of showing a few "No"s and one "Yes", it's now showing "Yes" for every record regardless of whether the checkbox was checked or not.Leave a comment:
-
Thanks for responding NeoPa. Actually no, I don't want this to filter out any records.
I want all of the records in the report to show, but where the field [Rush] would show a "No" if the checkbox is left blank, I would rather it stay empty. I would like this so that when scanning the report, you can very quickly see which records have a "Yes" value, because the "No" values are left blank. I hope this...Leave a comment:
-
wordbrew started a topic Want Report to only show yes if checkbox is checked, and blank if it's not.in AccessWant Report to only show yes if checkbox is checked, and blank if it's not.
Hopefully this has a simple solution either by VBA or in the properties box.
I have a report in Access called JeppList in which the field [Rush] is pulling the data from my form entitled OrderForm from a checkbox (also called [Rush]).
The report is working fine listing "yes" if the checkbox is checked, and "no" if it is left blank.
However, this list goes to an offsite vendor. Instead... -
wordbrew replied to How to allow a combo box result to be left blank after using has clicked the box.in AccessHey NeoPa,
Good to talk to you again.
I believe from a Code's perspective. I just want to bypass any chance of someone clicking on the selection, but for whatever reason they don't choose anything, and allow them to continue on. Right now if the combo is clicked but nothing is chosen from the drop down, it leaves the box empty, but with a blinking cursor, and then if they click anything else but the box, they get the jet...Leave a comment:
-
wordbrew started a topic How to allow a combo box result to be left blank after using has clicked the box.in AccessHow to allow a combo box result to be left blank after using has clicked the box.
This is just a weird nuisance that corrects itself if the user selects a value from the dropdown list, but I want to allow for the user not selecting something in the dropdown list, perhaps they look at their options but then click in a different field to start working on something else, without actually having chose something.
Ok, I have a subform (which is in datasheet view) on which are two fields fldAlbumLookup_ com and fldSongsLookup_ com.... -
NeoPa
Thank you for your advice. I shall definitely try it. And I myself am lucky to have the experience and flat out crazy skills of guys like you and Smiley, as well as ADezii who has helped me in the past, to call upon. I mean, you know, i just kind of imagine the kind of poster I would be happy to help, and try to follow that example. When you're calling upon other people to give up their valuable time to help you out, essentially...Leave a comment:
-
Smiley you are too kind. Gentleman and a scholar truly. And I'm grinning bigtime because I inserted your code into my call button for the report and it is working beautifully again. So thank you thank you. You rescued my database. It's too bad the regular query couldn't handle more information or I would have been fine in the first place. But, then again, if it had worked, I wouldn't have found a better workaround via your method of using the Filter...Leave a comment:
-
Smiley this is incredible! Thank you so much. You went far above and beyond what I could have ever asked. It's so amazing to have a community of programmers so willing and able to give their time to help make the rest of us better.
Lol. And thank you for the comments in the VBA, this way I can try to understand some of the key concepts so I can grow in my understanding of VBA and improve in the future. At least I was on the right...Leave a comment:
-
Alright, I've tried replacing and configuring the other VBA from what i could divine from your changes. I even went back and changed the names of the other boxes so I could make things look consistent. But I'm just not seeing something.
I don't know if it's because two of my combo's are based on value lists cmb_RevisionAud it, and cmb_Sort and/or my cmb_Year needs to sort just the year in the fldDate field in the query, which it was...Leave a comment:
-
I've put in the VBA code suggested by TheSmileyOne, but I think I'm just so new to the concept of filtering via VBA that I'm just fudging up somewhere. I'm including the database here, with the code i've put in. If someone could take a look and tell me where I'm going utterly wrong I would appreciate it. Hopefully I was getting close and just missing a key concept. But if I was way off base, then please giggle away. :)...Leave a comment:
-
Thanks so much Smiley, I'm going to try and dig into this today. I'm glad it's a VBA workaround cause I really need to keep honing my skills on it (which are minimal). To make sure, I keep my subform still based on the query I created, and I still put the criteria in the fields in the query design view, such as Forms!frmRevisi onAudit!cboRevi sionAudit (so that they still take their direction from the combo box on the main form) but I don't worry about...Leave a comment:
-
Thanks for replying Smiley!
All of this is done in Access alone. Unfortunately, what seems simple when entering into the criteria section of the query design view, bloats into a huge sql statement. I'm going to only post a snippet (which is still big) because posting the entire statement would too cumbersome. Hopefully this will give you the idea.
...Code:SELECT tblRevisionAudit.RevisionNumberLookup, tblRevisionAudit.BagNumberLookup,Leave a comment:
No activity results to display
Leave a comment: