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.
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 am at work, and I have acquired a database that prints labels. They now want the database to be coded so that after certain labels are printed the database will print a blank label. I have the code figured out as a Do While statement in order to print the blank label. The problem I am having is that I am trying to use the Insert Into command to insert the filepath into the table that adds the blank label.
|DoCmd.RunSQL "INSERT INTO Rod_tmakLabels ( Print, [Order] ) SELECT Yes AS Expr1, 'Rods Labels' AS Expr2"|
If I run the above command, it just adds the text "Rods Labels" at the end of the table. Is there anyway with the INSERT INTO command that I can insert the new label between the 2nd and 3rd row and add another row? Or is the command designed only to add a new row to the end? I haven't had any luck searching for this yet.
I need to devise a query to append data for a particular Department_ID from TBL_NEWDATA to TBL_PERSON_ALLOCATIONS where that data does not already exist there. i.e. for Department_ID 'Research', I would want to append 'Person_ID', 'Department_ID' (in this case: 'Research') to TBL_PERSON_ALLOCATIONS for any tuples not already held.
INSERT INTO TBL_PERSON_ALLOCATIONS (Person_ID, Department_ID) SELECT Person_ID, Department_ID FROM TBL_NEWDATA WHERE TBL_NEWDATA.Department_ID='Form...'
[code]...
This Query takes a single argument from a control (Forms!Main!IN_Department), and this is the Department_ID to be updated.Is there any way to do this using a single query or will I have to use sub queries? I'd hoped not to as to keep the database as concise as possible.
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????
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.
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.
Basically what I want to do is create a form that combines 2 tables. For example, I want to be able to display a name, then display and be able to scroll through all information associated with that name. For instance, if the name had more than one address, how would I create that form with the right relationships and with the scroll bars? Thanx
When I am filling data in a form, I will use my scroll button on my mouse to go to the next field. Instead, it takes me to the next record. How can I prevent from going to the next record? Thanks!
I am a newbie to access programming...... I have forms, and while entering data in them, somebody scrolls the mouse, it does not save the information and starts showing all the records. I want to prevent thos mouse scroll event from happening.... i will ike to disable the mouse scroll event for my database.. Has some one run into this problem..... Please let me know, how i can take care of this..... I will really appreciate it..... Thanks
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?
I'm using aleb's most handy code from this thread (http://www.access-programmers.co.uk/forums/showthread.php?t=100636) to have a multi select list box that determines recipients of an e-mail from the list.
I thought it would be handy to have it make a list that updates at the same time, showing what e-mail addresses will be sent. Here's the code I used:
Private Sub lstMailTo_Click() Dim varItem As Variant Dim strList As String Dim strElist As String
Me.cmdEmail.Enabled = True With Me!lstMailTo If .MultiSelect = 0 Then Me!txtSelected = .Value Else For Each varItem In .ItemsSelected strList = strList & .Column(0, varItem) & ";" strElist = strElist & .Column(0, varItem) & vbNewLine Next varItem If strList = "" Then Me!txtSelected = strList Me.cmdEmail.Enabled = False Me!txtEadd = "" Else strList = Left$(strList, Len(strList) - 1) Me!txtSelected = strList Me!txtEadd = strElist End If End If End With End Sub
The code works, but when the text box becomes filled, you cannot see the bottom of the list. How can I set it to know this and automatically put a scroll bar in, so the addresses can be reviewed before hitting send? I was interested to see if I could do something similar, but instead have a label display just the last item selected. I tried strElist = .Column(0, varItem) and setting the label caption to strElist, but this only displayed the first item selected. How would I do this?
I'm using Access 2002 SP3 and have a number of comboboxes that all have the same problem.
When I scroll to the bottom of the list it only shows part of what I expect to see and when I let go of the scrollbar it pops up to the middle of its travel.
Scroll down again and I see more of the list. I have to scroll down 5 times in order to see the complete list.
On the database I am working on, it would not be convenient for me to install the mouse scrolling that determines if the mouse should scroll down the form, or to the next record.
That is a nice feature, but more than I need.
I only need to disable the mouse scroll bar (so the users do not get confused and then update the wrong record). Is there an easy way on the open of a form to completely disable the mouse scrolling feature?
In the forms that I have made, none of the listboxes ever scroll with the mouse scroll wheel. I have tried to click into the listbox first to ascertain that the focus is in the listbox but nothing works. the only way to scroll is to manually drag the scroll bar tab. I want to find out how i can make my scrolling work. I guess that there must be a global setting somewhere to switch it on or off... Any insight into this will be highly appreciated!
I am building a database that I need to have the scroll wheel completely disabled or have it actually scroll the screen when I use it. Because as you already know when in a form it will cycle through the records rather than move down on the page.
