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 form that i have created with various tabs along the top, e.g. customer details, customer contact etc etc.I have a subform on one of the tabs.
That subform also has tabs on it.When clicking on the main form tab it goes to subform but the scroll bar moves down only to show the subform tab options. I have to keep scrolling back up to see the main form tab options.
I have a subform on my main form that uses a query to display the information. On the query and subform there is a discussion field. I would like to put a scroll bar on this field so the user can scroll through the text since it could possibly be large but the scroll bar function does not work on this field. I have tried setting the scroll bar feature in properties for the sub form field but it will not put it on this field. Any ideas????
I have a subform that is populated by query results. In the query i have a field called Discussion that is just a free form field where the user can input any information. On my subform the field is not big enough to show all of the data if it gets large. Is there a way to add a scroll bar to this field on my qery so it will appear on the subform so the user can scroll down if necessary to see more of the text in this field?
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.
i have a continuous form used for selling item , i want when the user selling item the scroll mouse working with the current record look the attachment to see how to fix the problem .
My problem is that I have a couple of forms where scrollbars are not appearing on forms when they are too long to fit on-screen. Instead they're just going below the bottom of the screen and there's no way to access things at the bottom of the form. This is happening with a data input form as well as with a form I'm using to filter and display a report. I've tried selecting both "Vertical only" and "both" for the scrollbar property of the form, but it doesn't seem to make any difference.
The forms are being opened in "dialog" mode, the only option for opening a form in a web database when using a macro to open it, it seems. If I manually open the form in 'normal' mode, it has scrollbars. Also, if I open a report with a macro (on click), it has the option to open in 'normal' mode and has scrollbars and all is well. But if I want the user to be able to click a button to open the form, it seems I have to use dialog mode.
I have a form with four pages and subforms on each page. I am having issues with scrolling on pages 2-4. The first page will scroll correctly (to the bottom of the form), but the other pages will not scroll at all. I did enable the scroll bars on the subforms, but they will only scroll to the bottom of the viewable form, not the whole form, which I would prefer. Is there a way to scroll through the whole form on pages 2-4? I tried setting the focus to the form itself, but my code didn't work:
Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long) Me.Parent.FRM_TABLE_TAB_1.SetFocus End Sub
I would change the form; however, it is designed to look exactly like the actual questionnaire.
Hi! I want to disable the usage of mouse scroll on my forms. Because, as things are now, you may accidently choose/ scroll to another Record/ Post, when editing data for one specific record.
How do I accomplish disabling usage of mouse scroll?
I have a main form EMPLOYEE RECORDS with employees information, with a Subform, where pay records are entered. Mysubform always shows record 1 of 1, and I cannot scroll back to see previous records. How can I see the previous entries.
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.
Most my short text fields on my form are normal, but some have scroll buttons like a memo box and it's annoying, especially because the user can't jump to the next field by pressing return.
I gather that there is no way to include a scroll bar on a memo field in a form. What is the best workaround? The source is a mysql odbc table. It is set as medium text and comes into Access 2010 as a memo field. For a user coming to this field to read the material entered there, unless they click somewhere within the field, there isn't a scroll bar. It isn't obvious that that is what they need to do to see all of it. Is there any way to work around this limitation?
I have recently updated several forms from Access 2003 to 2010.
On the old version I could 'hold down' the forward or backward pointers to quickly scroll through the individual records. Now I have to click each individual record to move one at a time.
Have I inadvertently changed a setting or is the quick scroll option no longer available?
I've got a continuous form that displays my massive 3,000+ inventory, with the option to filter down to specific categories. Some categories have 5 items, others have hundreds. The design I have used makes it look really tacky once I filter down to one of the categories that has 5 items, because there is no scroll bar.
What I've tried using is:
Code: If Me.RecordsetClone.RecordCount < 10 Then Me.Scrollbars = 2 'vertical only Else Me.Scrollbars = 2 End If
But it still doesn't display correctly (nobar.png). This is probably my biggest headache right now, and every "solution" I've found, doesn't work.
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).
My question is: I have a subform which is located in a Tab control within a main form. The subform is horizontal and exceeds the page width. When inserting data the Tab key doesn't result in auto scrolling of the page to the right (as opposed to using Tab in a regular form). This means that I have to use the horizontal scroll bar all the time. How can I fix this?
The detail section of my (continuous) form may or may not have a scroll bar on the side depending on the number of records. When it is there, it is way off to the side and the user may not notice that there are more records to view. I'd like to add Up/Down buttons to the footer that become visible when the scroll bar is visible, and work like the Up/Down buttons on the scroll bar.
I'm a fairly new user of Access-self taught, working for a small company. I can't figure out how to insert a scroll bar in my form to allow users to scroll down to the bottom of the page. When I switch to design view, a scroll bar is automatically included, but when I switch back to form view, there is none. I've tried inserting a scroll bar from the "More Controls" button list, but it won't scroll my form: the slider just blinks when I try to move it around. Any help would be appreciated.
Hi everybody. I need some major help. I created a form that does not fit in one screen (too long),so I use scroll bar. The problem is that when i turn the wheel up/down on mouse, it flips through all of my user IDs, like ID1, ID2, etc. instead of scrolling down. What do you propose? Thank you.
