Hi sxschech...:D
i understand now why my query doesn't goes well with the code... thanks a lot...you save the day...
Pat,
thanks for the tips...
Annie...
Hi sxschech
I've altered the code as per your sample but it return null value/new record in the subform...??? did u get this result as well. can you help me with this, i'm not very good in programming.
thanks
annie:)
hi sxschech,
thanks for the tips..the value appear in the subform as i wanted... but the main thing is i need to manipulate the value for filtering in my search form... when i enterend the value in the unbound text box for month in the search form, a dialog appeared "enter parameter value" for...
Here is the problem:
I have a form called "Search" that i want to display information with the control "Month". In my main datavase (info TBL) i have set a field name DOB which is set as Date/Time Data Type. In the Form Search the information will be displayed through a subform called as info...
Hi Paul.:)
I really need you help, some opinion maybe, I've attached the database that i use as "try& error" tools. The previous attempt to upload my database failed so using this clone database will give u some ideas. The last time i tried to search value between the range for " Date From" & "...
HI ALL,
I HAVE A FORM CALLED "SEARCH" THAT I WANT TO DISPLAY CERTAIN INFO FROM THE CONTROL "MONTH". IN MY MAIN DATABASE (INFOTBL) I HAVE DOB FIELD WHICH THE DATA TYPE IS DATE/TIME. IN A QUERY(INFOTBL QUERY) I CREATED A FIELD WITH EXP: MONTH:FORMAT([DOB],"M") TO GET THE VALUE FOR MONTH THAT I...
hi all,
can someone pls tell me what is wrong with this code..
Private Sub cmdSearch_Click()
On Error GoTo errr
Me.InspectionRecords_subform.Form.RecordSource = "SELECT * FROM InspectionRecords " & BuildFilter
Me.InspectionRecords_subform.Requery
Exit Sub
errr:
MsgBox...
i have a form call Search that uses to find records in my database with key "PRODUCT CODE" OR "INSPECTION DATE".. the form return the desired result when i enter only the product code. problem start when i entered the date as the text box is Date from as date to... the error appeared:
Extra)in...
Hi Paul,
i've tried to reduce the size of my file.. & still the file is too big to attach with this msg. any idea how i can deliver it to u? thanks
Annie