Hey guys I have a question... I'm developing an Access Database that has a lot going on in it. One thing in particular is the fact that it is an accounts recievable by month/year. I want to be able to have a form pop up asking the owner which month/year they would like to view.
Once they have done that and pressed ok, I want it to determine whether or not that table exists (The table will be called: "Month_Year" each replaced respectively). If it does NOT exist, I want it to be automatically created based on the table fields I set for it.
Now I know this is probably a difficult task.. or maybe it isn't. But in either case I would highly appreciate it if you could help me out.
Thanks a lot!
--Mike