Search results

I sign up for YouTubeTV every fall to watch the NFL. This year it's $77.37 (inc tax) per month. I run it thru a Roku Player. While I don't consider the navigation options in the interface to be all that undesirable, if you click on "Live" at the top and scroll down a bit, you can scroll...

Thanks, I'll try that but I think that there is an issue with one of the fields used for property description. So, I'll have to address that first.

Thanks for all your input. As I stated in the original post, some of the records in ParcelNum contain a letter or two - I didn't name the field. Thus, formatting this field with any of the numerical data types is not an option. It has to be text. When the column format is changed from number...

On to the next project. I have a text file that was exported out from our county's assessment office database. It includes all of the properties in the county. I imported this file into Excel and have a spreadsheet with nearly 300,000 rows. Each property has an identifier called ParcelNum...

ok, forgive my ignorance here as I'm new to this forum, but how do I mark this as solved and give credit to MajP for the solution?

Ahhh, I see what you're saying now (cranial light bulb illumination). And I agree that it makes more sense to resolve the overall issue rather than resolve the individual warning/legal action. Thanks for all of you help with this, I sincerely appreciate it. BTW, what happened to the file you...

wow, thanks for the ideas and all the work! I'll play around with that later as I've got a busy schedule for the next three days. ps: I like the check marks Does this chart make sense about the actions and resolutions?

@LarryE your close with my occupational assessment ;) @MajP I was going to experiment with conditional formatting as you suggested, or use VBA, or a query, to restrict what rows are displayed in the listbox.

I really dislike that I can't post the actual project/code and yes I understand that the abstraction is confusing. Let me try to put this another way. Let's say that Starfleet Command has ordered all Starships, regardless of class, to have their Dilithium Crystals replaced every 5 light...

@MajP OK, so my bad here and I really do apologize for the confusion as I was trying to mimic the actual table design and I missed a key element here (no pun intended). The Enforcement_T does have a primary key named Enforcement_ID and the Entity_ID is a foreign key to a table named Entity_T...

yes, i do capture the 2nd warning issued date and the legal action initiated date as well in the Enforcement_T. So, if an entity had a 1st warning issued within the last 30 days, they cannot get another 1st warning (back to my original question about combos or listboxes). If 30 days has...

to answer your questions: 1. the EnforcementDate is established when the user enters/records the action on a form. So if today is Tuesday and the 1st warning was sent out last Friday, the user would enter Friday's date instead of today. This date never changes or gets removed from the table...

Well, I guess it could be considered a status workflow - although the flow would stop if the entity meets the conditions where the 1st warning is resolved, which in turn would turn off that checkbox in the table. I see your point about redundancy but I wasn't sure how to incorporate that...

Hello everyone. Disclaimer: this project & it's data is confidential so I cannot post any code or the DB itself. I want to track whether or not an entity has been issued warning(s) for an infraction. The Enforcement_T has the following fields: 1. entity_ID...

Well, I'm not really all that good at talking about myself, but here it goes. I've got started with computers in the late 80's when I took some BASIC courses at Radio Shack. Attended college in the early 90's for computer science - back when the Internet was in it's infancy. We only had...