Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quasi-crosstab format? (AXP 10.2627.2625)

    i want to print a grid for hand fill-in using the Report generator.

    The 'Row headings' are Names.
    The 'Column headings' are weekdays of next month.
    There are NO values in the grid.

    Since I cant figure out how to do this with the Report Generator, i am assuming that i need to use one of the OCXs - i presume FlexGrid would be typical.

    Is there another way to do this? If not, where is the must useful documentation? The MSDN is not helpful to me, a first-time user of an ocx.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    Peter,

    Make an empty table with one field for each day of the month and one more field with the name ID.
    Make a query with the empty table and the table names linked by name id. Set relation to show all rows of the name table.
    Now you have your grid.
    Create a report based on the query or print the query
    See attachment
    Attached Files Attached Files
    Francois

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    Second thought,
    make the report based on you names, and put 31 rectangles beside the name. In the header put 31 labels with the day number.
    Francois

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    To piggyback on that thought, you could have code in the report to hide labels for days that aren't used in that month, i.e., hide days 29 throught 31 for February in non-leap years. We do this with some reports in Access 97. Those are based on crosstab queries with column headings, and we simply hide a couple of controls depending on the month selected.
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    Thanks Francois & Charlotte for the great ideas!

  6. #6
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    i've been fumbling with the labels...

    Access names the labels 1_label, 2_label, etc, but trying to do something that begins with a digit in VBA is impossible.

    I renamed 1_label to a1_label, but i still can't get to the Visible property. Where is it?

  7. #7
    Lounger
    Join Date
    Nov 2001
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    It's hidden and I can't remember how to show it, but you can just type it in Me.Something.Visible=False

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    It isn't hidden. Bring up the properties sheet for the control. The Visible property in listed on the Format tab in Access 2k. I haven't looked to see if that is different in XP.
    Charlotte

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    These are the labels in the report header? What's wrong with lblDay1, lblDay2 ... or even lbl1, lbl2, etc.? Microsoft still hasn't figured out that while something_Label is better than just Label137, it still isn't good. They "encourage" naming conventions but don't use them in their own products. <img src=/S/aflame.gif border=0 alt=aflame width=15 height=15>

    Anyhow, I always rename my labels using the lbl tag to indicate it's a label and adding a descriptive string that tells me what the label labels! That way, I don't have to wonder when I look at a list of controls. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    The visible property can be set from code or from the properties sheet for the control.
    Charlotte

  10. #10
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    Yah, those are the label names, but in the detail header! Verrrrry inconvenient, because they have to be changed ere VB can grab them. <img src=/S/puke.gif border=0 alt=puke width=60 height=15>

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    The detail header? You have a report header and a page header and you have group headers. Have they added another kind of header in AXP?

    There are add-ins and code samples out there to apply naming conventions to your forms and reports. <A target="_blank" HREF=http://www.helenfeddema.com/>Helen Feddema</A> has sample code on her site to apply the Leszynski naming conventions, and it has been updated to work with XP. Somebody has one for the Reddick conventions too but I can't locate that one.
    Charlotte

  12. #12
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    woops - right! page Header. There are also Sorting and Grouping headers. Whether these are new to XP, <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> i havent been at this business long enough to know what's new.

    However, I have been at the programming business long enough to reject 'popular' naming conventionsas being too too UGLY, and make reading code arduous. Like putting warts on my objects <img src=/S/wartgun.gif border=0 alt=wartgun width=73 height=24> With all the comboboxes in the Access IDE that display Tables and Queries with 'Table: Yourtable', and 'Query: Yourquery', and icons all over the lot, I decided to discard the naming conventions in favor of my eyes. I did of course invent my own, which has a lot less 'noise'.

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    Since only a developer should ever *see* those objects, ugly doesn't enter into it. Eyes don't work in code, and naming conventions help enormously, especially when someone else has to maintain your code and figure out whether a variable is, in fact an object or a long or even a user-defined class or type.

    Actually, the "popular" naming conventions are NOT popular. It's only those who have been doing this long enough to recognize the benefits who insist on using them. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> My own boss refuses to name tables using tags ... but I'm working on him!
    Charlotte

  14. #14
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    The naming conventions were developed as a necessary self-defense against the poor design of the languages used for database work. I understand the paranoia involved!

    That your boss wont use them ... could be like the situation of cucumbers in brine: the cucumbers get more pickled than the brine gets cucumbered. I assume you know which one you are in that scenario <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

  15. #15
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quasi-crosstab format? (AXP 10.2627.2625)

    He uses naming conventions. He just doesn't use them for tables.

    I prefer to name my tables with tags because that lets me define in the name what kind of a table it is, that is, what it's used for. For example, I name my lookup tables tlkpWhatever and my join tables trelThisAndThat. That way, they sort together and I don't have to wonder when I look at a table list and need to pick one to add to a query.

    The apps we maintain (commercial apps) have an extremely complex means of updating the front end, and the design has evolved from Access 2.0 days. He just doesn't want to have to update all the pieces in order to apply naming conventions to the tables, thus potentially breaks apps running all over the world.
    Charlotte

Page 1 of 2 12 LastLast

Posting Permissions

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