Search results

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:)

happy birthday...

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

thanks sxschech...i'l try this immediately... annie

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

yes of course... any other way i can post the sample of my db... i'm not a internet junkie... so pls help with this

hi.. last time i tried to upload my db... failed.. is there any other way since the quota is sooo small.. annie

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

oh bob...thanks a lot... i get it this time... the result is great.... thanks for the help annie

thanks... such a silly mistake... but it didn't return any result... any idea?thanks annie

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

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 :)

Hi Paul, It is not sensitive at all, i can't upload the table, i've already deleted 70% of the data and zip the file... i'll try again... thanks:) annie

Hi Paul, . i happened to come across this msg when trying to open the Search Form... "This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field]...

Paul, pls refer to the attachment. thank you annie:)

Hi Paul,:) i altered my code to the one u gave me... there is no error msg appear, only that my form stay froze.. is there any other way... i am sooo lost i don't know what to do... i don't understand this vba programming technique, futhermore i left programming almost 10 years.. i can't...