Search results

How to terminate my boss? :)

David Crake R.I.P

Dear HiTechCoach: Yes, I love your idea of #2 which keeping the linked fields ,by the way, your suggestion with Nz() is more simple than my IsNull() to check combo B_year. Coach just cure my headache and I like to say thank you again and again. :) ps. I don't know why #1 can't work in Access 2007.

HiTechCoach, Thanks for your solution so quickly. Yes, that’s what I truly want. I had studied your mdb and found a new critical in query Cust_Q also break the parent-child link of B_year. Is there any possibility to keep the link between B_year and ExprB?

I success build up a parent-child link form when user select year of birthday from a combo box critical customer will show in the subform. Here is my question. I union the combo with “*” and want to show all records. But subform just show nothing. Below is the query. When I replace *...

I tried again but fail. This is my S_C_ID(combobox) cascade in the mainform. SELECT customer.ID, customer.C_NAME FROM [customer] UNION Select Null as AllChoice,"(All)" as allbogus FROM [customer]; And here is the afterupdate event of combobox. Private Sub S_C_ID_AfterUpdate() Dim...

I have the same combobox question. In the attached db file, there is a parent –child link combobox in the mainform and UNION query within “(all)” from custom table. When I select item from the combo subform will criteria update but “all” just show blank. Should I write VBA in combo...

Dear DevastatioN: Follow your helpful detail description and helppic I have made my calendar finally. Thank you very very much.

Hi! DevastatioN, Thanks for your suggestion, but there are just 5 events in calendar. On Updated On Enter On Exit On Got Focus On Lost Focus Where can I get the On Click event in Access 2007?

I have a birthday field in a form, then add an ActiveX Calendar in. I wish the birthday will update when I click the calendar, but it will update while lostfocus. Private Sub Calendar1_GotFocus() Me![birthday] = Me!Calendar1.Value End Sub How should I do? Please help me.