Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    22

    Auto-Create a Table

    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

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Mike,

    This is probably not a tremendously difficult task, but I would urge you to abandon that strategy. Having separate tables for each months' transactions is not a good design choice. You are much better off using one table, and relying on a date field(s) to tell you which month the transaction occurred in.

    Out of curiosity, why do you want to do this?

  3. #3
    Join Date
    Dec 2005
    Posts
    22
    For an accounts recievable program for someone... I guess you're right and I could just use filters/queries... Hm, I'll think about it and if you have any ideas for me, please let me know ^_^

    But yea, I believed you when you said it wasn't a good design stragety.

  4. #4
    Join Date
    Dec 2005
    Posts
    22
    Okay, here's what I want to do...

    I want to be able to open a form and have it ask for the month and year. Then I want it to pop up with all of the entries filtered for that criteria... Obviously if none could be found it would simply show none.

    Here are the entries:
    Client Name
    Address
    City
    State
    Zip
    Total Bill

    Then, I want to be able to click on a drop down of a "Client Name" that is tied to "tblAddressBook" Once I clicked on the drop down, I want it to fill in the information for "Client Name" -> "Zip" ... It does NOT have to show it on this form, simply has to fill it in once I have updated.

    Finally, after clicking on this drop down, I can fill in the "Total Bill" with what I want it to be. When I have completed I want to be able to print all records WITH the information provided from the address book.

    Any ideas? ^_^ Heh, heh... I'm sorry... I'm stupid, I really should quit...

    Thanks,
    --Mike

Please reply to this thread with any new information or opinions.

Similar Threads

  1. auto populate and table relationships
    By jmarti57 in forum Access
    Replies: 0
    Last Post: 11-09-2008, 09:50 PM
  2. Replies: 3
    Last Post: 09-19-2008, 02:19 AM
  3. Auto Scroll in a Form
    By delliott777 in forum Forms
    Replies: 0
    Last Post: 05-31-2008, 07:02 AM
  4. Auto Numbering
    By rkruczk in forum Forms
    Replies: 0
    Last Post: 10-09-2006, 04:25 AM
  5. Need help with an auto number
    By Wrangler in forum Database Design
    Replies: 1
    Last Post: 02-10-2006, 03:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums