So exactly whats happening is that when i click the button it gives a pop-up box asking for Sheet1.DIVISION and then another for Sheet1.Empl_ID. Even after I give those the it is still not updating anything in sheet1 i get a message stating "you are about to update 0 rows".
2nd problem is that I do not want it to give pop-up boxes I want sheet1.division to be picked up as Sheet2_subform. DIVISION and sheet1.Empl_ID as the Empl_ID...
arizwan
Last Activity: Jul 2 '14, 10:11 PM
Joined: Jun 24 '14
Location:
-
I need it to be there because the process is that the changes need to be approved by the manager before they move into sheet1 but it needs to be there in sheet2 for them to be able to see what the changes are. Any ideas why my VBA code isn't running properly?Leave a comment:
-
MS Access VBA update table on click of a button from a form
Hi everyone,
I have 2 tables Sheet1 and Sheet2. They both have identical data and contain Employee Info like name, address, ID, Division,etc. HR wants to update the info in Sheet2 using a form "Sheet2 Form" where they find the employee using ID and then update their info.
Now I have created a button that updates the Sheet1 employee info with the current record that we are viewing in Sheet2 Form. So I created... -
twinnyfo,
I have an ODBC connection with the ms access database and yes you are right I do already have access to table1 from my application and any changes made from that application are already being recorded in table1.
All, I want is to create either a VBA code or a macro that will run when a record in table1 is updated and that macro or vba code will create the exact old record in the Audit1 table.
Which...Leave a comment:
-
Rabbit,
I am using access 2010 and the macro's are working with the external application. So my question now is how do I create a macro to fulfill my need since a simple after update macro will not work since I can have 2 field's on the same record being updated and that would create the same row multiple times in the Audit table.
Is their a way to create a macro that will loop through the Audit1 table when new records are inserted...Leave a comment:
-
twinnyfo,
thanks for the quick reply. I have already set up the Audit1 table and Table1 exactly in the way that you stated. the thing is that table1 is being updated from an external application and thus I do not know if the use of form's would work.
Is their any other way like creating a data macro or something along those lines that would work for this solution?
Again I am extremely new to ms access and vba so I am not...Leave a comment:
-
Creating a table(table2) that keeps the old record of another table(table1)
I have two tables table1 and Audit1. I am really new to VBA and so my question is it is possible if the user updates any of the fields in a row of table1 to make a copy of the old record in Audit1.
So for example I have 10 columns in table1 and if the user makes changes in a row to one or even multiple fields for that record I want just one record to be created in the Audit1 table with only the old fields form table1.
...
No activity results to display
Leave a comment: