473,386 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

autocomplete fields in my table

Hello, I have been banging my head against my computer trying to
figure out how to have access autocomplete some fields in my table,
using data from another table.

I have simplified my question with pictures, so please read my
question here:

http://www.financialsolutionalberta.com/accessquestion/
Thank you very much in advance for any of your help, I will be
checking this thread every 2 minutes lol.

-Michelle
Nov 12 '05 #1
5 4558
You use a query

Instead you might consider adding a field to the Clients table, e.g. Status
(possible client or an active) simply to avoid redundancy.

HTH
"Michelle" <hi*******@msn.com> skrev i en meddelelse
news:96**************************@posting.google.c om...
Hello, I have been banging my head against my computer trying to
figure out how to have access autocomplete some fields in my table,
using data from another table.

I have simplified my question with pictures, so please read my
question here:

http://www.financialsolutionalberta.com/accessquestion/
Thank you very much in advance for any of your help, I will be
checking this thread every 2 minutes lol.

-Michelle

Nov 12 '05 #2
In the online help use the keyword AutoLookup

HTH

"Michelle" <hi*******@msn.com> skrev i en meddelelse
news:96**************************@posting.google.c om...
Hello, I have been banging my head against my computer trying to
figure out how to have access autocomplete some fields in my table,
using data from another table.

I have simplified my question with pictures, so please read my
question here:

http://www.financialsolutionalberta.com/accessquestion/
Thank you very much in advance for any of your help, I will be
checking this thread every 2 minutes lol.

-Michelle

Nov 12 '05 #3
Why don't you instead of having two tables, use a checkbox Null being not a
client or just a prospect and checked being a client, then use a query to pull
your data for either or. Using a query would be the best way to also autofill
or use the after update from a combobox to populate fields based on a combobox
query.

combobox.column(0) would be your first field, combobox.column(1) would be the
second field etc etc.

HTH
Michael
Nov 12 '05 #4
Why don't you instead of having two tables, use a checkbox Null being not a
client or just a prospect and checked being a client, then use a query to pull
your data for either or. Using a query would be the best way to also autofill
or use the after update from a combobox to populate fields based on a combobox
query.

combobox.column(0) would be your first field, combobox.column(1) would be the
second field etc etc.

HTH
Michael
Nov 12 '05 #5
"Michael Juul Hansen \(remove NOSPAM to reply\)" <NO******************@mobilixnet.dk> wrote in message news:<c6***********@news.orange.dk>...
You use a query

Instead you might consider adding a field to the Clients table, e.g. Status
(possible client or an active) simply to avoid redundancy.

HTH

Okay I have fooled around with the query feature in access, but still
have not figured out how to achieve auto-filling the fields i want
using query...anyone care to explain a bit more in depth in how i do
this? Thank you

-Michelle
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

40
by: Alex | last post by:
Hello, does anybody know how to turn off the autocomplete feature for a certain text field? I am aware of the "autocomplete" attribute, but I have seen other implementions achieving it...
3
by: Pete | last post by:
I'm currently doing a database that uses comboboxes to look up records in other tables, whether they be lookup tables or otherwise. When a user needs to add an item to one of these tables, the...
2
by: Michelle | last post by:
Hello, I have been banging my head against my computer trying to figure out how to have access autocomplete some fields in my table, using data from another table. I have simplified my question...
0
by: venu | last post by:
Hi All I need some help from u guys. iam working on aspx page.in this page i have lot fields. text boxes and dropdown lists .. First filed should be a autocomplete filed. this text has onblur...
5
by: Andrus | last post by:
I'm creating a database Winforms application using VCS Express 2005 I have some large lookup tables (may be up to 500000 records) which contains name and id and are stored in sql server. I...
8
by: nil | last post by:
Hello all, It's urgent... i want to add autocomplete textbox facility in my application like google. as you type it suggests option to the user..i want the same kind of facility...i know i...
1
by: wkerplunk | last post by:
Below is what I have build with several different languages. It works great but I need help, I am stuck. When you click on an item in the dropdown autocomplete div it does a mousedown function...
0
by: VMI | last post by:
I have an Access table with about 20k records, and I need to display these on a grid based on what the user typed in a textbox (similar to autocomplete). I loaded the 20k records (w/ 4 fields) to a...
3
by: John | last post by:
AC2007 I changed my combo's row source and then the autocomplete stopped working. The combo is two columns, bound to the first. First column is primary key (ID). Second column is a...
1
by: Pazeh | last post by:
Hello, a first timer here! stumbled upon one of the threads hear while searching on google & the feedback was awesome so I decided to jump in & ask my Q! I'm a newbie in AJAX, but I know my way...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.