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.
Try this link: https://social.msdn.microsoft.com/F...msaccess-queryselect-statment?forum=accessdev Columns and rows brah, columns and rows.
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.
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.
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.
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.