Forms Help Please......

  • Thread starter Thread starter mrudu25
  • Start date Start date
M

mrudu25

Hi Everyone,

I have been struggling to create a Form to be able to search the
employee database but unfortunately havn't been successful so far,
reason being I do not know coding. I believer this group is my last
resource and would really appreciate if someone could help me with
below described problem...

Have created an Employee database which has only one table having
employee ID, Firstname, Last name, Department and Employee pic (OLE
Object). I am feeding the table via a form and that part works just
fine. The challenge is creating a form to be able to retrieve that
information. I am trying to create a search form where I can search
either on couple of characters of Last name or First name and be able
to retrieve the employee pic, department and Employee ID. I believe the
Firstname and Last name field would be unbound objects and rest of the
fields are bound. Unfortunately for the form to be successfully able to
retrieve the information there is some coding required somewhere (have
no clue where and how). Could some please guide me on designing the
form and the coding that is required (where?)to be able to execute the
concept?

Any help would be much appreciated.

Thank you,
MP
(e-mail address removed)
 
Hi Everyone,

I have been struggling to create a Form to be able to search the
employee database but unfortunately havn't been successful so far,
reason being I do not know coding. I believer this group is my last
resource and would really appreciate if someone could help me with
below described problem...

Have created an Employee database which has only one table having
employee ID, Firstname, Last name, Department and Employee pic (OLE
Object). I am feeding the table via a form and that part works just
fine. The challenge is creating a form to be able to retrieve that
information. I am trying to create a search form where I can search
either on couple of characters of Last name or First name and be able
to retrieve the employee pic, department and Employee ID. I believe the
Firstname and Last name field would be unbound objects and rest of the
fields are bound. Unfortunately for the form to be successfully able to
retrieve the information there is some coding required somewhere (have
no clue where and how). Could some please guide me on designing the
form and the coding that is required (where?)to be able to execute the
concept?
Click to expand...

How about something simpler for the user, requiring no coding (that
you need to write anyway) at all?

Create a Query based on the employee table; apply criteria to select
only those employees you want to find (e.g. leave out retired or
terminated employees).

In a vacant Field cell type

FullName: [Last Name] & ", " & [FirstName]

and order by LastName and FirstName ascending. Include the EmployeeID
as the first field; save this query as cboEmployeeNames.

Open the form in design view. Be sure the Toolbox is visible, and
click the magic wand icon.

Use the "Combo Box" tool to create a new combo box on the form.

Choose the option "Use this combo to find a record". Use the query
cboEmployeeNames when asked for the source of the combo's data.

Follow the prompts; Access will write the code for you, and you'll be
able to pick the names from an alphabetized list, with "autocomplete"
so that you can type SCHW and jump right to Ms. Schwarz's name.

John W. Vinson[MVP]
 
Back
Top