I've added an address book to my current database and I was wondering if there was a way to view the records tiled similar to that of Outlooks adderss book. So far the best solution I have come up with is to just use a continuouse form, but that still just gives me the records vertically. I would like to place them left to right and vertically if possible.
Tile records in continuous forms?
- Thread starter ITguy1981
- Start date
VilaRestal
';drop database master;--
- Local time
- Today, 11:57
- Joined
- Jun 8, 2011
- Messages
- 1,046
That sounds like a ListView control.
That's the only thing that will look like that and you'll in effect be restricted to just showing one field (or a calculated field that combines more than one) and you can't bind it so there'll be a lot of code to populate it and a lot more if you want users to be able to edit the displayed field.
Search for ListView in these forums and the sample database for help with that. If you're new to programming then it will be a tall order to learn something that sophisticated.
I expect you probably could design an unbound continuous form that would have columns as well as rows but it would be a lot of code too and Access doesn't lend itself well to that because you can't declare controls at runtime: every possibly-needed column would have to be put there at design time and hidden at runtime if not needed. I doubt you'd ever manage to get that looking as professional as you'd like.
That's the only thing that will look like that and you'll in effect be restricted to just showing one field (or a calculated field that combines more than one) and you can't bind it so there'll be a lot of code to populate it and a lot more if you want users to be able to edit the displayed field.
Search for ListView in these forums and the sample database for help with that. If you're new to programming then it will be a tall order to learn something that sophisticated.
I expect you probably could design an unbound continuous form that would have columns as well as rows but it would be a lot of code too and Access doesn't lend itself well to that because you can't declare controls at runtime: every possibly-needed column would have to be put there at design time and hidden at runtime if not needed. I doubt you'd ever manage to get that looking as professional as you'd like.
The data will not altered in the view. I currently have a form that is used to enter the contact name, title, phone numbers, etc. I have another form that is displaying the records in a continuous form. That form has a few buttons in buttons to change the orderby of the form so there are different sorting options. I was hoping to design something similar to a rolodex where I could have sort buttons a-z and then show the view as 3 or 4 records across and then fill vertically. I may just leave it as is. I'll look in to listview controls. I've done a bit of programming in access now as far as coding file pickers and what not. I'll see if I can figure it out. Thanks for pointing me in the right direction.
