Search results

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

hi... i have a function that check the value entered to the text box with value in a query call CALLRECORD. The field that i need to check in the query is a calculated field call MONTH that the value derived from field INSEPCTION DATE in the table Inspection Records - use in CALLREPORT QUERY...

HI, I left programming for about 10 years and now i am concentrating on a project for quality control. The main objective is to stored data regarding inspection activity. Currently I have 2 database, Table PRODUCT & Table Inspection Records. The fields are, Table PRODUCT :PRODUCT CODE(primary...

Hi all... I'm annie form malaysia