Recent content by Christopher770

I was just curious if anyone had developed a template (of sorts) that allows follows a generic patch for System Functional requirements and use cases. While every situation of development is different, it seems like a generic tool could be developed to allow FR and UC to be entered and...

Probably a poor title. I have a very detailed scheduling report that changes frequently. Name: Schedule|Key = TID. TableID=tblSchedule; report = rtpSchedule I need to email these schedules to the owners of the TID. The owners of the TID are in another tblTermList. tblTermlist|CT1TID=...

Oh..one other thing and probably more importantly, can you suggest a link that specifically defines the demarkation of the syntax. I have yet to find something that clearly defines the use of the double quotes ("), single quote('), and the ampersand (&) and what exactly their function is.

First thank you, but now a new error. (see attachment). The result it shows is one of the values that would have been selected from the first CBbox lookup. However, the desired result would/should be a numeric value.

UPDATE: Update: I have been dicking around with this for 2 day's and still stuck (I'm being reminded of one of the definitions of a moron; keep doing the same thing over and over and expecting the same results) Code: Me.P1DMIL = (DLookup("[SWD]", "tblDSP010", ("[SWFROM] = '" &...

Wow!!! Thank you for that! I hope you didn't create this just for me, however if you did, I'm humbled by your generosity. Visually this is what the users want to see. I'll have to tinker with the math for to account for midnight cross-over. But I believe I see what you have going on here...

I need to create a visual representation of time to illustrate gaps of time between two segments of time. File: Schedule ID Depart Time Depart Day of week Arrival Time Arrival Day of the week. Equipment ID Example of desired result: Schedule A Departs at 08:00am and arrives at 17:00pm with...

Very nice - of course an unsecured example to access the code would be helpful. Just saying...

lol...I know...I jinx myself when I say that. Thanks again!

Just a quick followup note: I did use the Dmax example provided. I did modify it slightly, because the Two TID fields [ATL] & [JAX] are derived from another table, and these had to be concatenated first, then the new Dmax numeric value determined, and then the final concatenation which...

Rainlover !!! Thank you. This is EXACTLY what I'm looking for.

Table1: Location ID = "TID" 5 byte text field. This must be alpha. There are thousands of location id's. To this end, each location ID can be pared with another location id. Consider this as a FROM and TO location, like an airport location. And, they can be paired an unknown number of...

I apologize if this is not the right forum! Table with Two Alpha ID's [TID1] and [TID2] Independently, each are unique I need to concatenate them for form [TID1]&[TID2], no problem but i need to add an auto increment number starting at 1 I created an unbound form with two unbound text boxes...

SOLVED: Solved by post from Kafrin #204582, but I cannot post the link here. 'His code -------------------------------------------------------------------- Public Function RepString(ParamArray Tests() As Variant) As String 'Tests() requires pairs of values - the True/False from the check box...

Thank you - I know this was posted many moons ago, but I've been look for an answer to this for days.