Recent content by huertalm

fixed i had three different combo boxes. they were set to not visible on form load and depending on the option the user chose, it would make certain ones visible. i added a macro on the reports' on close option that closes the form. so the problem is fixed. thanks anyway!

well ive made some progress: when i put in this code under the group footer: Me.EndDate.Format = Format$([EndDate], "mmmm yyyy", 0, 0) i get this as the heading: jan0uary4 2003 jan0uary11 2003 etc

i dont want to have a report for each one because i dont think they would be used too often and i dont want to slow down my program. i already have 6 other reports that do other things so you can just imagine how many that will be if i make one for each period. the column headings arent just a...

i have created one multiple-column report that will display an employees stats by either week, month, quarter, or year depending on what the user selects. everything works fine but the column heading (which is the date) always displays as the last day. example if the latest stats entered on an...

i have created one multiple-column report that will display an employees stats by either week, month, quarter, or year depending on what the user selects. everything works fine but the column heading (which is the date) always displays as the last day. example if the latest stats entered on an...

FIXED I just added another group footer for the same field and changed the 'group on' property to "prefix characters" and the 'interval' property to "1". works like a charm. now we know.

actually i know exactly what is wrong with the report i just cant fix it. my report is in landscape and switching it back to portrait is not an option. although i do not have the detail section of my report visible the group footer is too long and so is the report footer. they are each about...

in the page footer section i have the "area" totals. in the report footer section is the "grand" total. ive already tried moving the area totals to the detail section and the grand total to the page footer section but this throws the report way off. ive also already tried the "cangrow/shrink"...

i have all my margins set to .25 except the bottom. it is .5. that is the lowest it will allow me to go. it is still printing the footer on a separate page

Fix So should i make the report with less columns, change the width, or change the height? my report footer does not print horizontally. it prints vertically like a column. if, for example, my report has 7 columns, 5 will print on the first page, two on the second and the total column will...

I have a multiple column report and the report footer is printing the "totals" column on a separate page. i have the page header set to "all". any ideas on what can be causing this and how i can fix it?

FIXED I figured it out. i just added a macro that closed the form. i called the macro on the reports close option. thank you anyway

i had originally created the form that way but for some reason i changed it but i will try it again to see how it works out. thank you

I built a database that keeps track of the school employees went to and the date they completed the school. i have built 3 reports. one called "byemployee" which shows just that employees info. another is called "byarea" which shows all the employees in that area and the schools they went to and...

I built a database that keeps track of the school employees went to and the date they completed the school. i have built 3 reports. one called "byemployee" which shows just that employees info. another is called "byarea" which shows all the employees in that area and the schools they went to and...