WTF Any Microsoft Access wizards that can answer a question?

Discussion in 'The Howard Stern Show' started by gwartney, Jul 11, 2016.

  1. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,080
    Joined:
    Sep 23, 2010
    Messages:
    42,907
    Likes Received:
    15,341
    I took Access classes several times but never used it so I am a complete beginner. I'm in Access 2016 . I created my table, then created a form using the Create Form command. The only problem is that my fields are in a different order on the form than they are in the table. Let's say this is my form:

    Dogs Cats Horses Cows

    My table looks like this:

    Cats

    Horses

    Dogs

    Cows

    Is there some way to correct this? I'm probably going to try manually move them around but I'd rather have it come out correctly when I create the table.

    I've googled the hell out of it and not found any help.
    Please keep your answer simple. I'm really a slow adult when it comes to database.
     
  2. Scotty4x4

    Scotty4x4 Light It Up Blue!! Staff Member

    Reputations:
    86,871
    Joined:
    Feb 5, 2014
    Messages:
    5,558
    Likes Received:
    4,872
    scoobyla, gwartney and deadbeat like this.
  3. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,080
    Joined:
    Sep 23, 2010
    Messages:
    42,907
    Likes Received:
    15,341
    Thanks but that isn't what I'm trying to do. I'm not trying to change a table, I'm trying to make the form and Table consistent. I started a brand new one and they line up but now I have hours of work to get it designed like the one I was already working on. As I said, I'm a complete dummy and probably shouldn't even be doing this but if I don't do it, nobody else here can. My employers don't want to pay a couple of grand for a premade database but they are willing to pay that much in my salary for me to make one. I guess that's how budgets work.
     
    Scotty4x4 likes this.
  4. skylarbrie

    skylarbrie VIP Extreme Gold

    Reputations:
    32,885
    Joined:
    Apr 26, 2012
    Messages:
    10,423
    Likes Received:
    6,756
    search ebay for software..don't be afraid
     
    gwartney likes this.
  5. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    429,310
    Joined:
    Jan 16, 2012
    Messages:
    30,325
    Likes Received:
    31,092
    :jackoff:
     
    gwartney likes this.
  6. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,080
    Joined:
    Sep 23, 2010
    Messages:
    42,907
    Likes Received:
    15,341
    All the free ones are junk, as you might expect. I'm not going to spend any of my own dough. I'd rather waste my time and get paid.
     
  7. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,080
    Joined:
    Sep 23, 2010
    Messages:
    42,907
    Likes Received:
    15,341
    What do I do after that minute and a half?
     
  8. TheMercenary

    TheMercenary Collecting Light Gold

    Reputations:
    359,397
    Joined:
    Nov 5, 2014
    Messages:
    10,446
    Likes Received:
    35,282
  9. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    429,310
    Joined:
    Jan 16, 2012
    Messages:
    30,325
    Likes Received:
    31,092
    :sleep:
     
    gwartney likes this.
  10. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,080
    Joined:
    Sep 23, 2010
    Messages:
    42,907
    Likes Received:
    15,341
    Thanks @AllAboutHim Ed I know it's a tiny task. This just shows you my level of experience. They are using an Excel spreadsheet and tables and I could work with that all day but in the end, they need a database. They are leaving me alone so I'm just figuring it out one tiny bit at a time. I at least know enough to know most of how I want it to end up and what it needs to do with different queries and such.
     
  11. June DeMay

    June DeMay Well-Known Member

    Reputations:
    21,355
    Joined:
    Feb 3, 2015
    Messages:
    2,101
    Likes Received:
    4,216
    Hey, don't get despondent. Look at it this way: they're paying you to learn. Put it on your resume.
     
    gwartney likes this.
  12. OneBallBelz

    OneBallBelz Well-Known Member

    Reputations:
    7,701
    Joined:
    Dec 17, 2013
    Messages:
    991
    Likes Received:
    1,693
    If you are looking at the table view, I would not worry about the column order. Just as long as the correct form object matches the correct column.
     
  13. HelloCleveland!

    HelloCleveland! Well-Known Member

    Reputations:
    29,161
    Joined:
    Jan 5, 2012
    Messages:
    5,247
    Likes Received:
    5,200
    JPEG it :c
     
  14. BleedingGums

    BleedingGums Fesh Fox Faggot VIP

    Reputations:
    17,039
    Joined:
    Sep 21, 2010
    Messages:
    39,886
    Likes Received:
    4,598
    ^
     
  15. Fuzz Nuts

    Fuzz Nuts VIP Extreme Gold

    Reputations:
    24,789
    Joined:
    Jan 10, 2012
    Messages:
    2,164
    Likes Received:
    2,715
    Get a Sim card and that will sort it out. Sim cards are the future.