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

How to set Automatic enable of Macro in access

P: 8
Hi,
I have database in that I have a table to which, I want set an automatic macro,It should run automatically when ever I enter the data in to the column.
Dec 26 '07 #1
Share this Question
Share on Google+
4 Replies


jaxjagfan
Expert 100+
P: 254
Hi,
I have database in that I have a table to which, I want set an automatic macro,It should run automatically when ever I enter the data in to the column.
What does the macro do? Be a little more specific. Is another value calculated when a value is entered or are you making a specific task happen? Are you entering values directly into the table or via a form?
Dec 26 '07 #2

P: 8
What does the macro do? Be a little more specific. Is another value calculated when a value is entered or are you making a specific task happen? Are you entering values directly into the table or via a form?

hi,
Macro is doing a special task it is return in VB,
we are entering data in to that directly into table
thank you
Dec 27 '07 #3

Minion
Expert 100+
P: 108
hi,
Macro is doing a special task it is return in VB,
we are entering data in to that directly into table
thank you
I could be wrong, but I do not believe that you can attach a macro or any coding of the sort directly to a table. If it the information were being entered through a form you could tie the code/macro to the "lost focus" or other needed event to activate it. But I don't think this will work with a table.

Please anyone correct me if I'm wrong on this one.

Hope this helps.

- Minion -
Dec 27 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
Minion is correct, this cannot be done thru a table! You need to use a form based on the table. The fact of the matter is, except in the early development stages of a project, data should never be entered directly into a table.

Linq ;0)>
Dec 27 '07 #5

Post your reply

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