Microsoft Access - Update Multiple Tables from a Single Form

[dallinmastro]

Thank you this was very helpful, Is there a way to do this same thing based off a combo box response?

[thushara]

I would appreciate your guidance on creating buttons on a form to move data to individual tables in Microsoft Access. I have a form that displays data, and I want to make four buttons (Received, Issued, Returned, and Damaged) that will move the current record to one of the corresponding tables.

[RicardoMRachel]

Thank you for sharing your knowledge, Mike. This class was very enlightening, objective and very well taught.

[elevateyourcreativeness]

Question:

I have a form I’m using as a check out/in for a Church library! When checking out it creates the entry into the table. Is there a way that when checking in, it just updates that entry without creating another entry onto the table?

[mitchgrossman]

Hi, I followed your example in Access 2019 but when I click on my Command Button, instead of returning the text from the ComboBox (in this case "John Doe") it is returning the number 9. I have the exact SQL code you are using. Is there a something else in the properties of the Command Button or ComboBox that might be returning a numerical value instead of the text?

[sarbashisSarkar]

Can I update a table and record that update date and time in a report for my future reference. Also I want to see when I updated that table last time and which column was updated?

[Decan]

Question for you. I’m not familiar with Access, but I think I might be able to use it to make work easier. I have a large list of employees at the company I work for who routinely need paperwork filled out and submitted for events. Is it possible for me to build a database, select the names of the members attending the event and then have a macro transfer the information needed into each document? My concern is the docs I’m looking to have auto populated are word and pdf files. Is this possible? If so, do you have a video giving a walkthrough of how to create something like this?

[aliyushehu]

Hi, thank you for this tutorial. Please how can one add multiple values?

[marshallmickells]

Great videos! I do have a question...I'm trying to create a database where I can enter employee information along with the IT equipment or software they have been issued with more details about each For equipment things like, make, model, serial, IP, MAC, network switch port its connected to. This would help me identify who has what when troubleshooting or if they leave the company what access for them needs to be cut.I'd be interested if you have any ideas on how to best approach this.

[JessicaJones-mesp]

i would like to have a form that will calculate a percentage change for an employee, using the calculated change% from the previous entry. For instance, for Staff A the original is 86% after entering the new data it increases to 89% . When I enter new data for staff A I'd like the last calculated % to be showing as the original or last update and I can repeat the process and have a record of all of the updates too. I may be over thinking the way to do this, but you showed me a some of what I want to do. I am not familiar with SQL but I was looking to see if I could adapt it. I appreciate any help you see fit to offer. Thank you.

[samueljordan]

To clarify, I am editing the fields in tables not the data

[AnandaAberathne]

Thank you. Do more lessons in deep in MS access

[accesstest]

Hello!! my subform is not populating data properly...it is assigning two records to person A and four records to person B, even though the linked table has 3 recrods for each person ..any thoughts?

[TheLotsafun]

i am working on an estimation sheet. i would like to have new versions of same data when i update a record with different versions or have estimation sheet for multiple options of the project in the same access file

[nsa]

Is there no way to just make an editable single form that has fields from multiple tables? ("This Recordset is not updateable" doesn't let me do it)

[samueljordan]

My biggest dilemma is when I make edits to a table connected to a form. I always need to go an edit the form and bring in new tables edits manually. How to I get a refresh in my form to accept the new edits from table? thank you in-advance!

[luis]

I am trying to create a database for receiving and dispensing stock. How can I update two tables with stock levels? Example. I receive an item. I want to update the table to show my receiving as well as the table with my current stock levels. Also to do the same when using something in my stock. I want it to show in my dispense table along with where it went.

[kristycooper]

I'm trying to use this method to fill out 2 tables Customer_Shipto and Customer_Billto. The difference I've made is it is from a form I fill out with a single button to update both tables with the new information, I'm fairly new to the coding what would be my command to make this happen on click? Would this even be the best method to make these 2 tables exactly the same?

[AbdurRahim-otgp]

A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control how to fix

[danimr]

Can we append multiple table from form?