RE: I think I know what to do.
From: RusCat (RusCat_at_discussions.microsoft.com)
Date: 09/22/04
- Next message: anonymous_at_discussions.microsoft.com: "Vertical Scroll Bar in ListBox"
- Previous message: Allen Browne: "Re: Formatting Text Box"
- In reply to: Dustin Ventin: "I think I know what to do."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 09:25:02 -0700
Dear Dustin,
Thank you so much for your reply. This has been a real problem for me to
solve.
Of course I have another question to ask:
How do you format it so it looks like a report? If you can help me get it
to look more report like, I will be forever indebted.
I've got the continuous forms thing working, but all that did was add a
scroll bar to the right side of the form.
This is such a frustrating problem for me. I had orginally created a lovely
report, with color and heading and such. The Boss really loved it, but the
web addresses didn't work. I told him "no sweat" I'll just "turn them on".
:-( Boy, little did I know how hard it would be for me.
I would so appreciate anymore information you can pass along.
Thanks,
Lisa
"Dustin Ventin" wrote:
> It seems as if your main problem is only seeing one record on a form at a
> time. The way to fix this is simple:
>
> 1. Open your form in design view.
> 2. Right-click the box in the upper-left hand corner and select
> 'Properties'. This should show the properties for the form.
> 3. Make sure the 'Format' tab is selected in the Properties window.
> 4. The property second to the top should be 'default view'. Click on the
> drop down box and select 'continuous forms'.
>
> Whatever fields are returned by the form will be printed one on top of the
> other, and can be formatted to look rather like a report. Additionally, you
> will be able to click and follow the links.
>
> As a note, remember that forms set to 'continuous forms' cannot have
> subforms. Hope that helps.
>
> Dustin Ventin
>
> "RusCat" wrote:
>
> > Good evening,
> >
> > I'm a novice Access user. Here is what I'm trying to do. I'd really
> > appreciate some input or suggestions for getting this to work.
> >
> > > My company has a small library of reference materials.
> > > I have inventoried and entered them into a Table called LIBRARY
> > > One of the fields is the website, which I made a Hyperlink
> > > I have designed a Report and am able to pull up all the library information, so my colleages can scroll thru it, many records at a time . The hyperlink shows up as blue, but isn't "active"
> > > Thru my research on this site, I discovered that a report won't let me "activate" the hyperlink.
> > > I designed a form and the hyperlink works GREAT !! I'm very proud.
> >
> > *** here's the problem.
> >
> > 1. The Report shows everything, by subject or category, and the user is
> > able to scroll thru the entire contents, but no access to the website for
> > said material. IE: 115 library items shows up on 11 pages of report. It's
> > a nice report, all grouped by category and subject, etc.
> > 2. The Form allows access to the websites, but only allows the user to
> > scroll thru ONE record at a time, not see the results of a search by subject.
> >
> > Does this make sense? I want to be able to have the library contents come
> > up and look like the report, but in a form so that the website/hyperlink can
> > be active.
> >
> > Any suggestions or input will be GREATLY appreciated.
> > Thanks so much,
> > Lisa
- Next message: anonymous_at_discussions.microsoft.com: "Vertical Scroll Bar in ListBox"
- Previous message: Allen Browne: "Re: Formatting Text Box"
- In reply to: Dustin Ventin: "I think I know what to do."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
