Search results for query: *

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...

This gotta be the simplest question!. I apologize ahead of time. I have a form with text boxes, check boxes, option buttons, toggle buttons, and command buttons. I am using this form to collect data from customers. This form is not based on a table or query. I would to generate a report from...

AFTER WINDOWS 2000 PROFESSIONAL BOOTS I KEEP HEARING HARD DRIVE ACTIVITY FOR UP TO 30-40 MINUTES!. NO PROGRAM RUNNING, TASK MANAGER DOES NOT LIST ANY RUNNING PROGRAMS. ANY THOUGHTS.

Newage: All I know is this: Example: you want to solve this equation X^2-X-12=0 Use a cell as a variable e.g. A1. Use another cell, say B1 as the &quot;target&quot; and put the equation in it. Put =A1^2-A1-12 in B1 before you use the solver the result will, of course, reflect whatever...

Thanks TOM that was great!. After posting my question I was able to write a small function called MAX(DATES...) which seems to have solved the problem. Of cource now I have your function just in case. There is also s small function called IsNothing in John Viedcas CD which seems to work for...

My array of dates contains blanks or zeros, pending on the user. I have only 4 dates DATE1, DATE2, DATE3 and DATE4 to sort and obtain the smallest date. Example: DATE1: 12/3/02 DATE2: blank DATE3: 1/12/03 DATE4: 4/14/04 I WOULD LIKE TO SORT THE ARRAY AND PICK 12/3/02. I AM RUNNING INTO...