Search results

just to be sure, it's qryPatientCases; enddate field: criteria: Is Null.

Between [Forms]![frmRange]![txtStartDate] And [Forms]![frmRange]![txtEndDate]

right. change the 'final' query. add criteria to the end date field: Is Null.

see if the attached helps.

see if this sample helps at all.

you could change the second combobox to a listbox and put it to the left of the existing listbox. not much different, but you would easily see a list of all (most) of the transactions right away. then you could click on the transactions list and update the next listbox. i'm pretty sure (didn't...

that's good. and lookups are not the same as actual relationships. yes, i set the relationships in the relationship window itself; it's the only way. creating links/joins in queries is also not the same; use the relationship window. oh, i see. that works. i didn't think they would link to the...

i think all approaches would be unreliable if you don't have something to identify the most recent case like a date or a checkbox. one thing you could do is create a query with the fields you want, sort the ID field DESCENDING then in the 'Top Values' box, enter 1 (or type SELECT TOP 1 ... in...

there are several issues, including, setting up relationships. have a look at the new form and queries as well as the relationships window. it still needs work but hopefully it will get you going. keep the names of fields the same from one table to the next.

left("001A020002 -001A150345",3) = 001 right("001A020002 -001A150345",3) = 345

i understand. it sounds tricky. and it sounds fairly crucial to the point at hand. toss some ideas around with relevant people, considering real world scenarios. how does one know if a case is closed, currently? what different/extra info would help? if necessary, a yes/no field might be your...

i think i would consider another table or two: - tblJobs (Landscaping/Plumbing/TV & Satellite/Electric Gates/Pest Control) - tblContractors_Jobs (N:N) instead of this many:many relationship tblDevelopments : tblContractors do tblDevelopments : tblContractors_Jobs then you can link a row...

hello haffy, welcome to awf. the question is rather broad, i mean, it's difficult without some more information. the answer depends on how the tables are set up. the basic answer is that when the listbox is clicked, update the textbox, or listbox with solutions. so, the textbox or listbox...

i think it would be best to leave the EndDate blank until one of the circumstances you described actually happens. you can still calculate how many days have passed for the current...phase?... by Now() or Date() - theStartDate. leaving the EndDate blank might be clearer. (so, including a...

how do you want to do it, theoretically? forgetting about the database for a sec, how do you want to determine if someone is there? how are you currently doing it? a check-out date? by checking to see if someone is in a room or not??

welcome to awf. check back here for responses but also be sure to search the forums for video store ideas. this has been covered in other threads.

hi lagbolt, i'm having some trouble trapping for nulls. seems to be in here, or similar: property get Address as cAddress 'this property might not be referenced for this object's lifetime 'in which case this code never runs if m_address is nothing then 'but if a consumer does reference...

i think i see. the example i'm looking at has declared Private m_PrivateCollection As Collection and Public Function Add(FullName As String, PhoneNumber As String, _ Rating As Integer) As cContact Dim newItem As New cContact etc... ' add to the private collection...

you could try: Public Function GetComboValue() As String GetComboValue = [Forms]![frmChallenges]!cboProvider.Column(1) End Function then put this as your criteria (with parentheses): GetComboValue()

i think the approach to collections is to separate them into their own class. cAppointment cAppointments etc. rather than write it out (and since i'm working on this myself) here's a link i found helpful...