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'm trying to auto scroll the Detail Section where the user will able to see the last record on my continuous form.
Can anyone tell me how to do this?
My sincere thanks!
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
View 3 Replies View RelatedIs it possible to change the color of the scroll bars?
View 1 Replies View Relatedhow can i make a text box (with multiple lines) display a permant scroll bar on the right hand side?
View 2 Replies View RelatedHi Guys,
I have a text box containing a lot of explanitory text and I want vertical scroll bars.
I have set the 'scroll bars / vertical' in the properties of the text box and yet...no scroll bars. I feel that some other setting is preventing the scroll bars.
Anyone got any ideas?
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.
Hi,
I sat my form properties to display both scroll bars, but it's only dispalying the horizontal one even though the form needs the vertical (a few text boxes are not displayed because they are at the bottom of the form).
I have tried to close the DB and reopen it again and played about with the properties, but it still does not show the vertical scroll bar.
Any help will be very much appreciated.
Regards,
B
I am having a problem with displaying the scroll bars in Access. I have created a database which is viewed correctly in 1280x720 screen resolution, which is our standard setting. However, we have recently taken on some users with sight problems, and they are using a different screen resolution.
This means that the forms do not fully display on the page, and I would like to add scroll bars to the access window rather than the form so that the user can move up and down the displayed form. Is this possible?
Any help will be much appreciated!
Help! I'm not sure how I did this, but NO matter what database I go into i can see any toolbar or menu bar. Yes I tried the shift key. How do I turn it all back on?
When I right click I can get the database startup properties, everything has the check, yet I can't see any toolbars or menu bars. I've searched though the help, and I can't see to find out how to put it back.
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
Hi,
i am looking for advice on listboxes. i have various books which all happily state everything exept how to use them!!
1st advice-
i need to know how to create an SQL statement on the listbox so it shows filtered dsata from a query. i am trying to filter by date so the list box could show multiple items carried out on the same date. is it:
SELECT Query.Field From Query Where Field
2nd advice-
a listbox shows data based on a query showing payments. i click on the payment in the listbox and a form opens with the specific data showing.
i have looked around but cannot find much on them.
help would be gratefully received as im currently stuck.
thanks,
NS
How can I remove all the bars specially the menu bar:
File, Edit, View, Insert,...
Hello,
I have two tables: Categories and Subcategories.
Categories contains one field: CategoryName
Subcategories contains two fields: ParentCategoryName and SubcategoryName.
In a third talbe I want to select a category from a listbox, then have the subcategory listbox update automatically with the possiblities. Is this possible?
Thanks.
Maybe somebody can help me with this... in my form I have two listboxes, first one to select the name of the client and the second one to select the contact person of the client... both are linked to a seperate table...
first listbox works fine, only the second one gives me troubles... in the source query I link the ClientID to the ID of the first listbox with...
Forms![PRODUCTIONS]![ClientID]
when I run the form, I get all the time a message window on my screen with the text Forms![PRODUCTIONS]![ClientID] and asking a value for it... I think that I do something wrong with getting the ID from the first listbox....
can somebody help me with this what to do ?
Hi,
Trying to populate a listbox using a .txt file created used WORD. This is the code i'm using:
Private Sub cmdDisplayFile_Click()
On Error GoTo text_open_error
Dim sTemp As String
Open "m:myaccessumber.txt" For Input As #1
Do While Not EOF(1)
MsgBox ("in loop")
Line Input #1, sTemp
lstShowTextFile.AddItem sTemp
Loop
Close #1
I'm getting nothing in the ListBox. Any hints would be much appreciated.
text_open_exit:
Exit Sub
text_open_error:
MsgBox Err.Description
Resume text_open_exit
I have a form with many combo and list boxes, but i don't know how to find a relation between them. I want to select a name of a product that is in a combobox and then a list or text box will show its description.... Please help me because I will burn out sooner or later :eek:
KD:confused:
Hi
I have an Access form. I have a listbox that has the value pulled from a query. I also have a button on the form. When i click the button, the value from this listbox should be appended to a table. So I am trying to do this by referencing this listbox value as Forms!subform!listbox.value . This is storing the value of null. any idea of how to capture the value that is stored in a listbox.
Thanks
Neelima.
Hello,
I created a database, and was trying to get the welcome form, to load full screen. So I unchecked all Menu bar and Shortcut bar (allow)
So I now have locked my self out.
Any ideas, I once remember something like ctrl while opening the database, but that does not fix it.
Thanks,
Ranger
Is it possible to align text inside a multi column list box.
For example, currency field is always aligned to the left
where it should be right aligned.
Kappler
Good Morning all,
On a Form I have a series of Listboxes, each drills down to a final piece of information. The Listboxes store a number_id which displays along with other information In this case the number_id is associated to a TEXT description. When I send the Listbox info to the Report it displays the info but the text doesn't wrap and it gets cut off. There is no "can grow" option on a list box.
So I need to create a Text Box in the Report but when I refrence the listbox in the control source only the number_id shows up. I need to see the associated text (field).
Any help would be great!
Thanks,
Phil "bones"
Hi, my problems are numerous!
I have a form with a number of multiselect listboxes. Their sources are individual tables such as YEARS, PARISHES, CLIENTS. The underlying data is stored in a separate table. I want users to be able to select none, one or some values from each listbox and run a report.
As simple listboxes with one selection permitted this worked fine. I know that my problem is in concantenating the values.
I have tried attaching some code to the OnClick function of a cmd button on the form. I found this code referred to a number of times here and have tried to adapt it but no luck. I have now reduced my form to one listbox to test stuff out- this is the code-
Dim frm As Form, ctl As Control
Dim varItem As Variant
Dim strSQL As String
Set frm = Form!testform
Set ctl = frm!lboparish
strSQL = "Select * from StJamesAgric where [Parish]="
For Each varItem In ctl.ItemsSelected
strSQL = strSQL & ctl.ItemData(varItem) & " OR [Parish]="
Next varItem
'Trim the end of strSQL
strSQL=left$(strSQL,len(strSQL)-300)
The first error I get is "can't find field 'testform'"
My form is called testform
The listbox is called lboparish
The table with all the data is called StJamesAgric
What am I doing wrong???? And also, if this code EVER works, do I need to repeat it for each listbox or do I insert refernces to each list box within just one subcommand?
Any help greatly appreciated.
Stella
hi guys, i was wondering if you can help me. I have a data entry form in which the user has three listboxes from an existing table (only one table for the three listboxes). however if the user selects the same item from listbox1 in listbox2 or listbox3, i want him to get an error message and don't let that happen. how can i do this? vba code?:confused:
this is my form:
Please select your three items of choice.
1st choice 2ndchoice 3rdchoice
listbox1 listbox2 listbox3
listbox1.value cannot equal listbox2.value and cannot equal listbox3.value.
I'm not a programmer by any stretch of the imagination. I'm having an issue I could use a little pro help with.
I have a listbox called "ListDIV" on a form called "fRptCriteria". I am trying to have a query called "qOpenOrds" look to the listbox for some parameters. The field on the query is called "DVNO2Y". The form also contains serveral Calendar Controls "SDate" and "EDate" that the query is looking at too.
In the past, I've had no difficulty referencing a Combo box, but the is listbox issue is driving me nuts!
Thanks in advance.....
Hello,
I would like to create a search form with four combo and a listbox which would display the result of the combo.
All combos get data from Table1.
I would like to add:
cboSSN
CBOLNAME
CBOFNAME
CBODOB
When users will select a SSN, then CBOLNAME will return all records showing a the same Last Name with data SSN.
If users will select cboLNAME, then CBOFNAME will return all first names of the records with that specific Last name.
Is there a way I can do this or same example? Thanks.
I have a form that has two listboxes. The first list box is named "lstType", which pulls in information from a table tblType. The second or dependent listbox, named lstSName, is then filtered and only shows the SName that match the type. This is pulled in from a table "tblSName." Using the form filtering on the query "[Forms]![frmqryTask]![lstType]"
This portion actually works perfectly and filter my form as I wanted it too (at least originally). However, I realized a few days ago that the when clients or the SName does not have any active projects my company will be working on for them, we don't want don't need to see their name on the forms listbox called "lstSNameand", so we want change a status from "Active" to "Inactive". I've already added this status in as well.
What I'd like to have happen is that when using the dependent listbox, the lstSName will only show those with the "Active" status. I've tried adding the status = active onto the query, however I get a error message saying the query is too complex to run, which I'm guessing has something to do with the "[Forms]![frmqryTask]![lstType]" on the query.