Recent content by darno

Thanks... hi bob, it worked again. Thanks a lot man. Regards darno

Thanks but one more step... Hi bob, It worked again as usual, but there is one more step i need. I wish to print the whole name with dot also: for example your query prints Alaxander but not A.Alaxander i wish to see the names in the same manner as they were but sorted on 3rd character...

Hi Folks, I have a report which has employee's names with auto generated serial numbers. The Names in the list are like this: Y.Yong C.Lee Armstrong A.Baker A.Andrew B.David Alaxander David T.Philips C.David Z.Bony I would like to sort the above list to the following format: A.Andrew...

hi bob, U MADE MY DAY. GOD BLESS U. U WERE A GR8 HELP.THANKS A LOT REGARDS DARNO

Hi Folks, I have made a query based on employee's table. The query includes EMP_NO, EMP_NAME and GRADE as 3 fields. based on this query i have a report named Employee_Grades. I have kept the sort ASCENDING on EMP_NAME. the query runs perfect when it is run through query window. but when call...

Hi Folks, I have a field called "QTY" in my report that grows in length as the user enters more lines.All fields are surrounded with border.My problem is that when there is one entry in the QTY field the border stays ok but 2 or more items addition to QTY field would make the field to cross...

STOPHER and All Those Who Helped May GOD Bless You... The comments from stopher and The Doc Man are really helpful, I have taken a deep look at the table structures and relationships. Well as far as table structures are concerned, i used seq number field as code number just for a change...

Badly Need Help... I have checked the forum but none is similar to mine. Please just advice me one thing that on which field i may group and on which i may apply SUM. Regards Darno

Hi Folks, First of all i apologise for posting double, but i m compelled. I badly need help. i m not an expert like you guys. I hope someone will surely come to my rescue. I have a problem with summing values in a query that is based on 5 tables. In my form i have a text box which shows the...

Thanks Rural Guy U Made My Day... Thanks for providing such a gr8 help, and sorry being too lazy that i did not look at the link that u referred to. anyways finally i got the heck. But all thanks 2 U I m one happy man on this earth. Thanks again Darnos

I tried your link but stll i m clueless. I need to update my main form named HDRFORM having a text control named code No. I wish to update HDRFORM control from subform Named DTLFORM through a combo named combo111. Please help me. Darnos

update main form from sub form Hi There, I have 2 forms form1 (Main Form) form2 (Sub Form). Form1 acts as a header form and form2 acts like a details form. both forms are connected via code No. field. i have a combo box on form2 which on selection chooses code no and assigns corresponding...

Hi Folks, I m stuck, I need help on resolving an issue regarding Combo Box. I have two combo boxes on one form. Both of them are binded with same table. One combo shows Class No and the other shows Student Names and their roll nos. My problem is that my first combo box shows Class Nos but the...

Hi Everyone, I have posted this question twice but i did not get any promissing response that could made my day. I have a Database with one table. The database has a two forms. One is called Header Form Having following fields: ClassNo, RollNo, Grade, Name. and the other form is DETAIL form...

Hi Friends, Sounds Impossible But i believe there must be a genius out there to solve this I was wondering if there is a way to stop displaying fields on a form which contain spaces or blank values. I m using a query that takes data from a table named School I have a table which have 5...