Lost

[pdbowling]

Hello, I am trying to write a simple piece of code for a database that is just an employee info store.

I am told to have a window pop up asking for the last name of the employee and have the record set displayed or a message displayed if not found. I come from a linux back ground so all this windows stuff is new to me.

Any suggestions on where to Start??? This seems easy but I don't know where to begin.

PB

 

[yippie_ky_yay]

Hey pb,

if you are familiar with SQL you will have no problem here. If not, Access has a great query builder that I use even for my non-Access needs.

I'll help you get started on this task. Create a new query - select your table. Double click the lastname. Beside the criteria part add:
Like "*" & [] & "*"

The square brackets indicate that it will prompt for the input, so here if we enter "jones" at the prompt, the SQL runs - Like *jones*

Within the [] you can add whatever you want for a display message, ie Like "*" & [Enter Last Name] & "*"
Also, if you only want exact matches, then put =[Enter Last Name]

Hope that helps! (let me know if you needed this in a form, then you may need some VBA).

-Sean

 

[pdbowling]

GREAT

GREAT! Thank you so much. Just for future reference, where would you look something like that up? Most tutorials I've seen never get that far. Again, much appreciation.
PB

 

[yippie_ky_yay]

no problem PB!

I learned a lot here and on the microsoft site.

A lot of things that you think about doing aren't always in a book that you can reference. A book that I can recommend to you for when you get a little more familiar with Access is the Access Cookbook - O'Reilly. It's filled with different scenarios that they solve (you learn a great deal this way!)

Cheers,

-Sean

**edited**
I should also mention that learning SQL will help a lot! Another bonus if you can learn VB.