469,579 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Help

Hi

I created a simply database and I created a form to enter the data. But I
will like to create a button that brings a window where it ask me what
specific record I'm looking for.

Does somebody knows what code should I used so I can search my record more
easer.

Any help I would really appreciate it.

Thanks,
Evelyn

Jul 17 '05 #1
2 1369

"Evelyn Pabn" <ep****@coqui.net> wrote in message
news:Qz*****************@fe39.usenetserver.com...
Hi

I created a simply database and I created a form to enter the data. But I
will like to create a button that brings a window where it ask me what
specific record I'm looking for.

Does somebody knows what code should I used so I can search my record more
easer.

Any help I would really appreciate it.

Thanks,
Evelyn

Not sure how you have your database setup but something like this SQL can be
done with ado:

' Assuming text field contains what the user type
' Assuming your database has the field [NAME]
' Assuming gNFind is a global / public boolean

With yourdata.Data1.Recordset
.MoveLast
.MoveFirst
gNFind = "[NAME] like '" & Text1.text & "*'"
.FindFirst gNFind
If .NoMatch = True Then Beep
End With
' if found, current record pointer is where the
' record is at. Refresh / update display here
me.refresh
DoEvents
Jul 17 '05 #2
I realize you're trying to be helpful, but please don't post binaries to
this, or any other newsgroup that doesn't have the word "binaries" in its
name.

Either e-mail the database directly to the person, post a message to the
newsgroup offering to e-mail it, or put it on a web page (there are lots of
free web spaces out there!) and post the link to the newsgroup.

Many people pay for their internet connection by the minute (either to their
ISP, or to their telephone company, or both), and many newsreaders are set
to automatically download all articles. Your large posting can cost them
money, whether or not they want your attachment.

Additionally, there is a risk of potential viruses included with them. Most
of the users - especially the regulars - will not even pay attention to
those postings.

And learn to zip things: Access databases tend to compress quite nicely when
zipped.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
" .." <pe*@mail.cbr.ru> wrote in message
news:c9**********@twin1.cbr.ru...
Hi.
May be,
that simple sampe will help you.

"Evelyn Pabn" <ep****@coqui.net> / :
news:Qz*****************@fe39.usenetserver.com...
Hi

I created a simply database and I created a form to enter the data. But I will like to create a button that brings a window where it ask me what
specific record I'm looking for.

Does somebody knows what code should I used so I can search my record more easer.

Any help I would really appreciate it.

Thanks,
Evelyn


Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Tom | last post: by
6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Steve | last post: by
8 posts views Thread by Mark | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.