Running a Macro

[TSW]

Who can I get a Macro to run when a table is opened by a user. The database
isn't set up with a form for this table. So like I am hopeing that when the
user double clicks this table to open it "under the tables heading" that I
can get a marco to run.

Any suggestions? thanks

 

[scubadiver]

A) A user should never be able to enter data directly into the table.

B) A table is only used for storing data and for nothing else.

 

[Stockwell43]

Hi TSW,

NEVER let the users input directly to the table. Do yourself a favor and
create a form. A form is for inputting the data where as the table should
only store the data. Going directly to the table gives you no control over
security, deletion, editing and so forth. Use the form wizard to create the
form.

 

[TSW]

Thanks for the replies I have also voice this, and share your concern.
Problem is its not mine to play with and I have only been asked to do a few
things. If it was my choice I would probably scrap the hole database and
start again. Anyway Im also guessing from the replies that this may not be
possible. Is there a way I can have the marco run every day through a
condition or run the macro through a modual daily thats triggered by a date
condition?

 

[Stockwell43]

I'm not really sure what you are trying to accomplish or I am not
understanding. Are you trying to click on a table and then a macro fires to
perfom something? If so, what is it specifically you want the Macro to do?

 

[TSW]

I am trying to get a table to automatically update. At the present time Ive
created a marco that is just a make table query but I have no way to trigger
it. If you know a easier way plase tell.