Format a form to show records horizontal instead of vertical.

[Craftsman61]

What I need is to make a form that resembles an already designed sheet. Where as the data, being in a table going horizontally (with several rows(4)of this table seperated by space between each row). I've already designed it vertically but management wants horizontal - can this be done in access 2000?

What I have is a table with the following;
name: tblTIMEOFF
field: E_CODE (text, 3 digits)
field: used (yes/no)
field:[primary]DATE (short date like 9/9/1999)

where in a horizontal row date date date date
e_code e_code e_code e_code
used use used used

Is this possible oh experience and generous guru's of access ?

 

[JeremyNYC]

Not impossible, but not anywhere close to easy.

It would involve using an unbound form with a grid of text boxes and lots of code to move data from one set of text boxes to the next or previous set.

I would say that, this time, management doesn't get what they want, unless they want to pay a good bit for it.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[Craftsman61]

Well my table is a fixed length of 54 records - what i was thinking of is to do a vb loop to assign record 1 field 1 to text box 1 and so on.

(upper management around here says do this with no direction so they can p**** the heck out of ya by critizing your work. Sort of like keep the down man down).

 

[JeremyNYC]

Hmm. Just thinking out my a** here, but...if it's really, truly, and forever fixed at 54 records (can I emphasize more that it will be a huge drag if that number changes?), then what about swinging your table around and making it 54 fields and only several records? Then you could have all of the records displayed and use the horizontal scroll bar to view the different fields, BUT, to the user it would look like you have all of the fields displayed and you're using the horizontal scroll bar to view the different records.

How's that sound?

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.