I think I know what to do.
From: Dustin Ventin (DustinVentin_at_discussions.microsoft.com)
Date: 09/20/04
- Next message: Dustin Ventin: "Re: lnking and files"
- Previous message: Joe Gieder: "Combo Box, Query & Wildcard"
- In reply to: RusCat: "Hyperlinks in forms for all records...."
- Next in thread: RusCat: "RE: I think I know what to do."
- Reply: RusCat: "RE: I think I know what to do."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Sep 2004 14:37:02 -0700
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: Dustin Ventin: "Re: lnking and files"
- Previous message: Joe Gieder: "Combo Box, Query & Wildcard"
- In reply to: RusCat: "Hyperlinks in forms for all records...."
- Next in thread: RusCat: "RE: I think I know what to do."
- Reply: RusCat: "RE: I think I know what to do."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
