By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

call 'procedure' from table view

P: 2
I've been doing different sqls for a while but I'm a super n00b to access.

Is there a way to call a procedure/function when a change in a 'cell' from the table view occurs?

Thanks for the help and sorry for the n00bert question.
-clamps
Aug 25 '06 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Assuming your cell (field) is on a form you can use the After Update Event to programme a function call in VBA.

If not then how are the records being updated?


I've been doing different sqls for a while but I'm a super n00b to access.

Is there a way to call a procedure/function when a change in a 'cell' from the table view occurs?

Thanks for the help and sorry for the n00bert question.
-clamps
Aug 25 '06 #2

P: 2
Thanks for the reply.

This is within a single table. From my limited knowledge of access it looks as if one can change (update) a record directly like in excel while in the 'table view'.

I hope that made sense.
Aug 25 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I think you mean that if you open a table to view the records and change a field value can you program a function call based on this change.

Unlike in Excel these are not cells. If you want to do this you would have to open the table in form view. That is design a form using the table as a recordset and open the form in Datasheet view. This will show like opening the table in form view. However, you can program an event against any field in design view to call a function on the After Update event of that field.

Thanks for the reply.

This is within a single table. From my limited knowledge of access it looks as if one can change (update) a record directly like in excel while in the 'table view'.

I hope that made sense.
Aug 27 '06 #4

PEB
Expert 100+
P: 1,418
PEB
In fact in MS Access I've never seen the possibility to run a function or procedure after updating a field in a table! If there is please tell me the way to do it!

Something else! If you use a query for editing and updating the fields you can set a procedure or function that runs after update: Application.Screen.ActiveDatasheet.AfterUpdate=my_ function("dfk","fd")
Aug 29 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.