Recent content by GregG

Do all records have the year surrounded by parens? (2001) etc? If that is completely standard throughout your table, you could print just the car name with a textbox with a source of = left(CarDescField, len(CarDescField) - 7) which gives you the leftmost characters with a length of the...

Hi Natasha, Did you figure this out? If not, I think this will work. Edit the query "PDNPerStatusPerDiscipline" ... move to the field "PCN Designation" and set it's criteria field to "Variation" (based on your specs, you only want Variation records. Then cut and paste the following into a...

Ok, give this a try: 1) Create a Page Header section. The Page Header will have the company logo, etc and the customer name, address, etc. 2) Create a Customer Footing section. The Customer Footing section will have a textbox called CustTotal with a control source of =Sum([DetailLineAmount])...

Apparently, command buttons and hyperlinks can be placed on a report. Can you actually do anything with these? If I put them on a report, run the report and then move the mouse over them, the cursor turns to a magnifying glass that will only zoom in or out on the report. It would be kind of neat...

Hello folks, I know I could probably figure this out myself but I've got a deadline coming up. Using the menu dropdowns and dialog boxes in Access 2000, I am easily able to export a table via ODBC to our AS400: Click File/Export Save as Type: ODBC Databases Export tablename: tblAS400file...