Can you turn on autocomplete for entries eg if you have lots of identical fields in a database? Say 50 records have the same entry for one of the fields... Can it be turned on by the user or must it be done at the programmer level? I would find out myself but I don't have MS Access loaded on this pc.
2006-11-09 07:20:44 · 3 answers · asked by Tertia 6 in Computers & Internet ➔ Programming & Design
Yes, but to set it as the default that would have to be at programmer level. Is there no way for the user to set a string-text value without doing cut/paste every time for 50 records?
2006-11-09 07:57:03 · update #1
The is no Auto complete per field level, however if you have joined tables, You can design a multiple-table query to automatically fill in certain field values for a new record. When you enter a value in the join field in the query, or in a form, report, or data access page based on the query, Microsoft Access looks up and fills in existing information related to that value. For example, if you know the value in the join field between a Customers table and an Orders table (typically, a customer identifier such as CustomerID), you could enter the customer ID and have Access enter the rest of the information for that customer. If no matching information is found, Access displays an error message when the focus leaves the record.
If you're having the same value for the majority of records, set it as the default one, or create an update query within a criteria and run it.
2006-11-09 07:50:10 · answer #1 · answered by AMTV 3 · 0⤊ 0⤋
auto complete works in a data grid, not sure about in a single record entry on a form.
open MS Access, press F1 for help and type in "auto lookup" this maybe what you're after ?
good luck :¬)
2006-11-09 07:41:48 · answer #2 · answered by SkiButt 2 · 0⤊ 0⤋
get good of entry to is a database software (small scale compared to the likes sq. Server/Oracle) and Excel is spreadsheet software. The confusion in a good number of cases arises because both have spreadsheet like information get good of entry to monitors. a million) get good of entry to shops information in tables which could be on the concern of one yet another (relational database) even as Excel makes use of flat spreadsheets 2) get good of entry to love different database apps can use the sq. language to question yet excel has none 3) get good of entry to can save a lot extra information than excel can desire that permits somewhat? all the finest on your try!
2016-11-28 23:23:50 · answer #3 · answered by erke 4 · 0⤊ 0⤋