Recent content by kobekaren

thank you very much !! it WORKS !! thanksssssssssss !!!!!!!

i have a question i want to use a text box to controp the content of the combo box. for example table [key] id key 1 xxx1 1 xxx2 1 xxx3 2 yyy1 2 yyy2 there is a text box called "id" and combo box "key" on a form when i fill the [id] text box , ie "1", then the combo box...

But how do i keep the "Apply Filter" Button Active while the Form is in Filter mode????<-----Yes , I got the same problem !! Can anyone help??

i built this event.... Private Sub Command39_Click() Dim x As String x = "All Current PC and Server" DoCmd.OutputTo acOutputQuery, "x", acFormatXLS, "All Current PC and Server.xls", True End Sub Of course , that is not correct. can anyone tell me how can i correct this and compile it...

O...thank you very much for your help , it works !!

hi, can anyone tell me how to deal with the following problem? there is a select query e.g. Query1 whixh contain the data that i want to export to Excel. i try to use OutputTo and it works. the excel file is served as a report. however, the column names in the exxcel file is...

It works smoothly....thank you so much for helping me to solve this !! thank you, RuralGuy

hi, i have a question about MouseWheel event ! in my access program, there are two checkboxes, for example, a & b, on a form with contain many record. sample record: no. a/b 1 a<---cannot be deleted 2 b<---can be deleted 3 b<---can...

thank you very much for your help! I will try your sample access file then !! thanks again!!

by using VBA, how can i filter the data by form by clicking one button on the form?

Oh....i have found out the my stupid mistake already. Thank you for all your help !! Again, thank you all !!

i have a combo box named "type" which is disable when the form is first loaded. when i click a button "new", "type" should become enabled. therefore, i built an On Click event on the "new" button which is like the following--> Private Sub hardnew_Click() Me.AllowAdditions = True...

can i do sth like this? -->Me![ComboBoxName].Enabled = False -->Me![ComboBoxName].BackColor = RGB(255,255,255)

Can i do something like this on combo box? -->Me![ComboboxName].Enabled = False -->Me![ComboBOXName].BackColor = RGB(255,255,255)

thank you for your reply ! but i have try this before , error message pop up !! the message is about "run time error 438: object doesn't support this property or method" i don't know how to do !