Recent content by xxlu

Thank you very much for your help, Jack. I have tried as you suggested. But it does not work. After I entered the same NI as one of the previous record in the new record, the error message in the system displays. The message is: Run-time erro '64479'; The expression you entered as...

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

Thanks for your help very much. But I have tried "mmm", it shows "Invalid procedure call". So have to find other solution. Anybody can help?? Thanks a lot.

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, there is a simple way I used to calculate the nearest age. The formula for the calculate text box is as follows: =((DateDiff("d",[DOB],Now()))-(DateDiff("d",[DOB],Now())\365)/4)\365. You may try it.

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 encounter the same problem. I have a table to keep clients general details, in which clientID is primary key(autonumber). In another table Sales Order, I want to use combo box to select client to enter ordering details. Since there is possibility of two persons have same names (incl surname...

Thanks, ListO. I tried, but still there is problem. I set Bound Column Property to 3 for I want to display Name (Column Count is 3). But it still display CustomerID. I tired to set Bound Column to 1 or 2 or 3. Sometimes it can display Name, but when I enter next record, it returns to display...

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

Rich, I appreciate your help very much. Now it works. Thanks a lot!

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