Can
Printable View
Can
Morning Behemoth, im ok, and u? everything is fine this morning cept i have a little problem, i know i know this is chit chat but still...
when i select a value from a Combo box the value changes the contents of the combo box it self, i want the Selected value to stay in the combobox.text after it being selected but when the combobox contents change it changes another combo box and when that combo box changes it clear the combo.text value in the first to nothing????
the code is a little messy as ive been playing with it, i can upload the whole program if required but this will need a few extra controls.
ThanksCode:Private Sub cboCalDept_Change()
fraDetails.Caption = DETAIL_CAPTION & cboCalDept.Text
If DeptExists2() <> True Then Exit Sub
If cboCalDept = DEPT_CAPTION Then Exit Sub
Call FillCombo(cboCalDept, cboCalEmployee, False)
End Sub
Private Sub cboCalDept_Click()
Call cboCalDept_Change
End Sub
Private Sub cboCalEmployee_Change()
If EmployeeExists2() <> True Then Exit Sub
If cboCalDept = EMPLOYEE_CAPTION Then Exit Sub
Call FillCombo(cboCalDept, cboCalEmployee, True)
End Sub
Private Sub cboCalEmployee_Click()
Call cboCalEmployee_Change
End Sub
Sub FillCombo(sDept As String, sEmployee As String, bEmployeeSelected As Boolean)
Dim DB As Database
Dim RS As Recordset
Dim sSQL As String
Dim iCount As Integer
Dim X As Integer
Set DB = DAO.OpenDatabase(DBpath, False, False, ";pwd=" & DBpassword)
sSQL = "SELECT * FROM employee WHERE dept = '" & cboCalDept & "'"
Set RS = DB.OpenRecordset(sSQL)
Select Case bEmployeeSelected
Case True
Dim sLastEmployee
sLastEmployee = cboCalEmployee.Text
sSQL = "SELECT * FROM employee WHERE employee = '" & cboCalEmployee & "'"
Set RS = DB.OpenRecordset(sSQL)
cboCalDept.Text = RS!dept
cboCalEmployee.Text = sLastEmployee
Case False
cboCalEmployee.Clear
sSQL = "SELECT * FROM employee WHERE dept = '" & cboCalDept & "'"
Set RS = DB.OpenRecordset(sSQL)
RS.MoveLast
RS.MoveFirst
iCount = RS.RecordCount
Do Until X = iCount
cboCalEmployee.AddItem RS!employee
RS.MoveNext
X = X + 1
Loop
cboCalEmployee.Text = cboCalEmployee.List(0)
Case Else
MsgBox "Unexpected Error! Please contact your system administrator", vbExclamation, "Error"
End Select
End Sub
Simon
Dont worry i have it working now;)
Ive just got a new account manager at PCworld (its a bloody man arrrgghhh) and i got somit really dodgy attached to a email from him...let me know wat u think.
Good morning everyone!
hi babe. U ok?
Yep..thanks for asking. I got a little more sleep last night. My husband is staying home with my daughter today so at least I know she won't be alone.
How's your day so far?
you really dont want to know. Ive got to put this horrible ointment in my eye after yesterday. I've taken to calling it satan's snot (well actually something a little more tasteless that im not prepared to divulge in here). Im bored, tired and depressed. but lets not bring everybody else down...
I'm fine thank you...
Sorry to hear about the eye. Have you made up a good story about how it happened yet....you could get really creative.
it quite cool to tell people i had a chunk of metal removed (cos thats what it was - and it had started to rust!), but if you've got any cooler stories, let me know.
Hi all...
We got ANOTHER 9 inches of snow last night, and they said that the worst is to come tonight. I tried to get my son out to his daycare this morning, and had to turn around. When I got back on the main road, a semi-truck passed me in oncoming traffic and blew up so much snow and the truck behind the first truck almost ran into me head on because he couldn't see though the blowing snow. I amazingly found a backup daycare only about 15 blocks from where I work.
So, it's been quite an interesting morning for me.
(I'm exhausted already)
i always forget its only morning now for our cousins across the pond. hi anyway. its 3:40pm here. and im tired.
Were you climbing Everest in a blinding snow storm and hammering in a piton into a ledge and unbeknownst to you a shard of metal sheared off and was left in your eye? It was discovered just in the nick of time by a beautiful woman who was gazing deeply into your eyes in a moment of passion or you would have lost your sight. That would be pretty cool!
Good morning Shanea. Sounds like you should have stayed home with a fire and a nice big cup of coffee!
is that believable enough?
do i need more evidence? a beautiful woman perhaps>
I wish I could have stayed home, but they are starting testing on my project in 1 1/2 weeks and I have a lot left to do yet. If I stay home and dial in, I get distracted way to easily. The computer is in the activity room in the basement right next to the TV.
I'm sure there must be some beautiful woman around you that would cooroborate your story! Don't you think it's much more exciting than "I don't know how it got in there"?
here's a more surreal one.
I discovered yesterday that I am an android. The past 2 decades plus I have been living under the mistaken believe that I was organic like the rest of you. I now know that is not true. Not only am I a man made bi-product of the technological age, my structure is decaying. My optical organs are rusting, and I am preparing myself for recycling.
A sad, sad life...
I don't know if it's any more believable than mine but it is definitely cooler!!!!!!!!!!!! I'd stick with that one!
mind you, i could be a mountain-climbing dying android with a beautiful woman...
possibly a little over the top?
The story just keeps getting better!
im thinking of writing the screenplay...wanna be my casting director?
I wanna play myself. if ive not been deconstructed for scrap by then
Sure!!! Sounds like fun! We could make a billion or two and then buy out Microsoft...what do you think?
fantastic...
where do we start then?
You could be a mountain climbing dying andriod that saves the beautiful lady from dying on the mountain. In the process of saving the lady, a huge rock falls on you and crushes your body. Your head is still OK, and beings as you saves the woman's life, they build you a new and improved buff body. The woman loves your new body so much she runs away with you.
I should have wrote a book.
Ha Ha
thats as maybe, but the damage from the rock has caused irrepairable damage to my eyes. they're rusting and going blind...
Thats the emotional bit taken care of then...
At the last minute, they come up with a new way to replace your eyeballs with new eyeballs that have x-ray vision. (You always wanted blue eyes anyway...they drive the girls crazy.)
whats wrong with my deep brown eyes?
****Editting last comment****
At the last minute, they come up with a new way to replace your eyeballs with new eyeballs that have x-ray vision and can change to any color you want anytime you want. This will help you change disguises easily as your new career as a spy.
Ok, smh, your my screenwriter then.
Katie - any news on the cast?
Do I get to write smutty stuff?
do you want to write smutty stuff?
Not too smutty....but I don't know of many best sellers out there without some smutty stuff.
well, i think you'll have to mail it to me then...if you leave it out in the forum, who knows who'll get they're hands on it. remember most of the kids in here are minors...
I won't right that smutty!
Ooops! Write not right. Where is my head today?
well, im off home in 5 mins, so can you come up with anything award winning for me by then?
Great minds take longer than five minutes to make a work of art! It would take me at least six minutes.
Ha Ha
I try to throw something together for tomorrow. Have a good night!
Somebody give me some names to use for the cast members.
oh well, nice try.
Katies sorting out casting. speak to her.
See you all tomorrow...
I hate it when work gets in the way of fun...don't you.
Anyway, I'm back just in time for the star of our drama to leave. Have a nice evening B and I'll keep working on the cast list!
It's pretty sad that my mind can wander so far from what I am doing that I have half of the play all jumbled in my mind already.
evening all :)
I've already got my new job set up and I start monday. I'ts actually doing vb for a change instead of my usual web stuff. This means i'm not guaranteed to have web access, so I still might not be able to have fun on here during the day :(
Not good........Although I am very happy for you about your new job.....you will be missed greatly! You can still chat with us from home though right?????
thabk you for those kind word's katie :D
Yeah, I'll still be around in the evening's (most anyway) as I'm not working away from home :)
I meant every word of it....I would really miss you! Will you be going to Paris with this position or is it a new one?
Evening all!
Ian -- so you're off to Paris?
Good morning Parksie......how are you?
Hi Parksie.
I just ran next door to the grocery store to get a yummy hot Italian dip for lunch....AND ITS SNOWING AGAIN!
Will it ever stop?
There is a saying:
"Little flakes big snow, big flakes little snow"
Mother nature needs to decide what she's doing, because this morning it was little flakes. Now its big flakes. They are about the size of a penny now. I WANT SPRING TO GET HERE!
(If you can't tell, I am very burnt out on snow. He He)
*Stumbles into the lead*
Katie?
Have you ever seen a movie called "A bronx tale"?
The reaon i ask is because of your signature about the 20$..in the movie there is a part that is similar to what is said in your signature.
Sorry about the delay, a mate just came round for a quick chat.
no, as it turn's out i'm not going to paris.
As I might of explained before, I'm not actually a freelance contractor. I work for a company here in hasting's that contract's me out to everybody. The company basically trains new people, who sign there life away to work for them for a set amount of time. there is about 150 people like me employed by them to do the same thing. I went down this route because I needed a way to get into the IT market and this seemed the easiest way. i've only got to work for them for another 10 month's and then i can do what ever I like.
As well as doing this, they have also become a software house and a microsoft certified partner and are growing quite a large client list of big companies.
So going back to today, I go into the office's and my boss grab's me into the office and ask's wether I want to work on a new project for 3 month's in house. So I think to myself hmmm, Either get a new contract somewhere where I have to travel to or stay away to do my work, or get up at 8 and have a 15 min car drive to get to my offices. No guessing what I said. :D
But the only downside is that when in-house, they don't normally give you net access unless you need it, so as i said, I might not be round here during the day
Ian
Sounds like a dream...no commute!
Jeff...yep I've seen the Bronx Tale...
Is anyone else having trouble with posting today?
I'm having a lot easier time posting today than I did yesterday. Yesterday I was having big problems until about 3.
yeah, i'm having problem's
can't seem to post anything at all ;)
Nope. No joy posting here :D
still can't post here
It takes two or three tries complete with server not responding errors etc. A real pain in the arse.........but worth it to chat with such charming gentlemen!
Ian == gentleman
Parksie == psycho violentman :D
your too kind katie :)
Right, I'm off to sign up for the local gymn. I'm not fat but i'm not that healthy either and as I haven't got load's of travelling to do now, i've will have the energy left to work out. Watch out jean claude van damme, here come's Ian ;)
speak to you soon
Ian
I am not a gentleman....
Night Ian.....BTW I've heard VanDamme is about 5'5"....are you short too?