Search results

I want to use NI No as the unique identifier for customer. So when the user enter customer data into customer form, they must enter NI No first. If the value of NI No they entered is duplicate, that means this customer has existed on the database, then the warning message should be displayed and...

I extract the monthly report to count the number of new customers by using query. In my query, I group the data by using the field Date DatePart("m",[RegistrationDate]), the result comes with 1,2,3....12 to display Jan, Feb, Mar....Dec. How can I make these numbers into the format of Jan...

Hi, everyone. I have a problem in my report printing. I use a control form to extract monthly report. In my query I set a field with critria [forms]![controlform]![textbox]. I set an unbound text box in control form to enter value of the criteria such as 1-12 as month. After enter value in...

I have a form to keep record of sick leave and Holidays taken, fields [SickLeave]& [HolidayTaken], both Date Type is Y/N, I have a text box [SickDays], the control source =IIf([SickLeave]=True,DateDiff("d",[Date1],[Date2]),0) [Holidays], the control source...

I use combo box to search existing customers to enter into order form. But combo box just can display one field, either CustomerID or Name. But Name can not identify a customer cause sometimes two customers have same surname and first name. My solution is to use customerID to identify customer...

I place a command button in a form, with which I use it to open another form with condition of [ID]=Form![AnotherFormName]![ID]. It runs good when the form works not as subform. But when I click this button when the form works as subform, a dialogue box appear to ask for Parameter. Why it works...