Recent content by akasmia

Never mind I found it in the SQL statement... works great ! Thanks ! AK

tomh1 I think it's a very good piece of code. I have tried this code in one of my combo boxes. It keeps asking me to enter SortOder!. What I am doing wrong?. Appreciate your help Ak

Hi TheAceMan1! Thanks... works very well! I have had to modify it a bit: Rem Try this........................................... If NewLastName <> "" And Not Me.NewRecord Then DoCmd.RunCommand acCmdRecordsGoToNew ' Me!cmbFindbyLastName = NewLastName <-- Generates err...

Hi TheAceMan1! Thanks... works very well! I have had to modify it a bit: Rem Try this........................................... If NewLastName <> "" And Not Me.NewRecord Then DoCmd.RunCommand acCmdRecordsGoToNew ' Me!cmbFindbyLastName = NewLastName <-- Generates err...

Thank you TheAceMan1 !. It works well but form does not show the new record for user to add the remaining firlds. I have had to add the following Me!cmboSearch_by_First_Name.Undo DoCmd.ShowAllRecords ' Find the record that matches the control. If Not...

Ok this is very simple BUT I am not making it work !. I am using a single table underlying the same form which contains the combobox cmbFindbyLastName. When I enter new data in the combobox the message generated by the msgbox function keep hounding me !. Keeps saying the same thing "smith"...

Ok this is very simple BUT I am not making it work !. I am using a single table underlying the same form which contains the combobox cmbFindbyLastName. When I enter new data in the combobox the message generated by the msgbox function keep hounding me !. Keeps saying the same thing "smith"...

Thank you hymn ! ..... but I am not sure what you mean by "you will need to refresh the record set ". When I use requery it does not work because then I find myself in an indefinite loop adding the same new data to the underlying table. I had to use break to get out of VBA's loop!. thanks in...

I have a form called Physical_Exam based on a table also called Physical_Exam. On this form there is a combo box based on the same table. It works fine except when I add a new name (new record) using the NotInlist event. The record I add is not automatically in focus for the user to complete...

This may be a simple task. How can I copy exact settings of Microsoft Access frome one computer to another (no netwok). Examples: menubar customarization, macos and buttons associated with them, autocorrect and spelling...etc. Is there a settings file that one can simply move to the next...

Thanks for your help. Finally got to work for the entire form. How do I limit my loop to a subset of checkboxes, is it possible?. There are times where I don't want to reset all check boxes!. Once again thanks for a big help!. AK

Here is the code segment: Dim ctrTemp As Control On Error GoTo Err_cmdSelectAll_Click For Each ctrTemp In Me.Controls If ctrTemp.ControlType = acCheckBox Then ctrTemp.Value = False End If Next DoEvents I am getting this error: 2448 You can't assign a value to this object.

Thanks for the the help Ken. It still gives me this error: 'type mismach'. I even cpioed your exact code!. I will try to teak it a bit more uless you have a suggesstion. AK

This is a simple thing but I am a simple user! I have form with many check boxes, radio boxes and text boxes. I would like to loop through the controls to changes their values. example There are 40-50 check boxes to be reset to false all at once (i.e. cleared or reset). I have tried using...

MY DATA IS A SIMPLE SET OF SHORT SENTENCES CHOSEN BY THE USER ON A FORM. THE SHORT SENTENCES ARE STORED IN A TABLE THEN DISPLAYED IN SMALL TEXT BOXES ON THE REPORT. THE PROBLEM IS THAT WHEN A SENTENCE IS NOT CHOSEN ON THE FORM THEN IT BECOMES BLANK ON THE REPORT. EXAMPLE: POSSIBLE CHOICES...