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.
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 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?...)
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
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?
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 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'm having a vertical scroll issue thats very strange. Most of the time I can scroll vertically fine, but every now and then it locks up and wont let me scroll down, especially with the mouse wheel. A couple of the engineers have had even weirder symptoms where they cant even scroll down using the arrow keys on the keyboard.
View 14 Replies View RelatedIs it possible to change the scroll type to a "smooth" scoll when I'm in table view of a table?
View 2 Replies View RelatedIs there a way to change the vertical scroll bar position to always be at the top when I move from form to form. Right now, it will start at the top, but when I move to a different form and back, the vertical scroll bar is positioned in the center. I turned off the autocenter property of the form and saved it in the desired position, but that doesn't work. My form is maximized when it opens. I would greatly appreciate some help. This has been an annoyance for quite some time now.
View 1 Replies View RelatedI have a subform that�s in datasheet view, is there a way to align the vertical scroll bar to the left side?
Using:
Win 7
Access 2010
I have a form and in the form is a subform. When I add a record with the following code, the subform detail scrolls in such a way that you can't see the record you just added...only a single blank new record. Can you set the scroll position so that I can see all the previous records including the one I just added?
Private Sub Add_PROJ_RECORD()
On Error GoTo Err_Add_Click
Me.PROJECT_DATA.Locked = False
Me!PROJECT_DATA.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.PROJECT_DATA.Form.PROJ = PROJ_COMBO
Me.PROJECT_DATA.Form.SPEC = SPEC_COMBO
Exit Sub
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?
I 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 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 Related