Thread: Anyone can help
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Anyone can help

You're the one looking for help.

I was looking for clarification on where the time would be found to restrict
the possibilities to two records.

Your explanation went into combobox this and textbox that, concatenating
cells with the plus sign and changing a textbox with code and triggering
subsequent code in afterupdate - no it doesn't help me. I have no idea what
you are trying to do or what help you need.

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
Hello Tom,

here is the stages i was considering for the event:=

== combobox_click() == search through rows to find where
the date is used == if date is found, check the date is
not used in another textbox == if not put into current
textbox == continue through records and input in next
available textbox.....

== textbox1_afterupdate() == look through records where
combobox1 (date) and textbox(i) (time) are in row, use
cells((i), 2) + " " + cells((i), 3) + " " + cells((i), 4)
in next available combobox (there are only 2 of these for
each time!!) == the datalist for the comboboxes will
contain all records where there is no date or time set for
applicant...

== combobox(i)_click() == datalist will contain all
records where no date or time has been selected == if the
person is moved off the list, then the persons record
should be updated so that no date or time is available in
there record THUS person returns on list for other
comboboxes....

hope this is some help!!

thank you,

Robert Couchman

-----Original Message-----
Use the click event for a combobox.


Where is the time specified - how does the code to know

what time to use to
select the two records that occur at that time?

--
Regards,
Tom Ogilvy