Search results

Hello Everybody, I would appreciate, if some of you can help me on report formatting. I have developed a complaint database, where I enter customer complaint, when I receive one. Every month I print out report, which is grouped by customer. Many a time, I have found that customer name has come...

Thanks Brad! I have added the expression. It is now working perfectly. Once again thank you very much. As I say always, this forum is very helpful to a novice like me. Jit

Clarification Thanks Kbrooks for your suggestion! I think, I have not made my thoughts clear. I have a complaint database, consisting of two tables, CustomerInformation and ComplaintRegistration, and having one to many relationship, (CustomerID primary key). When I receive complaint I enter...

Hello Everybody, This may look simple to many of you. However, my thing is not working. I have a form, which is linked to a Query. But, one specifice field of the form is linked to an another query. For that specific field, in property, control source, I have put following expression...

Thanks!! Hello Jack, Thanks for your inputs. I have solved the problem. I changed the 'Data entry' for the form to 'No' from 'Yes'. (I am a fool. Not knowing such a simple thing). Now I can navigate all records. Once again thanks for your help. This forum is very helpful for a novice like...

Hello Everybody, I would appreciate, if some of you can help me in this regard. I have a Complaint Database. There are two tables with corresponding forms for entering customer information and complaint information. The two tables have one to many relationship. I used Customer code as a primary...

Travis, this is the difference between an ameteur and a professional. I am a Quality Manager, and have wanted to develop a database to register customer complaints. A simple line of code, "On Error Resume next" has solved my problem. Thank you very much and wish you all the best! Jit

Thanks Travis Thanks Travis! I have changed the form's default value from single form to continuous and it is showing all records. Regarding the problem on closing dialog box, I would like to elaborate more. I have used a form named 'Customer'. On that form I have put a label, which, when...

Hello Friends, I would appreciate if some of you help me on these two problems about Form: 1) I have made a complaint database, where I register complaint received from customer. To know about complaint registered in a month, I have made a parameter query where I enter begining and ending...