Because I'm bloody stumped everywhere else.
Access 2010
I've got a million rows of data (not quite), with loads of columns too. I can't print all the columns in a row - too many - so I wanted to design a view where I can see all the data from one row of the document, spread over several rows of the display. Does this make sense?
Access's "Form View" just gives me a blank grid with no apparent way of designing things. I've gone to "Create / More Forms / Split Table" is pretty good, but it's not really what I want. Although that's closest, for any Access wizards who are able to help out.
Please help, because I feel stupid.
First question is how many columns do you have and why do you need them all in a single view?
You should be able to very easily create a form and bind it to your table or query. I think the problem you might be facing is that the view property of the form will default to datasheet when you want it to be either Single or Continuous (depending on how many records you want to see at once) which will allow you to place all the fields you like on the form.
I'm actually in bed at the moment and the thought of this one massively denormalised table has given my data modelling snobbery a fit of the vapours but I can have a look in the morning if that doesn't help.
It's a database of people from my area who served in WW1, and my friend is doing...something, with it, not sure. There are maybe 20 columns, and a few thousand rows? I'm sure there's a way to do it, but I'm addled with painkillers and am not at my sharpest. And know basically nothing about Access.
Quote from: Famous Mortimer on 01 July, 2015, 07:46:55 AMThere are maybe 20 columns, and a few thousand rows?
Okay. I took "loads of columns" to mean hundreds.
From the ribbon, go to Create>Forms>Form Wizard and let it guide you through the steps (select the source table and the fields you want to display.) This should give you a base to work from and you can then rearrange, resize and format the individual fields to your hearts content. As I mentioned above, changing the Default View property of the form object between Single Form and Continuous Form will affect how you see the data. From what you're saying you probably want continuous.
Beyond that, there are plenty of videos on YouTube which will talk you through it.
I must have put the wrong sort of questions into Google. My friend showed me a printed off page with all the information displayed the way she wanted, that presumably someone else on the same project had done, and said "can you do this?"
I'll try doing all this. Thanks for the help, and I may be back later with more requests.