473,326 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

call 'procedure' from table view

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
4 3495
MMcCarthy
14,534 Expert Mod 8TB
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
clamps
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
14,534 Expert Mod 8TB
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
1,418 Expert 1GB
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

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

Similar topics

0
by: Nashat Wanly | last post by:
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET View products that this article applies to. This article was previously published under Q310070 For a Microsoft...
4
by: MD | last post by:
I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure...
15
by: Philip Mette | last post by:
I am begginner at best so I hope someone that is better can help. I have a stored procedure that updates a view that I wrote using 2 cursors.(Kind of a Inner Loop) I wrote it this way Because I...
4
by: Chris Auer | last post by:
What I am looking to do is use a complicated stored procedure to get data for me while in another stored procedure. Its like a view, but a view you can't pass parameters to. In essence I would...
2
by: Justin | last post by:
I am creating a web app for a client in VS.NET using ASP.NET with C#. I need to query three tables in a database using one parameter and display the results on the page. my question is should I use...
1
by: Orit | last post by:
Hi . I am creating an ASP.NET 2.0 web site and have the following problem : 1. I have a GridView which bound to the object data source. 2. This object data source is SQL Table adapter that I...
1
by: apothecary | last post by:
Hello Newbie here. Is there a way of creating a VIEW...using a stored procedure. I am basically trying to create a view to return some data that I am getting using a stored procedure. I...
0
by: amit | last post by:
The Table tt_local will be created when you execute the procedure. The table does not exist when you compile it. There are two options 1. Create the global temporary table manually Remove the...
20
by: billmaclean1 | last post by:
I need to write a stored procedure that selects from a table and returns the result set. I don't always know the TableSchema that I need to use when qualifying the table at run-time Example:...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.