Over 1 million tech questions and answers.

Auto complete or Auto Fill field in Access?

Q: Auto complete or Auto Fill field in Access?

I have a nice little database that I set up to track donations of items to our organization. The primary table tracks the donor information: name, address, etc. (main form) and I have created a related table that tracks the date of donation and items donated utilizing a sub-form. Thanks to the fine help I received here I was able to relate these tables using a “Link_ID” field and it has worked nicely. (One donor could have multiple donations.)

Now, I’d like to enhance things a little bit. When I enter donor information into the main form and then go to the sub-form for the donation information, I’d like the business_name field to autofill as I start to type. Now, I know this can be done because most commercial databases have this function. Quicken is one that comes to mind. I know it has to pull this information from somewhere, I just need to know how to get it to work!

I have been unsuccessful finding any pertinent information on an “autofill” field in some sources. (I really don’t want a drop-down list box because this could potentially get too large.)


Preferred Solution: Auto complete or Auto Fill field in Access?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Auto complete or Auto Fill field in Access?

Yes, well, unfortunately, in Access, the drop-down list is the only type of control that uses auto-fill, unless you want to use a text box and code (there's an example of that in the developer's handbook, but it's complicated).

No matter how big your list is, if you sort the underlying query alphabetically on company name, it will still autofill, and you can even build a not-in-list response to add new customers...

Make sure the auto-expand property of the drop-down (or combo) control is set to Yes, and you'll see that you never even have to drop down the list...

Read other 2 answers

Please help

I have 2 tables:-

1 Master Input Table.
1 Job Lookup table - (contains Job Number and Name)

When in-putting job details into the Master Input table i would like to enter the job number only and have the job name appear automatically without running a query, much the same as a 'vLookup' command in excel.

Is this possible?

Can anyone help?

A:Auto Fill In MS Access Table Field

Yes it is, the easiest way is to have the Job Lookup Table as a Sub form on the master form (Master Input Table) linked via the Job Number.
Or you could select it from a combo box, (no typing).

Read other 1 answers

I'm trying to find out why Access 2000 will auto fill my data entries. I've noticed that when I put a number in a field that the next record will automatically insert the next number in that field. For example, in my Order column, in datasheet view, I enter a 1, the next record in the the Order column will automatically fill with a 2 and so on. Or the pattern will repeat - if I enter a 1 in the Order field, then a 3 in the next Order field, the next Order field will fill with a 5. What is going on? and how do I stop this?

A:Access 2000 does auto-fill on field data

momish, I can't find how to turn it off either.
If you are using a form in datasheet view then you can convert it to "Continuous" forms mode and that will overcome that problem for you without losing the functionality of the datasheet ease of entry.

Read other 2 answers

I'm running WinXP Pro w/ IE 6.0, SP1. I use the auto complete/auto fill-in for easy entry to common form submissions. I like it and use it a lot. What I would like to know is - What can I do about old submission? Every time I use the down arrow to select the proper entry, there's a whole bunch of older things that were entered in that frame from a lon time ago. (i.e for email, there's a listing for [email protected], that I used for a spoof). How can I remove JUST THE OLD ONES? I want to keep the cookies active and use what is my normal (80%ish) of the time entries. I looked in MS knowledgebase but it just talked about clearing history and cookies. I know that, I just want to clear SOME entries. Thanks in advance for your help on this matter.


A:IE 6.0 & auto-complete/auto fill-in


Read other 1 answers

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.

A:Solved: Access Auto-Populate a Field using a field from another table

Read other 15 answers

Access newbie using Access 2007 with Windows XP. I have a table that contains the following columns.
Author LN

I want users to select title from a drop down list in the title field which will auto populate the two author name fields. Users will enter data in remaining fields.
1. Title field has scroll arrows but only shows first title?
2. How do I get the AuthorFN and Author LN to auto-fill based on title selected?

Can't find a solution that a newbie can understand.

Forgot to add that users will create multiple "info cards" because only 1 comment for each record.

A:Access 2007 Auto-Fill

Read other 16 answers

I have a table in an Access database. This table has three columns in it, and I want to add a fourth column. I want the value of this fourth column to be "Primary" for every record.

What's the easiest way to accomplish this? I'm an Access newbie.

-- Richard

A:Auto-fill access fields?

Read other 6 answers

Hello! I'm hoping someone out there can help me. I'm creating a basic form, it would be nice if when a record is created the day you created the record could autofill into place. Does anyone have any suggestions out there how I could do this?

Thank you,

A:MS Access Date Auto-Fill Form

You could set the default for the date field to Now().

Read other 2 answers


I am using Access 2003 and have a question-- I have a table called tblContacts, and an associated form with demographic info. I want to add a field to this form called "notes" , which would be opened with a button on the form (that way the notes on the individual would not be immediately visible to anyone walking by).

I created the subform Notes (and associated table tblContacts_Info). My problem is this:

I want the contact_id (unique identifier of individual) to automatically fill in when the subform opens with the value from the record of the parent form.

I tried creating a one-to-many relationship, and tried setting the record source as the contact_id from the parent table, but am having no luck.

can anyone help? Is there a better way to do this than a subform/second table? I just want to create privacy on the form...



A:Access subform (I think) and auto fill in question

Read other 10 answers

O...Kay! I need help with a now, 4 year old Access database. Many thanks to OBP, I have cleaned up and worked out kinks that really has made keeping up with parent involvement in the schools much easier. Now that I have worked with the database, I am in need of some advice regarding a form that is needed now. This is a form that is used to enter just basic demographic information on a parent who calls to sign-up to be notified of special events.

The form is simple, but this is where I cannot quite make it work. The unique identifier of the record is the school's location code number. I have tried to find out how to fabricate the form so that when this location code is entered, the associated fields (school name, type, and region) will auto fill in. I'm sure that this may seem trivial to the experts, but I am once again STUMPED. Many thanks in advance for any assistance that I may be given.

Read other answers

I want to auto-fill a Word 2010 Table from a Access 2010 Query. Here is what I mean:

I have created an Access 2010 database file called “MasterTestEquip.accdb” with a “MasterTestEquipList" Query. Using the Word Merge function in Access, I created a 5-column, multi-row Table in Word 2010 with the following Column names:

Description, Manufacturer, Model, Identification #, Cal Due.

I want to be able to enter in the Identification # (e.g., 469-0068-601) and have the row auto-fill in the other information (Description, Manufacturer, Model & Cal Due). I have been trying to get the Mail Merge function to do this but I am stuck. I used “Insert Merge Field” and selected the appropriate name for each column. When I do a Preview, I can click on the right and left arrows and the information in the row steps through each one of my Identification numbers in my recipients list and the corresponding information is correct, but this is not what I want. I need to be able to manually enter in the Identification # and have the additional information auto-fill in. I also noticed that if I perform the above “Insert Merge Field” function in multiple rows that when I use the arrows to scroll through in one row, that all the rows change and show the exact same information. How do I make each row independent of each other and be able to manually type in the Identification # to get the rest of the information to auto-fill for each row/line?

This is a Test Equipment List form that I ... Read more

A:Auto-fill Word Table via Access Query

Read other 13 answers

Is there an easy way to input a SS# and have the cursor move to the next field without me hitting the tab or enter key? I have looked everywhere.

Read other answers

i am in the process of creating database and i have an issue i am trying to resolve.

On my main form i have a list box where the user choses a binder number. The binder number, alond with the binder name and binder location is stored in table, binders. On my main form i also have a filed called Location. What i need is for the location field to be filled with the location of the binder that was chosen from the list box mentioned above. I know this can be done i am just having trouble figuring out how to do it. I know it involes a query but i am not sure how to set it up. I am an advanced begginner with VBA so if you reference code, i will probably be able to figure it out...

Thanks in advance!

A:Access Quesiton Auto Populate a field

Read other 16 answers

As a part of my data base I want to issue receipts for a charitable income tax donation.

I want the field to increment by 1.

I have it set to show the format year in the field ie. 2011000 but what I want it to do is assign the number consecutively by the year.

So that when the year changes... 2011 to 2012 it changes the number to 2012xxxx amd increases the number by 1.

the final 4 digits should start over from 0 each January 1.

Attached in 2007 format and 2003 conversion for convenience.

A:Solved: Access 2007 Auto incremente a field

Read other 15 answers

Hi All,
I need an help in creating auto number field in access database. Let me explain you further. I have an access database which 20 million records. When i am trying to add auto number field i am getting error "File sharing lock count exceeded".
Then i did some google search and got some infomation like editing the registry file , in my case its not possible due to security restrictions.
And another option of adding a code in VB immediate window also i tried but this option is also not working.

"DAO.DBEngine.SetOption dbmaxlocksperfile,25000000"
Can anyone help how to solve this issue else can you please help me on how to auto populate the numbers in a specific field using VBA codes.
Thanks in advance.

A:Auto number field in a Access database table

Read other 16 answers

Hello. I was wondering how I would go about clearing the auto complete field in the windows update "Installed Updates" window. It seems completely independent from the windows explorer search field.

I was checking to make sure no windows 10 or telemetry updates accidentally got installed and now it's FULL of different KBnumbers.

I tried using the "find" option in the registry, but got freaked out when it brought up a bunch of stuff i didn't recognize and i didnt wanna mess anything up.

Thanks in advance,

Read other answers

Hello. I was wondering how I would go about clearing the auto complete field in the windows update "Installed Updates" window. It seems completely independent from the windows explorer search field.

I was checking to make sure no windows 10 or telemetry updates accidentally got installed and now it's FULL of different KBnumbers.

I tried using the "find" option in the registry, but got freaked out when it brought up a bunch of stuff i didn't recognize and i didnt wanna mess anything up.

Thanks in advance,

Read other answers

Is it possible to format for autocomplete in Tables and FOrms in Access.

I can in EXCELL but its not there in Access.. I think

A:Access Auto Complete

You can use a combo box that looks up values in a table and autocompletes as you type. Use a summary query that creates a new table to populate the lookup list table.

Read other 1 answers

Good afternoon all!

I am working on writing a Security Incident Report program, and I am running into a problem. I have a Date/Time field, which I am attempting to auto-update from another Date/Time field, based on the result of a Yes/No field input. Is this even possible? To be specific, the user enters the date of the report. On the next form page, it asks the user if the report date is the same as the incident date. If the user answers Yes, I would like it to enter the data from the report date field and grey out the option to enter the new date. If the report date is different from the incident date, the user would then be required to enter the date of the incident. This takes place three different times on the same form, based on the incident date, date responders cleared from the incident, and the date the incident was placed under control. I am running Access 2007. Thank you!

A:Creating Access 2007 Auto-populate field based on different table Yes/No data

GrahamTechnology, welcome to the Forum.
Yes it is using VBA.

Read other 3 answers

Firstly, let me apologise, I'm a complete Access noob & am trying to teach myself as I've got no one to help me in person.

I'm trying to build a Time Sheet database that should record daily duties via an entry form:

This form updates an underlying table:

The date field of the "Work_Hours" table is:

However, workers get paid fortnightly and all their entitlements, allowances & overtime are calculated on these fortnightly periods. To be more specific, the workers are paid for a certain amount of overtime for each fortnight upfront & when they exceed that, then they are entitled to all excess time back in TIME OFF. So it's pretty important that each day's duties are assigned to the correct fortnight period so that their overtime & so-forth are calculated correctly.

Each fortnightly period is numbered according to year. For example, each year there are 26 fortnightly periods, so as an example today (3rd October 2013) falls in period 2013-19 (23rd September 2013 to 6th October 2013).

I've created a table called:

Which has the following Fields:
"ID" (Auto-number)
"Period_Start" (date - the first day of each new fortnight period)
"Period_Number" (number - eg: 2013-19)

Back in the "Work_Hours" table, I inserted a new (Number) FIELD called:

and set ... Read more

A:Solved: MS Access - How to get a field auto-update based on date entered in a form

Read other 9 answers

I have Word 2002, SP3, for Windows Office XP Pro.

My problem is I want to permanently turn OFF the autocorrect options (all of them: correct initial capitals, correct first letters of days, etc etc, autoformat, as well as auto text and auto type).

Yes, I have unchecked all the boxes in Tools > Autocorrect Options, the problem is I have to painstakingly go though all the boxes every time I open Word and uncheck them. My setups are not remembered.

I can't figure out how to make these options stay set this way.

I've tried installing the Office Resource Kit and setting a system policy (though I am the only user on this PC), but no success.

I had to rebuild my system a month ago -- before that, I never had any problems, Word seemed to remember exactly my preferred set up and saved autocorrect options etc to the normal template.

I checked the normal template and it is in Doc Settings folder where it should be.

I searched the forums and Word help but can't seem to find any advice, mainly because most people usually run these options and they only wish to modify the instances where they apply, rather than permanently disable them.

Please help! Much appreciated! Thanks!
Sydney Australia

A:Solved: I want to kill off autocorrect, auto format, auto text, auto type

Read other 8 answers

How do I erase some items that pop-up when I am filling out a sweeps form etc?

I have old zip codes I want to delete etc.

A:Auto Fill-In ?

Read other 11 answers

Auto Fill-In

How do I erase some items that show when I am filling out a sweeps form etc?

I have old zip codes I want to delete etc.

How do I delete ones with wrong spellings etc ?
Or do I need to delete all?

A:Auto Fill-In

Read other 9 answers

I cant get the auto fill to work on my computer? I think I have all of the settings set but it wont work.(Moderator edit: thread moved to more appropriate forum. jgw)

A:Auto Fill

Is this problem with a browser autofill?

Read other 5 answers

Is there an addon to auto fill forms ect.???For Firefox 3.6

A:FF3.6 auto fill

Quote: Originally Posted by scouse6

Is there an addon to auto fill forms ect.???For Firefox 3.6

I use the one that comes as part of Google Toolbar. You can have multiple profiles, which is handy, though it sometimes get mixed up with things like UK post codes and US zip codes. On the whole, it's pretty useful

Read other 6 answers

I need to know how to complete/edit auto fill on google. I just installed firefox.

A:Auto Fill


Read other 1 answers

How do I disable auto-fill in Bing, Google and MSN.com? Thank you

A:Auto Fill

It would probably help if we knew what web browser you are using...

Read other 2 answers

I have Windows 7. I use yahoo and fire fox. I had auto complete...auto-fill...but now it's gone. How do I get it back?

Read other answers

Is there supposed to be an Auto Fill button in Internet Explorer 7. I see the chevron arrows but no button like there is in Mozilla Firefox. Attachments.

A:Auto Fill button

there is no internet explorer 7.1 and no autofill button

Read other 3 answers


How can I activate the setting for auto fill in on Windows 2000?
I could also ask that question foe Windows XP.


A:Auto Fill - How to Turn It On?

do you mean autocomplete ? If so then open internet explorer and click /tools / options / content / autocomplete

Read other 2 answers

Win XP, iE 6.0. You know that white drop down list that comes up when you have a field to be filled (like in the search field on eBay)? I was wondering if there was a way to either edit that list or completely clear it.

I tried deleting my history, deleting my cookies, clearing the cash and none of that effects these lists. But this info must be stored somewhere.

Any help is always appreciated. I know you guys won't let me down, you haven't yet!


A:Auto Fill Editable???

Read other 7 answers

I am using mocrosoft internet explorer 7 and i want to change some information in the auto fill or auto complete function

A:Auto fill feature

Tools/ internet options/ content tab/ auto complete

You can erase all auto completes by unchecking , and deleting history in the
general tab.

Read other 1 answers

Good Day,

I am creating a template to be used in our operating procedures. I currently use the Autofill to about 200 rows to ensure that I capture all the fluctuation in the amount of data which are entered daily. Is there a macro I can write that will auto fill to the last row which has data? Instead of me updating the Range each time or putting in excess rows, etc. eg.


Selection.AutoFill Destination:=Range("H6:H200")


A:Solved: Auto fill to last row with value

Read other 16 answers

You know how you type in searches and ie automatically saves your entry so that you don't have to type same thing next time? Well, my drop down is very long. Is there a way to clear out everything and start over? Thanks.

A:clearing auto fill

From IE help

To delete Autocomplete entries from the Address bar list

The AutoComplete feature saves previous entries you've made for Web addresses, forms, and passwords. To delete entries from the Address bar, you must clear your History folder. You cannot clear individual entries from the list of saved entries.

On the Tools menu in Internet Explorer, click Internet Options.
Click the General tab.
Under History, click Clear History. Click to expand...

Read other 3 answers

My old WIN98 PC auto-fills the fields on certain web sites when I enter the first character of the string (except for passwords). I can't remember whether or how I made it do that. I would like to set up my new WIN XP PC to do it but so far can't determine how. I think it's asking whether I want it to save passwords but I don't. Searches for auto-fill and autofill in the MS knowledge bases produce no results.

A:Windows Auto-Fill

Go to "Control Panel"> Internet Options>Content> Auto Complete
and check what you want it to do. Have a good day.

Read other 2 answers


I need help with some code for an e-commerce site, this is what I am after:
the buyer goes through the shopping cart stage, he/she has paid for the service, as soon as the payment has been received, I want the upload page to appear, which has been set out like a form to be already filled in with the customers details and the only thing he/she has to do is to upload the photos.
Hope this is the right forum for this question


Read other answers

By auto-fill I am referring to the pop-up box that asks "Do you want IE to remember this user name and password?".
It's a great feature but it only appears once in a while and never when I want it.
Is there a way to call up this device? On demand?

A:Auto-fill question

This is related to the 'cookies' dropped on your hard drive when you are visiting sites. 'Tools' 'Options' 'Security' in Firefox is where you set it to 'Remember passwords for sites'. Other browser have the same tool.

Thing is though that some web sites, mainly those where the address starts with 'https' delete their cookies when you exit the site. So those usernames and passwords aren't saved. Sites like your broker or your bank and other secure institutions.

Are those types of sites where it's not filling in the blanks for you? Or is it more general?

Read other 6 answers

Hi there,
I'm looking for some help (actually a lot) in form letters auto fill in word, here is what I need to achieve.

I have a standard letter that I send out, It's not a mailing list but rather a lot of clients most one off's.
I have seen macros where when loading a document, pop-up windows comes up and asks for details (name, address, or whatever) when the steps are finished it would load the standard letter template, fill in the blanks with the details entered in the pop-up screens and be ready to be printed or e-mailed.
Is there a tutorial somewhere that cover this or if someone could help I would really appreciate.

( Using Word 2007 )


A:Help with form auto fill

Just google "Microsoft Word Form Fields" and you should get plenty of hits. Here is a VBA solution that I provided to someone previously in the forums that sounds like it is similar to what you want. Take a look and see if this is similar to what you want and I can modify the code to suit your needs.


You may also want to search the net for how to do a mail merge since this sounds similar to what you want as well.


Read other 2 answers

Hi. I am a lawyer and often fill out the same forms for various clients. Is there a system where I can put in a name or use a shortcut to input all the details for my individual clients into these forms.

For Example...

If there is a form where I need to put the case number, client name, address, and phone number in each time I complete it for a new client, I want to be able to open the document, somehow indicate which client it is for (from some sort of database that has all the info), and then all the information is then automatically filled into the correct areas. Is there anyway I can do that? Any software or program? Please help!


Operating System: Windows Vista

A:Auto-Fill Documents

Hi LaLey, welcome to TSG.

What format are the forms in? Is it Microsoft Word? If so, you can use a mail merge to autofill the information. What version of Word are you using?

Read other 1 answers

I want to use something other than Robo form. Any free download suggestions?

A:Best Auto fill for free

LastPass: https://lastpass.com/

Read other 1 answers

Hey, can anyone tell me where the "file(s)" for the auto fill option are located? I'm running 2000.

A:Auto line fill

They are in the registry, Why

Read other 2 answers

I have win 7 with Firefox as my browser. When I go to yahoo Mail and type in my email address it list all my pervious email that I have went to. (I have several)
how can I delete them from auto filling where they are stored or save to

A:How to delete auto fill

That's controlled through the browser's own settings. In the menu bar>Tools>Options open up the Privacy tab and simply change the "remember history" item to the "never remember history" alternate from the dropdown list of choices. That should remedy that for you.

Note how that looks in the image here.

Read other 3 answers

can you provide me a link to download good auto fill software free

A:Auto fill software

Ummmmmm, for what?

Read other 1 answers

Hello, I am attempting to fill a range with a formula based upon formula in a spreadsheet. I think that the 'range' function will be useful, but I am at a loss as to how to declare the range and use it in code. I able to select the last month, but I do not know how to write the code to fill in the formula to the end of the data. I have attached a test srpeadsheet. The added month numbers are used to update a chart on another tab of the workbook, using countifs...

Any help would be appreciated.
Range("k55000").End(xlUp).Select ' select last month number
End Sub


A:Auto fill certain range


See if this code helps you.

Sub Fill_Down()
Dim Dlrow As Long, Mlrow As Long
''' get new data last row
Dlrow = Sheets("sel last date - fiill range").Range("A65536").End(xlUp).Row
''' get Month last row
Mlrow = Sheets("sel last date - fiill range").Range("G65536").End(xlUp).Row
''' now fill down ''
Range("G" & Mlrow & ":G" & Dlrow).FillDown
End Sub

Read other 1 answers

Folks just put outlook on the boss' laptop, he was using Outlook express, he's also not very technical.

So naturally he still prefers express. Primarily because when you type in the "To" field express auto fills the name as you type.

Whereas is Outlook you press the icon and it gives you a list to choose from.

Anyone know how to get an auto fill working on Outlook like it does in Express?

Read other answers

Other than Gator (which has spyware) and Roboform are there any other programs that auto-fill user names and paaswords, forms, and other things that need to be filled? Thanks for your help.

A:FREE Auto-Fill Programs

Read other 16 answers