Reports grid and footers: at last !!!

[guldo76]

I had a problem these days, about footers and empty grid lines. I wished to get a group footer just at the bottom of a page (and not where the records end); moreover, I was asked to perform a 'empty grid' to reach the end of each page.
WELL I DID IT !!!
And because this forum has been, still is, and always be so useful to me, I decided to let anyone who could care take a look at my work, hoping that someone could find it useful.
I made a little Word file with explanations, and attached it.

Tell me what you think of it, if you fell like doing it.

Bye,
Guldo

 

[azzurri]

I try to open the your zip zile after downloaded it, but a message appear as "Cannot open file:It does not appear to be a valid archive...It is so frustrating coz I had been looking the solution for the same problem and thought I could use yours.

Pleass e-mail to me.Please...

azrin_arshad@hotmail.com

 

[guldo76]

Sorry...

It was just my fault, sorry.
Anyway this file should work.

Guldo

 

[Sorrells]

guldo76 ,

I wish you had an example of what the results look like. I am searching for the method to create a report like the attached zipped Excel file. I believe I can create the report lines for the room and tasks. From another thread in this forum, it looks like I could possibly color code the tasks by their frequency (daily, weekly, monthly, etc.) but what is killing me is the blank cells that hopefully a person would check when a task is completed.

As noted in the attached file, the length of the cells would change depending on if it were daily or weekly or monthly. For example, if the report were set up on a MWF schedule and there were 4 weeks of the cells, then there would be 12 cells or checkboxes to the right of the task. All 12 would show for a daily task but a weekly task would have 4 cells that would be as wide as 3 daily cells each. A monthly task would be one cell all the way across.

Will you code help me achieve this? I don't need you to work it out, I just am looking for an affirmation that working with your code will be in the right direction for my objective.

 

[Sorrells]

guldo76 ,

I wish you had an example of what the results look like. I am searching for the method to create a report like the attached zipped Excel file. I believe I can create the report lines for the room and tasks. From another thread in this forum, it looks like I could possibly color code the tasks by their frequency (daily, weekly, monthly, etc.) but what is killing me is the blank cells that hopefully a person would check when a task is completed.

As noted in the attached file, the length of the cells would change depending on if it were daily or weekly or monthly. For example, if the report were set up on a MWF schedule and there were 4 weeks of the cells, then there would be 12 cells or checkboxes to the right of the task. All 12 would show for a daily task but a weekly task would have 4 cells that would be as wide as 3 daily cells each. A monthly task would be one cell all the way across.

Will you code help me achieve this? I don't need you to work it out, I just am looking for an affirmation that working with your code will be in the right direction for my objective.

 

[guldo76]

I think I'better know in more detail what does your db look like; anyway, this is a try.

Regards,
Guldo76

 

[azzurri]

Are you using Access2000 for teh sample report. I 'd downloaded it but message "Unrecognizable database format..." appear. Really appreciate if you could send Access97 format.

TQ

 

[guldo76]

See if you can read these.

Bye,
Guldo

 

[Sorrells]

Guldo,

I am sorry for taking so long, I knew your reply was there but have been sidetracked on other aspects of this program.

I have downloaded your sample files and believe I can leverage them for my report.

It will take me some time but I will return to this thread with any progress made.

Thanks for providing these!

 

[Sorrells]

Strange Stuff Going On!

Guldo,

I have been working with the logic you so kindly provided but have thus far been held back by a continuing series of Access errors dealing with my SQL statements. I mean almost beyond the point of frustration.

Today I napped on the dilemma and came to the conclusion that my SQL was not wrong, something in the environment was.

I created a new dB and imported all of the objects from 'different squares97' and by golly it ran!

Now this is a totally new issue apart from the solution I am seeking but I am curious; did you create the dB in Access97 or did you have Access2000 or 2002 convert it to Access97?

Just recently my client bought herself a new Dell loaded with XP and XP Office. And here am I working in lowly Access97. Well I found that I could 'convert' the 97 program to 2000 within Access2002 and it would run then. Except that it would not recognize the "=format" statement for displaying a date on the reports.

I did not have an answer for this problem but knew I had the same problem last week. Reviewing my documentation, I found that in my Access97 environment I had to create a new dB and move all the objects into it to resolve it.

Needless to say, I am a little concerned about the state of health of my Access program!

At least now I can get back to work. I might just reinstall Access!

 

[guldo76]

I'm sorry you had problems. I use Access2k, and converted the db from 2k into 97.

bye,
Guldo

 

[Sorrells]

Guldo,

You have done me a world of good! I made excellent progress last night! I should have something to show you in a couple of days.

 

[Pat Hartman]

It's hard to believe that in two years you haven't come across one of the reference errors posts. There are several each week. Any time you move an Access db to a different PC with a different OS you will run into a reference issue. This problem manifests itself in many different ways. The most common is that all functions stop working.

See this reference:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Sorrells]

Pat,

I guess I tend to remain as naive as possible until confronted by a shut door and no way around. I really appreciate your comments and link as I hope to eventually (like soon) create a deployable application on a CD. So I best pay attention!

Guldo my friend,

With your example dB as a starting reference, I have what I need to create the reports desired. I have attached a zipped file with the test dB I used.

It is creating nice color detail lines varying on specific criteria. I have changed shapes to labels and am including text from a data table where appropriate.

I am very happy with the result, so again thanks for sharing!