Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Conditional for searching in acces


(!)

hatterg's Avatar
hatterg hatterg is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
28-Feb-2012, 11:52 AM #1
Conditional for searching in acces
Greetings, I've been trying to find a way to make what I call "a conditional search" (I don't know if the term is correct).
I work in a school, where we are building a data base of the students and their courses. The point is that I'd like to have a text box in a form where I can write the Name of the student, and after that access would run a Query searching for matches with that name in the "students" table. IF a registry is found, then show me the data of the student, else open a form where I can enter the new student's data.

I'm almost sure that this is not as difficult as I'm finding it, so I hope you guys could help me with this.

Thanks in advance.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,651 posts.
 
Join Date: Mar 2005
Location: UK
28-Feb-2012, 01:42 PM #2
hatterg, what you want to do can be achieved a number of ways.
The simplest is to have a normal data entry form with a "Find Combo" which will locate the pupil as you type in the name, which you then select to show the record.
One of the other most useful is to have text bo to enter the name and use VBA to set the Form's "Filter" to dipslay the pupils details.
__________________
OBP
I do not give up easily
hatterg's Avatar
hatterg hatterg is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
28-Feb-2012, 02:24 PM #3
OBP, Thanks for the reply. As I said before, I knew there was some easy way to do it and I was missing it!.

Now, could you help me with some way to show the data of the student? I am guessing this would be a conditional expression?

Or

Do you think it would be an easier workaround to use VBA? I have very very little knowledge about VBA, could you help me with this?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,651 posts.
 
Join Date: Mar 2005
Location: UK
28-Feb-2012, 06:10 PM #4
What version of Access are you using?
hatterg's Avatar
hatterg hatterg is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
28-Feb-2012, 09:17 PM #5
2007
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,651 posts.
 
Join Date: Mar 2005
Location: UK
29-Feb-2012, 06:55 AM #6
I can't work with Access 2007, only prior versions. Can a copy of the current database be converted to Access 2003 Format?
hatterg's Avatar
hatterg hatterg is offline
Member with 4 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
29-Feb-2012, 11:05 AM #7
Sure, I have both versions installed
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,651 posts.
 
Join Date: Mar 2005
Location: UK
01-Mar-2012, 08:49 AM #8
If you can post a zipped copy of the database in Access 2003 I can create you a Search Form. Please ensure it only has dummy data in the tables.
You use the "Go Advanced" and "Manage Attachments" buttons to add files to your post.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
access, conditional, open form

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑