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

    Reputations:
    101,749
    Joined:
    Sep 23, 2010
    Messages:
    54,048
    Likes Received:
    29,405
    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:
    67,944
    Joined:
    Feb 5, 2014
    Messages:
    8,684
    Likes Received:
    12,488
    scoobyla, gwartney and deadbeat like this.
  3. gwartney

    gwartney Is there gas in the car? 2010 OG Gold

    Reputations:
    101,749
    Joined:
    Sep 23, 2010
    Messages:
    54,048
    Likes Received:
    29,405
    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:
    114,424
    Joined:
    Apr 26, 2012
    Messages:
    13,978
    Likes Received:
    10,632
    search ebay for software..don't be afraid
     
    gwartney likes this.
  5. Lemmy

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    83,677
    Joined:
    Jan 16, 2012
    Messages:
    34,967
    Likes Received:
    44,243
    :jackoff:
     
    gwartney likes this.
  6. gwartney

    gwartney Is there gas in the car? 2010 OG Gold

    Reputations:
    101,749
    Joined:
    Sep 23, 2010
    Messages:
    54,048
    Likes Received:
    29,405
    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? 2010 OG Gold

    Reputations:
    101,749
    Joined:
    Sep 23, 2010
    Messages:
    54,048
    Likes Received:
    29,405
    What do I do after that minute and a half?
     
  8. TheMercenary

    TheMercenary Collecting Light

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

    Lemmy Douchebag Extraordinaire Gold

    Reputations:
    83,677
    Joined:
    Jan 16, 2012
    Messages:
    34,967
    Likes Received:
    44,243
    :sleep:
     
    gwartney likes this.
  10. gwartney

    gwartney Is there gas in the car? 2010 OG Gold

    Reputations:
    101,749
    Joined:
    Sep 23, 2010
    Messages:
    54,048
    Likes Received:
    29,405
    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:
    20,746
    Joined:
    Feb 3, 2015
    Messages:
    3,886
    Likes Received:
    8,071
    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:
    3,046
    Joined:
    Dec 17, 2013
    Messages:
    1,645
    Likes Received:
    2,570
    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 VIP

    Reputations:
    37,974
    Joined:
    Jan 5, 2012
    Messages:
    7,143
    Likes Received:
    9,845
    JPEG it :c
     
  14. BleedingGums

    BleedingGums Fesh Fox Faggot 2010 OG VIP

    Reputations:
    45,025
    Joined:
    Sep 21, 2010
    Messages:
    44,155
    Likes Received:
    8,256
    ^
     
  15. Fuzz Nuts

    Fuzz Nuts Well-Known Member

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