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? Gold

    Reputations:
    37,651
    Joined:
    Sep 23, 2010
    Messages:
    50,305
    Likes Received:
    24,092
    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:
    30,907
    Joined:
    Feb 5, 2014
    Messages:
    6,675
    Likes Received:
    9,229
    scoobyla, gwartney and deadbeat like this.
  3. gwartney

    gwartney Is there gas in the car? Gold

    Reputations:
    37,651
    Joined:
    Sep 23, 2010
    Messages:
    50,305
    Likes Received:
    24,092
    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:
    103,350
    Joined:
    Apr 26, 2012
    Messages:
    12,926
    Likes Received:
    9,679
    search ebay for software..don't be afraid
     
    gwartney likes this.
  5. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    70,686
    Joined:
    Jan 16, 2012
    Messages:
    34,118
    Likes Received:
    41,431
    :jackoff:
     
    gwartney likes this.
  6. gwartney

    gwartney Is there gas in the car? Gold

    Reputations:
    37,651
    Joined:
    Sep 23, 2010
    Messages:
    50,305
    Likes Received:
    24,092
    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? Gold

    Reputations:
    37,651
    Joined:
    Sep 23, 2010
    Messages:
    50,305
    Likes Received:
    24,092
    What do I do after that minute and a half?
     
  8. TheMercenary

    TheMercenary Collecting Light

    Reputations:
    -6
    Joined:
    Nov 5, 2014
    Messages:
    10,809
    Likes Received:
    36,040
  9. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    70,686
    Joined:
    Jan 16, 2012
    Messages:
    34,118
    Likes Received:
    41,431
    :sleep:
     
    gwartney likes this.
  10. gwartney

    gwartney Is there gas in the car? Gold

    Reputations:
    37,651
    Joined:
    Sep 23, 2010
    Messages:
    50,305
    Likes Received:
    24,092
    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:
    16,392
    Joined:
    Feb 3, 2015
    Messages:
    3,357
    Likes Received:
    7,205
    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,999
    Joined:
    Dec 17, 2013
    Messages:
    1,494
    Likes Received:
    2,374
    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:
    10,561
    Joined:
    Jan 5, 2012
    Messages:
    6,530
    Likes Received:
    8,058
    JPEG it :c
     
  14. BleedingGums

    BleedingGums Fesh Fox Faggot VIP

    Reputations:
    22,298
    Joined:
    Sep 21, 2010
    Messages:
    42,894
    Likes Received:
    7,156
    ^
     
  15. Fuzz Nuts

    Fuzz Nuts VIP Extreme Gold

    Reputations:
    2,057
    Joined:
    Jan 10, 2012
    Messages:
    2,377
    Likes Received:
    3,321
    Get a Sim card and that will sort it out. Sim cards are the future.