Queries for forms - identify duplicates

[BSJoJaMAx4]

Hi all

New to access so trying to get an understanding for what it can do.
I have a database which tracks exiting staff.
I want to highlight if the staff member has been previously entered. Is this possible?
Also, can access learn from previous entries (like excel) and type ahead. I would need this for a supervisor field to speed up the input process.

Thanks

[CJ_London]

I want to highlight if the staff member has been previously entered. Is this possible?

use a dlookup function

Also, can access learn from previous entries (like excel) and type ahead. I would need this for a supervisor field to speed up the input process.

use a combobox

[BSJoJaMAx4]

Hi Ajax

Thanks but Im new to Access and not sure how to do it.

Where does the dlookup go? Im hoping that it would appear inside the form (ie staff member already exists Yes / No)

I have changed the fields to a combobox - do I need to make any other changes?

[June7]

Did you mean 'existing' staff?

Highlight where and if previously entered where? A combobox can be used to present users with list of staff and its AutoExpand feature can fill combobox with item that matches user input as they type.

Access cannot 'learn' previous entries. However, you can program a form to carry values over to a new record. http://access.mvps.org/access/forms/frm0012.htm

[CJ_London]

I understand you are new to access and new to this forum, but if you need a specific answer you need to provide enough information to enable us to do so, I can't answer this

Where does the dlookup go? Im hoping that it would appear inside the form (ie staff member already exists Yes / No)

It can appear on a form (google 'vba dlookup' to find out more) but you need to explain the design and relationships of your tables, your field names and clearly explain what you are trying to do - a more detailed answer depends on all of these things - at what point does it display for example?

I have changed the fields to a combobox - do I need to make any other changes?

No idea, it depends on what you are trying to do - and you shouldn't be changing fields to comboboxes except in very limited situations

[BSJoJaMAx4]

Hi all

Apologies for my wording. I need to keep track of staff as they leave (or exit) with a check list (remove and return building access card, remove access to printer etc). I then have a form to capture the information. I want the ability to type ahead some items of the form based on previous entries (ie supervisor name, business unit etc) to speed up entry by staff. I have hunted through google for the autoexpand function but can not see where it appears. In the field properties, I have the data type set to text, Display control to combo box, row source type table/query but it does not pre-populate. What have I done wrong? Im using Access 2010.

[June7]

AutoExpand is a property of combobox - not a function. Set AutoExpand to Yes and the combobox will match user input to items in dropdown list. Did you review the link I referenced in earlier post? Here is another http://www.datapigtechnologies.com/f...combobox3.html

[BSJoJaMAx4]

Wow - thanks June7 - that video made sense and it works now. However, how do I make the drop down only show an entry once. For instance it shows a whole heap of blanks (due to an upload of previous history).

[June7]

Combobox RowSource sql statement like:

SELECT DISTINCT fieldname FROM tablename WHERE NOT fieldname IS NULL ORDER BY fieldname;

[BSJoJaMAx4]

How do I mark as solved?

[June7]

Thread Tools dropdown above first post.