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 Is there gas in the car? VIP

    Reputations:
    18,188
    Joined:
    Sep 23, 2010
    Messages:
    47,051
    Likes Received:
    19,891
    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 Moderator Staff Member

    Reputations:
    16,379
    Joined:
    Feb 5, 2014
    Messages:
    5,455
    Likes Received:
    6,980
    scoobyla, gwartney and deadbeat like this.
  3. gwartney

    gwartney Is there gas in the car? VIP

    Reputations:
    18,188
    Joined:
    Sep 23, 2010
    Messages:
    47,051
    Likes Received:
    19,891
    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:
    24,075
    Joined:
    Apr 26, 2012
    Messages:
    11,535
    Likes Received:
    8,185
    search ebay for software..don't be afraid
     
    gwartney likes this.
  5. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    28,758
    Joined:
    Jan 16, 2012
    Messages:
    32,616
    Likes Received:
    37,511
    :jackoff:
     
    gwartney likes this.
  6. gwartney

    gwartney Is there gas in the car? VIP

    Reputations:
    18,188
    Joined:
    Sep 23, 2010
    Messages:
    47,051
    Likes Received:
    19,891
    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 Is there gas in the car? VIP

    Reputations:
    18,188
    Joined:
    Sep 23, 2010
    Messages:
    47,051
    Likes Received:
    19,891
    What do I do after that minute and a half?
     
  8. TheMercenary

    TheMercenary Collecting Light

    Reputations:
    -3
    Joined:
    Nov 5, 2014
    Messages:
    10,812
    Likes Received:
    36,044
  9. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    28,758
    Joined:
    Jan 16, 2012
    Messages:
    32,616
    Likes Received:
    37,511
    :sleep:
     
    gwartney likes this.
  10. gwartney

    gwartney Is there gas in the car? VIP

    Reputations:
    18,188
    Joined:
    Sep 23, 2010
    Messages:
    47,051
    Likes Received:
    19,891
    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:
    7,956
    Joined:
    Feb 3, 2015
    Messages:
    2,904
    Likes Received:
    6,147
    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:
    1,143
    Joined:
    Dec 17, 2013
    Messages:
    1,347
    Likes Received:
    2,147
    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:
    6,612
    Joined:
    Jan 5, 2012
    Messages:
    6,142
    Likes Received:
    7,100
    JPEG it :c
     
  14. BleedingGums

    BleedingGums Fesh Fox Faggot VIP

    Reputations:
    13,828
    Joined:
    Sep 21, 2010
    Messages:
    41,661
    Likes Received:
    6,044
    ^
     
  15. Fuzz Nuts

    Fuzz Nuts VIP Extreme Gold

    Reputations:
    1,418
    Joined:
    Jan 10, 2012
    Messages:
    2,330
    Likes Received:
    3,193
    Get a Sim card and that will sort it out. Sim cards are the future.