Help with Hurricane Database

K

Keith Wilby

Steve said:
My fees are very reasonable.
Click to expand...

X-Complaints-To: [email protected]

From: "Steve" <[email protected]>
Newsgroups: microsoft.public.access.formscoding
References: <[email protected]>
<[email protected]>
<[email protected]>
Subject: Re: Help with Hurricane Database
Lines: 210
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
Message-ID: <[email protected]>
Date: Sun, 17 Jun 2007 22:38:23 GMT
NNTP-Posting-Host: 65.78.214.12
X-Complaints-To: [email protected]
X-Trace: newsread1.news.pas.earthlink.net 1182119903 65.78.214.12 (Sun, 17
Jun 2007 15:38:23 PDT)
NNTP-Posting-Date: Sun, 17 Jun 2007 15:38:23 PDT
Organization: EarthLink Inc. -- http://www.EarthLink.net
Path:
glkas0286.greenlnk.net!glkas0286!news.gradwell.net!news-peer-lilac.gradwell.net!news.glorb.com!newshub.sdsu.edu!elnk-nf2-pas!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!newsread1.news.pas.earthlink.net.POSTED!902d780b!not-for-mail
Xref: glkas0286.greenlnk.net microsoft.public.access.formscoding:245141

If you need help in the future expanding what you have to track income,
costs and claims, contact me at [email protected]. If nothing else, I
can help you with developing the structure of the tables. My fees are very
reasonable.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
K

Keith Wilby

Suzann said:
I understand and I appreciate the fact that there are people on the net and
possibly in this newsgroup who do prey on people like me.

I have the utmost respect for this newsgroup and for people like you, Bob
and Doug who constantly answer questions for end users like me who are
wanting to learn more but are stuck on one particular point.
Click to expand...

Please don't let "Steve" put you off. The vast majority of people who lurk
here will be more than happy to help FOC if they can.

Keith.
www.keithwilby.com
 
D

Douglas J. Steele

Sounds as though what you might be looking for is a Filter for the form.

dim intUnit as Integer
dim strName as String
dim strFilter as String

intUnit = InputBox("Please enter the Unit Number", "Unit Number")
strName = InputBox("Please enter the Hurricane Name","Hurricane Name")

strFilter = "fldUnit = " & intUnit & " and fldHurricaneName = '" & strName
& "'"
Me.Filter = strFilter
Me.FilterOn = True
 
S

Suzann

Again, I thank you all. I'm glad to know in this day and age chivalry isn't
dead - lol. I'm working the suggestions that Doug and Bob gave me. I have
used this source in the past and will continue to do so. Y'all helped me
understand securing a database with user-level-security. If I can get that
to work, then I can get my dialog box to work too. Thank YOU all for your
professionalism .. and for your continued help.
 
S

Steve

Just be aware that with this ELEGANT way to get user data, when the user
wants to look at the record of a different unit, the user will have to close
the main form, open the preliminary form, enter the Hurricane, enter the
unit and click a button. The user will love you for that! With a combobox in
the main form and a combobox in the subform you can change records
immediately from the main form.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top