Open Table With Macro

  • Thread starter Thread starter T1thinker
  • Start date Start date
T

T1thinker

I have a DB that creates new tables weekly for tracking changes to
another system. When I launch the DB I would like to have a button
to open the most recent table that I am working on. I know how to
create the button but I don't know how to specify the table that I
would like to open.
 
Why would you want to open a table? Tables aren't intended to be worked
with: that's what Forms are for.
 
Why would you want to open a table? Tables aren't intended to be worked
with: that's what Forms are for.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)






- Show quoted text -
Click to expand...

Would you recomend doing it as a form?
 
First of all, I wouldn't recommend creating new tables weekly. If you only
need certain data available to pass to another system, create a query that
returns the necessary data, and let the other application read that query
(or use the query for exporting, if that's what you're doing)

Second, yes, I would recommend that all interactions with your data be done
through forms. Sure, there are some exceptions to this (subs or functions
that process data in the background), but I'd still recommend having a form
that shows the progress of what's going on.
 
First of all, I wouldn't recommend creating new tables weekly. If you only
need certain data available to pass to another system, create a query that
returns the necessary data, and let the other application read that query
(or use the query for exporting, if that's what you're doing)

Second, yes, I would recommend that all interactions with your data be done
through forms. Sure, there are some exceptions to this (subs or functions
that process data in the background), but I'd still recommend having a form
that shows the progress of what's going on.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)









- Show quoted text -
Click to expand...

Thanks for the info.
 
Back
Top