Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CrossTab Form (A2k3 SP2)

    I don't know if it's because I'm using Access 2002, but I get an error message that the VBA project in the calendar form is damaged. If I continue, the code module of the form is blank.

    But the answer to your question is no. As far as I know, you can only do something like that in a report, not in a form.

  2. #2
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CrossTab Form (A2k3 SP2)

    <P ID="edit" class=small>(Edited by gdrezek on 14-Apr-08 14:44. replace db in zip file)</P>Hi All,
    In the attached production planning db I have a crosstab form and report. I've used the month of the DateDue field as the Column Heading and can get 6 months worth of columns across. Is there a way (for both the form and report), so that if there are activities planned for beyond 6 months, to have those records display beneath the records of the first 6 months? with the proper month Column Heading? In the attached db, I have a record for month 7 (in this case, October). Is it possible to display it in the same position as month 1 (April)?
    Thank you.
    Attached Files Attached Files
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CrossTab Form (A2k3 SP2)

    Thanks Hans,
    I thought as much, but it never hurts to ask.

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> I receive the same error on trying to open the db in the zip as well, but it works fine otherwise. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> I also don't understand the Project stuff, I don't use projects. I'll zip and try another copy when I get home in a couple of hours or so.
    Thanks.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: CrossTab Form (A2k3 SP2)

    The error message means that the calendar form has become corrupted, you should delete it and either import it from a non-corrupt backup or reconstruct it from scratch.

    Even better, import all database objects except the calendar form into a blank new database, then import the calendar form from a non-corrupt backup or reconstruct it from scratch.

  5. #5
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CrossTab Form (A2k3 SP2)

    Thank you Hans.
    I know this is definitely a <img src=/S/pirate.gif border=0 alt=pirate width=22 height=18> of my own thread.......but, just to inform you of how I got here as I would normally do your suggested steps to try and save a database in development.
    The attached database was part of a much larger database originally designed in A2k7 SP1. Knowing that not all Loungers have 2k7 (1 smart chap, ain't I <img src=/S/wink.gif border=0 alt=wink width=15 height=15> ), I saved it as a 2002 - 2003 database, opened that in a virtual XP machine with Office 2k3 SP2 and culled and modified the database to be able to save it, compressed, under 100k. But now, when decompressing this db is when the error occurs. If allowed to open, the DrawLines Sub (attached as text file) heading is highlighted like so,
    <span style="background-color: #FFFF00; color: #000000; font-weight: bold">Sub DrawLines(R As Report, ParamArray xPos</span hi>())
    with the error: "Compile error: Invalid procedure call or argument.
    The pre-compressed, converted db opens and runs perfectly, as does the original in A2k7. So rescue is not an issue. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Thanks.
    Attached Files Attached Files
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •