Here is how my table is set up:
System1 Subsystem1
System1 Subsystem2
System1 Subsystem3
I need a query that puts the data into one record, different cells:
System1 Subsystem1 Subsystem2 Subsystem3
Can this be done?
Thanks,
MJ
Hi, In MS Access,
In the form design,
How can I change the Vertical Scroll bar color?
I want to keep it for using, but the color is always grey color.
How can I change the color of the scroll bar?
Thanks.
Hi there, I got a little data transformation problem:
I have got a source table:
ID 1 2 3
1 x y z
2 xx yy zz
That I wanna transform to the following format:
ID ID2 Comment
1 1 x
1 2 y
1 3 z
2 1 xx
etc...
The problem is, that I need a routine that takes the column names of table 1 and uses them as values in table 2. So basically, every column of table 1 (1,2,3, etc.) should become a new data record in table 2.
Any ideas how to solve this?
Thanks!
Steve
I have a Volunteer Database that has teams. There is only one team leader but some of the teams have two or three assistants. Currently I have a query that lists all the assistants for each team vertically.What I want to do is list the Assistants horizontally under headings like Assistant 1; Assistant 2; and Assistant 3 for each team on one line.
View 6 Replies View Relatedbob@smith.com, 2010-01-10
bob@smith.com, 2010-02-10
bob@smith.com, 2010-03-10
bob@smith.com, 2010-04-10
ronda@q.com, 1984-01-02
ronda@q.com, 1990-04-02
ronda@q.com, 1996-08-02
want above data to appear as
bob@smith.com, 2010-01-10, 2010-02-10, 2010-03-10, 2010-03-10
ronda@q.com, 1989-01-02, 2010-04-10, 1984-01-02, 1990-04-02, 1996-08-02
How to Creating a Three-Level Navigation Form, First and second level must be in horizontal orientation, third level desirable be to vertical orientation and dependent of level 2.
View 1 Replies View RelatedI have a form which I would like to enable scrollbars both horizontally and vertically (the main reason being, the application is designed for users with large / wide screens but may at some point be required on smaller screens)
Currently I have the scrollbars switched off and the form maximises but everything goes to pot if I resize the window. I'd like to add the scrollbars so if a user wants to resize the window to, say, half the screen, they can still scroll across to the 'hidden' parts of the form.
The problem with this is, if the form is maximised - or at least large enough to show the entire form - the area of the screen where the horizontal scrollbar resides is white (whereas the background colour of the form is a pale green) Which is quite unsightly.
I know I can remove the problem by removing the horizontal scrollbar and the navigation bar (which is already gone!) but then I can't scroll?
Is it possible to have a horizontal scrollbar but not have that white space at the bottom when the scrollbar is not required?
(Doesn't appear to be a problem with the vertical scrollbar?...)
I need to replicate an existing report that has a number of 3 columns across the page and has 35-40 rows down the page...it's like a table in Word or a spreadsheet in Excel. I need to print the column and row lines.
Is there a simple way to include these in the report other than me drawing each and every line?
I have a query that looks like this:
TeamAway TeamHome Jury
---3----------6--------4
---9----------4--------2
---7----------8--------3
---2----------3--------4
How do I get a horizontal max so my query looks like this:
TeamAway TeamHome Jury Winner
---3----------6--------4--TeamHome
---9----------4--------2--TeamAway
---7----------8--------3--TeamHome
---2----------3--------4--Jury
Hi,
I need to produce a report in which some records are repeated ACROSS the page rather than down.
If I was using Excel I'd just use Copy - Paste Special - Transpose.
Is there any way I can duplicate this approach in Access?
Settings are:
Column Count: 2
Column Widths: 0"; 20"
Bound Column: 1
Width: 9.5417"
Why am I not getting a horizontal scroll bar?
If I add a 3rd column in I get a horizontal scroll, but it scrolls from column to column instead of across the full text of one column.
I have a list box which shows table data, however i have alot of data and i need a Horizontal Scroll Bar in the list box, so i can view the data.
Any ideas or help?
Kind Regards
Richard
How do you add a horizontal scroll bar to a list box?
View 1 Replies View RelatedHow do you add a horizontal scroll bar to a list box? I know that access will add a horizontal scroll bar when neccessary, but it will not add one to my list box. Is there a way to manually add one?
View 3 Replies View RelatedI am having a problem with the formatting of a report. My boss would like for the report to show (grouped by employee name) a horizontal list like below and update itself.
Aircraft AS350 A119 AW139 AW189
Training Hours 300 50 25 160
OJT Completion 85% 100% 25% 45%
Each training class has a category in the table showing which model(s) the training is. For OJT I got it to count up the tasks and tasks completed in each model and calculate the percentage. I can easily get it to show vertical for each employee. I cannot get it to show like above. I tried using IIF statements to pull the hours and OJT by model aircraft. If I try to put it in the detail section it shows vertical and if I put it in the group of employee name it only returns one record (I assume its still trying to show vertical). The only way I could think of to get it to show properly was a crosstab query but its my understanding those are for archival purposes or for a snapshot and do not update. This report will need to update as things are entered.
I tried searching, to no avail. I've attached pics to represent my issue a bit clearer. I have a form that I want to be my switchboard, but my clients all have different resolutions, and this is where I run into the problem. I want the switchboard to not only be maximized, but appear maximized.
Here is the design view: Linkage (http://www.martinaustin.net/images/issue_design_view.jpg)
Here is the form view: Linkage (http://www.martinaustin.net/images/issue_form_view.jpg)
I want the date and bottom line to always be at the bottom. This works fine by simply using form headers and footers. The issue is that the Admin button will appear near the center (vertically) when viewed on a computer with high resolution, instead of just above the bottom horizontal line as I intend.
Does anyone know of a way to fix this?
Hi,
I have to create a horizontal across the chart whereby the y-axis value is 1500.
Can anyone help me?
Regards,
Dawn
I have a form in datasheet view, with the record ID column frozen and users typically scroll to the right to see certain columns. Different users scroll to a different position.
I dont have the option to reduce the number of columns or create separate forms for different users, - they all need to see all the columns but typically a user scrolls horizontally to see a certain set of columns most of the time. I want to save that position for the next time they open the form.
I have a database with employee folders containing various bits of information. My intent is to have a main page with a sub report or from containing employee names. Instead of the names being displayed in a single vertical column with a scroll bar, I would like to display multiple columns of say twelve names each with a horizontal scroll bar no information with be edited from the "main" page..
The information would be "last name, first name" from a query, you would select (highlight) the name and hit a button to bring up a different form with that employees information or double click for the same results.
How would I go about getting vertical lines as column seperators down the entire page. The problem I run into is every time the row size changes there's a break in the column dividers. Someone suggested using a function in the On Print event for the report, but there is no OnPrint field in the event tab of the reports properties. If anyone ever did anything like this before, please let me know.
View 5 Replies View RelatedIs it possible to set tabs along the right hand margin of a form going vertical instead of the default horizontal from the top of the form?
View 5 Replies View RelatedDue to limited space in my Report Heading, I am trying to vertically label columns. I figured out in the Properties section of the label that I can turn on Vertical Label. However, when I view it on the report, the label, which is now vertical is turned to the left vs the right. How do I flip it? In addition, is there a way to rotate the text to a 45% angle.
Thank you.
GeneS
Is it possible to change the scroll type to a "smooth" scoll when I'm in table view of a table?
View 2 Replies View RelatedI have a series of Unbound control boxes in one row. some text extend to two lines and I want everything to be centered both horizontally and vertically.
Can't figure out how to vertically align the contents of the controlb boxes...
Rather than manually draw vertical lines on my forms, I'm looking for a way to generate vertical lines using VBA code. Has anyone done this?
Thanks,
pc
I have a text label that I would like to have vertical instead of horizontal. In the properties box, I go to the other tab and set 'Vertical' to yes and the text rotates. Except it rotates 90 degrees clockwise. (The text starts at the upper right corner and reads down, you have to tilt your head to the right to read it.) This seems the wrong direction to me and to my office mate - all the tables we've seen with vertical text has the text rotated 90 degrees counterclockwise (text starting from the lower left corner and reads up, you have to tilt you head to the left to read it.)
Is there any way I can make the text rotate counterclockwise instead of clockwise? I really don't want to create many little graphics.
Thanks