Listbox HELP: Horizontal Scroll???

Mar 15, 2006

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.

View Replies


ADVERTISEMENT

Vertical/Horizontal Scroll Bar

Jan 6, 2006

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.

View 4 Replies View Related

Add A Horizontal Scroll Bar To A List Box

Feb 27, 2008

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

View 6 Replies View Related

Adding A Horizontal Scroll Bar To A List Box

Aug 25, 2004

How do you add a horizontal scroll bar to a list box?

View 1 Replies View Related

Adding Horizontal Scroll Bar To List Box

Sep 3, 2004

How 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 Related

Forms :: How To Get Horizontal Scroll Position On A Form

Jan 9, 2015

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.

View 2 Replies View Related

Tables :: Smooth Horizontal Scroll In Table View

Oct 19, 2012

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 Related

ListBox Selects Row When Scroll Bar Is Clicked

Oct 31, 2006

I'm using Access 2002 and when I try to scroll up or down it selects the row and then scrolls 1 row. Is this a bug?

thanks
Paul

View 1 Replies View Related

Modules & VBA :: Scroll Listbox To The Top - No Selected Records

Apr 23, 2014

I'm using the following code to clear selected records from a listbox after a button is pressed:

Code:

For i = 0 To lstProducts.ListCount - 1
lstProducts.Selected(i) = False
Next

The code works great except that it leaves the listbox scrolled all the way to the bottom. What is the best way to scroll back up to the top of the listbox without selecting another record?

View 3 Replies View Related

Modules & VBA :: Access 2007 - Scroll Listbox Back To Top Without Changing Selections

Jan 29, 2014

I have a listbox which is populated by a query from a table.

I also have a sub which allows users to quickly select multiple items from the listbox (based on a pre-defined criteria) rather than scrolling through and selecting them manually / individually

The sub works fine but when it is finished, the listbox is automatically scrolled to the bottom (or, rather, to the last selected item)

I would like to have the listbox scroll back to the very top once all of the appropriate items have been selected.

(I could loop through the listbox items in reverse - or 'bottom-up' - in the code but that would only have the desired effect if the topmost item was selected. I want it scrolled to the top regardless of whether the topmost item is selected or not).

View 2 Replies View Related

Forms :: Access 2003 - Scroll To Selected Item On Multiselect Listbox

Sep 2, 2013

I've got a form with a multiselect listbox (extended) that holds a very long list of items (~90,000):

1 | Apple
2 | Orange
3 | Banana
...............
35313| Corn cob
...............

The user can select multiple items (non-sequential) on the listbox, say items 1 and 35313. I'd like the listbox to scroll (meaning display) to the currrently selected item, so that the user can see it while being processed.

I've seen stuff about property ListIndex, which does exactly that, but it's only useful when you have just ONE item selected (in a multiselect listbox apparently it deselects the rest of the items, so no point in using it, I guess, unless there's more to it!!).

So the key here is how to do the scrolling/display.

The code to loop through the listbox and process each selected item is attached:

Code:
Dim vItem As Variant
Dim Content as String
For Each vItem In Me.lst.ItemsSelected
'scroll to selected item ???
'processing of the selected item
Content = Me.lst.Column(1, vItem) 'copy the content to do sth with it
Me.lst.Selected(vItem) = False 'unselect the current item
Next vItem 'go to next selected item

how to scroll to the currently selected item? Mind that I need to go through the list of selected items to process them for further use (i.e, I need them selected).

View 4 Replies View Related

Forms :: Subform Scroll Bar Scroll To Bottom?

Apr 25, 2013

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

View 2 Replies View Related

Horizontal MAX

Apr 24, 2008

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

View 3 Replies View Related

Horizontal Report

Sep 3, 2007

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?

View 4 Replies View Related

Vertical To Horizontal

Apr 27, 2007

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

View 14 Replies View Related

Transform Table From Horizontal To Vertical

Jun 4, 2007

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

View 1 Replies View Related

Reports :: Horizontal Formatting Of A Report

Apr 23, 2015

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.

View 1 Replies View Related

Having Details Section Stretch Vert And Horizontal?

Feb 27, 2006

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?

View 1 Replies View Related

How To Create A Horizontal Line Across The Access Chart?

Mar 16, 2005

Hi,

I have to create a horizontal across the chart whereby the y-axis value is 1500.

Can anyone help me?

Regards,
Dawn

View 1 Replies View Related

General :: Names In Multiple Horizontal Columns

Dec 18, 2013

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.

View 6 Replies View Related

Queries :: Transpose Vertical Text Values To Horizontal

May 25, 2013

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 Related

How To Make Vertical Data Horizontal And Remove Duplicate

Mar 10, 2015

bob@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

View 1 Replies View Related

Reports :: Access 2013 / Horizontal Limit And Adding Fields?

Sep 26, 2014

I have access 2013 windows 7, I'm trying to expand the record keeping on a database someone else designed. I've added the fields i need to the Recordsource(s) (the table, query, and working on the form as well) I can't make the report any larger it seems (its currently at 22") and i need to add another "page" worth of fields horizontally; is there a way to do that? and also to replicate the header and other key fields so they're on that 3rd page.

View 3 Replies View Related

Forms :: Three-Level Navigation Form - First Two In Horizontal And Third In Vertical Orientation

Sep 20, 2014

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 Related

Forms :: Allow Horizontal And Vertical Scrollbars But Remove White Space (AC2007)

May 22, 2014

I 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?...)

View 8 Replies View Related

Reports :: Printing Lines Vertical And Horizontal In A Report Like Table In Word Document

Sep 12, 2013

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?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved