Search results for query: *

Thanks to both of you guys for the help!

Thanks Bob, but ..... my fault... I forgot 1 thing. I also want the report to show everything if [Tree] is all numbers. e.g 123 becomes 123 123s becomes 123 Thanks!

Hi, I need help to solve my report problem. I have a form called "Apple" and it has a value called "Tree" that is linked to a column in a table. The value of tree is a bunch of numbers that ends with a letter. e.g. 1s 12s 123s 1234s and many others. Now my Q is that how do make it such that...

Tom!!!!!!! Great work buddy! I have now finished the sales part of my db. I won't be bothering you anymore for a while now.... :) Thanks for your time and patience for sure. I've given you a star.... but I know you deserve more than that! Cheers mate!

Thanks Tom. Anyway... what stars are you guys refering to? (I'm new in tek-tips...) Can I give Tom a star?..... he deserves a planet!!!

HI Tom! It's great works like magic!!! Couldn't have done it without your help.... I really appreciate it! Now I have my last Q, u ready? :) I have acctually done this myself, but the outcome seem to be different from what I expected! Like I mentioned previously I made the print report button...

Ok... Ill do some more reading tomorow... I better get some rest now... havnt have much rest lately. Thanks for your help Tom. I really appreciate it. Cheers, Cheapo.

Acctually here's what happens. I have 2 different reports named "one" and "two". They are a copy of each other, the only difference is the text in the header, which are just fixed labels(some thing like Page 1(Accountant) and Page 2(Customer). .... and I am supposed to folow...

Tom, you'r the champ!!!! It all worked now!!! I followed your suggestion on drawing the rectangle around the subform and make the subform to be exactly 15 line. It all work out just the way I wanted... after spending the whole day setting up the page properly!!! It's a real pain! Design is fun...

Looking forward to it. Thanks Tom!

mmmmhhhhhhh doesn't seem to work for me. IF it's not too much trouble, can you send a blank database with just the report to my email address? TIA, Cheapo.

>"If I understand correctly, your Detail section will be a >subreport. Correct? " Correct! >"You probably can put in dummy lines if entries are fewer >than 15 by using VBA." What kind of code should I be writing? I dont seem to have any idea on how to go about doing it...

Hi Tom, The report is an invoice, but somehow that report is following a fixed format like I mentioned earlier. The header contains the customer details and invoice number, date. It comes from the table Sales(SalesID, CutomerID, Date) The detail section of the report contains the things...

Hi, I am having trouble making a report. This particular report must be 1 page in length. The format is the usual header-detail-footer. I need to make a fixed position for header and footer at the top and bottom of the page respectivelly. The details section occupies the middle of the page...

Hi Tom, I did what you suggested, but it did not work. I tried it with 5 detail entries and the first page contains the header and the first entry only. The second to the fifth entries are in their own individual page in page 2-5 and page 6 contains the footer. I have also tryed all other...

Hi, I am having trouble making a report. This particular report must be 1 page in length. The format is the usual header-detail-footer. I need to make a fixed position for header and footer at the top and bottom of the page respectivelly. The details section occupies the middle of the page...