Results 1 to 5 of 5
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Continuous Form Design (2002 SP-2)

    I would like to put an unbound memo field (if there truly is such a thing) in the header or footer of a continuous form. The purpose would be to create a text field concerning issues associated with the data in the continuous form, would be editable, and remain as entered until changed or removed. I have tried using a memo field, but it losses the data as soon as the form is closed.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

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

    Re: Continuous Form Design (2002 SP-2)

    An unbound control is, as the name implies, not bound to a field in the record source of the form. Therefore, the text entered in an unbound control is not stored anywhere.

    Do I understand correctly that you don't want the text to be associated with a specific record? If so, you would have to create a separate table with a memo field, create a form based on this table and put this form as a subform in the header or footer of the continuous subform.

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Continuous Form Design (2002 SP-2)

    Hans:

    The continuous form lists trucks that are available to load on any particular day, but there is nothing to tell me that a particular truck is not available (ie being repaired, etc). Normally I can just presume a truck is available if I haven't assigned a load to it, but sometimes I forget that one needs to go into the shop or a driver needs the day off. So, I just wanted something that worked better than the sticky notes that keep falling off my monitor. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> I'll give the subform idea a try (although I've never done one).
    Attached Images Attached Images
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

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

    Re: Continuous Form Design (2002 SP-2)

    I'm not certain I understand what you actually want.

    If you want to store notes with each record in the continuous form, you would put the memo field in the table behind the form, and put a text box bound to this field somewhere on the form - in the detail section if you want to see multiple notes, or in the form header or footer if you only want to see the notes for the current record.

    If you want a single, general notes field, use the method I described in my previous reply.

  5. #5
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Continuous Form Design (2002 SP-2)

    Hans:

    Now that I've made it clear as mud, your subform suggestion works perfectly (thank God you can read my mind). The field is, indeed, a general note having no direct link to the data in the continuous form. Incidentally (for those who may be interested), Access will not initially allow placing the subform in the header or footer of a continuous form; you will be prompted to have access re-set the main form in "single" view (click OK). After you have inserted the subform you can go to design view of the main form and re-set the default view to "continuous".
    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> . . .no more "sticky" notes! Thanks Hans!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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