Damnit! Screw the MCU for ruining this video for me! All I can keep thinking of is that evil Dr. Zola. But I really appreciate your effort and time in putting this tutorial together! Keep up the good work sir!
This is a good tutorial. Another way I've been doing this is setting the default values of the textboxes to something like nz(dmax([textbox],[myTable],[ID]=comboBox.selectedValue),"") This looks at the most recent settings for the customer or puts empty string if its not there.
Bedankt Gerard Verschuuren! Ik ben bezig met het bouwen van een CMDB (stageopdracht). Heb ik veel aan! Eigenlijk hoeft men zich geen zorgen te maken als ze iets willen beginnen, want tegenwoordig .. staan er veel tutorials/video's hoe het uitgevoerd moet worden!Met vriendelijke groeten,Kadir Ilker Perçin
What if I want to populate RaceGroup column when Country Column is typed the country or when imported or appended data. Does this method applies or I have to use Dlookup afterupdate? I have the list of Countries and related Race-Group or Nationality. I could make combo box which we have. But the goal is to avoid clicking to much on combos to select the country. We want to avoid typing. Example when I import or append many rows with patients and countries. So after the importation or appending I want to see the country column and nationality or Race-Group to be populated. When you have too many columns and hundreds of rows you don't want to keep clicking on combo to drop down, etc. It's a lot stress on the hand for unnecessary repetitive tasks.
Hello, i am having a problem with access 2007. The new records i am adding they are not saved at the next number of the form but they are getting the number of the old records and it goes to the begging. For Example : i press the button for a new record at the "FORMS enviroment" , and when i press save, the database saves it as record 1 and tranfers the record 1 to the record 2, and when i add the next record, the database saves it as record 2 and transfers 2 to record 3... etc ????? When i close the file and open it again everyghing starts again from the start and looks "normal" meaning 1,2,3 at FORMS AND TABLE ENVIROMENT. Note: at the "TABLES enviroment" the records appear normal 1-->1, 2-->2 etc Also this started by accident from the keyboard when i pressed a shortcut and i pressed an other key of what i wanted, i think that some kind of setting has been changed... Does anyone know how to solve this? THX!
Hello, I am trying to create a form which will auto fill a description once I choose a product #. Can you do this without a query? Product description table has two fields. Product # and description.
Very helpful video, Dr. Gerard. Quick Question: what if you update your query to include more fields from the Customers table? I noticed that when I forgot to include some, I just added them from the field list to the right using "Add Existing Fields" and they added just fine according to which "Customer" I selected without modifying the Query. Is this ok to do? Should the Query be modified if there are more fields I want to add?
On the Form Properties, when I set the Allow Edits to No, it does not allow any edits to any of my fields. Some fields I want set to no edits (like the auto fill fields). Other fields may require editing so how can I do that? Am not using any subform. This was a great video. Thanks!
Hi, I follow your instructions and the form works well but, the table is not storing the data that come from autofill action, what is wrong please help me. Tks.
Hi, I loved this video! Very clear and easy to follow. I am making a similar type of form, but -- to use your example -- my form needs to allow users to add a customer if that customer is not already in the combo box. Since the combo box is based on the ID field -- a numeric field -- when I try to enter a new customer name, it will not let me (cannot enter text string into a numeric field). Is there a way to do what you did but also to have the form allow adding customers to the combo box? Thanks!
Very nice video. I thank you. In one instance in your video, you say "the rest is a matter of data entry". How can you say this, since your form disallows EDITS ?? I myself am having the same problem - I DO NOT WANT TO BE ABLE TO CHANGE MY CUSTOMER DETAILS - but at the same time I WOULD LIKE TO ADD ADDITIONAL CONTENT IN THE REST OF MY FIELDS - of my new record !! Your assistance will be greatly appreciated.
A warning to anyone who stumbles across this like I did: Lookup Fields in tables of your Access Database are evil. First, any query that tries to order the table data by that company name will not work, because the underlying value isn't the name, but instead a CompanyID number. Nor will any queries that use a company name in that field as a criteria. Second, if a filter is applied to the combobox as is created in this form, the persistent filter effect of Access may save that to the underlying query in the table and the next time the form is opened there will be a prompt for the value which cannot be provided, thus creating an error. And finally, any Access database that has Lookup Fields in tables cannot be upsized to, or queried by, any other database management engine without first removing all the lookup fields because no other engines use or understand them. Think very carefully before implementing any solution that uses Lookup Fields in tables in your Access database.
Ok, so you had a form already. Then you created a query and created a new form form that query. I take it that the previous form could be deleted at this point. What if you have several combo boxes on a single form, each combo box linked to a different table, and fields coming after each combo box needing to autopopulate with data from those different tables?
Hey Sir, very nicely performed and exactly what I needed to watch. Thank you very much.
Damnit! Screw the MCU for ruining this video for me! All I can keep thinking of is that evil Dr. Zola. But I really appreciate your effort and time in putting this tutorial together! Keep up the good work sir!
Excellent and concise presentations. Very educational. Thank you.
This is excellent! Been trying to do this myself for hours!
This is a good tutorial.
Another way I've been doing this is setting the default values of the textboxes to something like nz(dmax([textbox],[myTable],[ID]=comboBox.selectedValue),"")
This looks at the most recent settings for the customer or puts empty string if its not there.
This guy saved me hundreds of pounds. You are a genius ❤
Thanks, was very helpful video
Bedankt Gerard Verschuuren!
Ik ben bezig met het bouwen van een CMDB (stageopdracht).
Heb ik veel aan! Eigenlijk hoeft men zich geen zorgen te maken als ze iets willen beginnen, want tegenwoordig .. staan er veel tutorials/video's hoe het uitgevoerd moet worden!Met vriendelijke groeten,Kadir Ilker Perçin
What if I want to populate RaceGroup column when Country Column is typed the country or when imported or appended data. Does this method applies or I have to use Dlookup afterupdate? I have the list of Countries and related Race-Group or Nationality. I could make combo box which we have. But the goal is to avoid clicking to much on combos to select the country. We want to avoid typing. Example when I import or append many rows with patients and countries. So after the importation or appending I want to see the country column and nationality or Race-Group to be populated. When you have too many columns and hundreds of rows you don't want to keep clicking on combo to drop down, etc. It's a lot stress on the hand for unnecessary repetitive tasks.
Thank you so , so much, very helpful video
Ich danke Ihnen
muchas gracias, su video me ayudo mucho, por favor siga subiendo mas.
Hello,
i am having a problem with access 2007. The new records i am adding they are not saved at the next number of the form but they are getting the number of the old records and it goes to the begging.
For Example : i press the button for a new record at the "FORMS enviroment" , and when i press save, the database saves it as record 1 and tranfers the record 1 to the record 2, and when i add the next record, the database saves it as record 2 and transfers 2 to record 3... etc ????? When i close the file and open it again everyghing starts again from the start and looks "normal" meaning 1,2,3 at FORMS AND TABLE ENVIROMENT.
Note: at the "TABLES enviroment" the records appear normal 1-->1, 2-->2 etc
Also this started by accident from the keyboard when i pressed a shortcut and i pressed an other key of what i wanted, i think that some kind of setting has been changed...
Does anyone know how to solve this? THX!
Thank you so much for your easy to follow walk through!
Hello, I am trying to create a form which will auto fill a description once I choose a product #. Can you do this without a query? Product description table has two fields. Product # and description.
Yes I also need help. As Laura has Mentioned. Auto form is working well. But I wish to save it as a "Add new record."
Very helpful video, Dr. Gerard. Quick Question: what if you update your query to include more fields from the Customers table? I noticed that when I forgot to include some, I just added them from the field list to the right using "Add Existing Fields" and they added just fine according to which "Customer" I selected without modifying the Query. Is this ok to do? Should the Query be modified if there are more fields I want to add?
On the Form Properties, when I set the Allow Edits to No, it does not allow any edits to any of my fields. Some fields I want set to no edits (like the auto fill fields). Other fields may require editing so how can I do that? Am not using any subform. This was a great video. Thanks!
Hi, I follow your instructions and the form works well but, the table is not storing the data that come from autofill action, what is wrong please help me. Tks.
Why don't I see an CustomerID on the form? how did you take it out?
Just wanted to thank you,this helped me a lot.
Hi, I loved this video! Very clear and easy to follow. I am making a similar type of form, but -- to use your example -- my form needs to allow users to add a customer if that customer is not already in the combo box. Since the combo box is based on the ID field -- a numeric field -- when I try to enter a new customer name, it will not let me (cannot enter text string into a numeric field). Is there a way to do what you did but also to have the form allow adding customers to the combo box? Thanks!
The resulting form I got from following these steps doesn't give me the option to add records despite allow additions being set to yes.
Very nice video. I thank you.
In one instance in your video, you say "the rest is a matter of data entry".
How can you say this, since your form disallows EDITS ??
I myself am having the same problem - I DO NOT WANT TO BE ABLE TO CHANGE MY CUSTOMER DETAILS - but at the same time I WOULD LIKE TO ADD ADDITIONAL CONTENT IN THE REST OF MY FIELDS - of my new record !!
Your assistance will be greatly appreciated.
You could probably lock those fields in your form leaving only the relevant ones unlocked.
Thank you very much !!!
I don't understand I want to autofill or default value base on a look up combo box
Does anyone know how this can be done in a java application with information from MySQL database?
Very helpful
A warning to anyone who stumbles across this like I did:
Lookup Fields in tables of your Access Database are evil.
First, any query that tries to order the table data by that company name will not work, because the underlying value isn't the name, but instead a CompanyID number. Nor will any queries that use a company name in that field as a criteria.
Second, if a filter is applied to the combobox as is created in this form, the persistent filter effect of Access may save that to the underlying query in the table and the next time the form is opened there will be a prompt for the value which cannot be provided, thus creating an error.
And finally, any Access database that has Lookup Fields in tables cannot be upsized to, or queried by, any other database management engine without first removing all the lookup fields because no other engines use or understand them.
Think very carefully before implementing any solution that uses Lookup Fields in tables in your Access database.
Thx. Just what I needed
how can i do this for access app 2013?
Can't get the initial query to work without losing the client data column
Thank you Sir
Can I add auto fill to an existing form?
Ok, so you had a form already. Then you created a query and created a new form form that query. I take it that the previous form could be deleted at this point.
What if you have several combo boxes on a single form, each combo box linked to a different table, and fields coming after each combo box needing to autopopulate with data from those different tables?
You are skipping steps (as you did that already) and assuming people already know how to do certain things.
Thanks dr vershcuuren many halpsxxD
dankjewel
tnx
Very useful
Would please share this template to me?
En vertel dat nu allemaal eens in het Nederlands
Zero explanation, I just wasted my time.
Thank you Sir