"Tab" Doesn't Scroll Right In Subform
Hi,
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?
Any suggestions would be appriciated
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
SubForm Scroll Bar
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????
View Replies !
View Related
Scroll Bar To SubForm Query Results
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?
View Replies !
View Related
Scroll Bars Controlling More Than One Subform
Access 2000 front end, SQL Server back end --------- I have a main form with a tab control, and under one tab I have two subforms. There are no parent/child relationships, and each subform is independent of the other (i.e. neither is a subform of the other). The first continuous subform (I'll call it sbfA) generates an identity/autonumber (primary key) and feeds it into the other continuous subform (sbfB) by way of VBA code. Every time the user enters a new record into sbfA a new number is generated and sent to the primary key field of sbfB, so there is exactly the same number of rows in each. The subforms are visually aligned in the tab control to make the user think there is only one large subform. My problem: When the subforms contain too many records, the user will need to scroll down the page, but I need to use just one scroll bar to control both subforms. If there are two scroll bars (one for each subform), scrolling may cause the records in sbfA not to be perfectly aligned with the corresponding records in sbfB, which would be disastrous for data entry. ---- I realize that I will probably have to write my own scroll bar code, but I don't know how to access scrollbar methods or properties in VBA. If what I am trying to do is impossible, I would love some alternative solutions too!
View Replies !
View Related
Subform Doesn't Complete
ello everyone. I have a major problem. I have an invoice system. Everything works fine except this. I have a form where i select from 2 lists the customerid and the invoicenumber. When i click on the invoiceno list i refresh the page in order for the subform that contains the details to complete. This doesn't happen. I try with linked master - child fields, itried with parameters, nothing. Is there a trick when using this? Why the subform does not complete? Please i need urgent help. I have attached the db. Please help me.
View Replies !
View Related
One Subform Shows Data, The Other Doesn't
If you take a look at the Maintenance Request form, you will my 2 subforms - quotes & Invoices. The invoices subform shows the data relating to the Maintenance Request when you open the form, but the quotes subform only shows the quote information after you have saved the record.I can't spot anything different about the 2 subforms.I can't get the size down no matter how much I delete, so you will find the database at ftp://greven.serveftp.com/Copy%20of%20Rentals%20Maintenance%20Database.zip
View Replies !
View Related
Sorting Of Query In Subform Doesn't Happen
Hi, I have a query for a subform which is displayed in datasheet mode (see attachment). I've created a form based on a query and used it as a subform. The "casenumbers" per clients are displayed from 1 and upwards, I would like to have them sorted Descending. So in the query I sorted them that way. When I run the query they are displayed in descending order. When I open the subform based on that query however it is not. I can sort descending anyway by clicking the column on which I want to sort and do it that way, but that becomes bothersome and it doesn't need to be that way. Record source is ok: SELECT KlantNAW.ClientNumber, CaseInfoTable.Casenumber, CaseInfoTable.DateInitialCall, CaseInfoTable.DateCaseCreation, CaseInfoTable.CaseAccepted, CaseInfoTable.[1stAppointmentDate], CaseInfoTable.DateCaseClosed, CaseInfoTable.About1 FROM KlantNAW INNER JOIN CaseInfoTable ON KlantNAW.ClientNumber=CaseInfoTable.ClientNumber; Order by: Casenumber DESC I thought, well, lets create a new form based on the query to see if that changes anything, maybe I've changed something I shouldn't have. But nope, same result. How can make the form sort descending in datasheet mode?
View Replies !
View Related
Form With Subform Doesn't Show Totals Unless Keyed
I have an application that has two tables, linked on a common key. The main data entry form is for invoices, and has a sub-form for parts used. A similar report/sub-report is used for reporting. Everything is fine for records that are entered via the form. My problem is that when I import data from other sources ( consolidation process ) the calculations are not performed. So when those records are displayed no totals appear until I click on a control that drives the calculations. I don't want to store totals in the database but I need to have them reflected on the viewed form without operator intervention. Otherwise I'm open to incorrect decisions when the operator doesn't notice that an invoice doesn't reflect the cost of parts used.I'm looking for a "one-time" process that I can invoke after loading new data that would "touch" each record (ideally each "new" record but there's no impact to re-calculating existing ones) and drive the calculations so that the viewed form is correct.It doesn't need to be "easy" or automated since the end users won't do it, only myself as part of the data consolidation.Any ideas?Thanks
View Replies !
View Related
Subform Doesn't Complete After Selecting Master Fields
Hello everyyone. i have an access db that creates invoices. Simple. The problem is that i have an edit form where i have two lists where the user selects customer and date and then based on that selection the subform with the invoice details should be autocompleted. That is not happening. What am i doing wrong? I have linked the subform with the lists and i have added some refresh page code but still nothing. What should i do? My db is attached. Look at the edit invoice (editsalesfrm). The code is in english so don't worry of the greek labels.
View Replies !
View Related
Subform In A Form Doesn Show Controls When Link Child And Master Fields Derfined
Hello, I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded. Is there a setting on the parent form that also has to be changed, to make the new binding? Thanks, Aleksander
View Replies !
View Related
Scroll Bar
Hello - I have a form that has a bunch of Textboxes, ComboBoxes etc that allow the user to view various records, delete records, and create new records. In addition there is a LIST BOX below that they can scroll through to select a record which will then show up above in the Text Boxes for edit or what ever. My question/issue is that when I use the scroll bar in the LIST BOX below it does not move the record list untill I stop moving the scroll bar. OR If I move the scroll bar to the bottom from that point on it will move interactively. I want it to be live without having scroll the entire list first. For instance if you use the scroll bar on this page it will move as you move the scroll bar. How can I get that scroll bar in the LIST BOX which is in a Form to scroll live? Thanks in Advance.....
View Replies !
View Related
Scroll Bar Problems
Hi I have several memo fields on a form with vertical scroll bars. 3 of the 5 five memo fields have the same problem. If I hold down the bottom arrrow on the vertical scroll bar, it throws you out of the system (no error message or warning) The funny part is that the other 2 memo fields don't have that problem. I have compared field properties with the memo fields that don't have the proble, and even tried to recreate the fields on the form, still end up with the same issue. Has anyone ever had this problem ?? Thanks
View Replies !
View Related
How To Control The Scroll
Hi, I'm creating a DB for use on a Tablet PC. Users are finding it too hard to hit the scroll bar with the stylus when they need to scroll in a combobox. Any idea what code I need to add to two buttons (one up, one down) to control the scrolling of the combobox?? Or....is there a way to control the size of the scrollbar on the combobox? Regardless of the Font size, the scrollbar always stays the same. Thanks,
View Replies !
View Related
Scroll A List Box
I have a text box and a list box in a form. When the user types in something in the text-box i want the closest matching record (based on the first column) of the list box to be scrolled to. For eg. Text in Text box is Kan Then the list box should scroll to records starting with Kan. I am currently achieveing this using Sendkeys as i have rarely used list boxes but would prefer a cleaner method if possible.
View Replies !
View Related
Scroll Up Down Buttons
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. Can anyone suggest how I might code this? Thanks, Sup
View Replies !
View Related
Scroll Bar Colours
Is it possible to change the colour of scroll bars in subForms? Seems odd that you can easily customise all the colours, yet have to settle with a horrible looking grey scroll bar! Any help or a 'work-a-around' to the problem would be welcomed. Thanks
View Replies !
View Related
Scroll Bars
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!
View Replies !
View Related
How To Insert 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.
View Replies !
View Related
Scroll Bar Issues
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.
View Replies !
View Related
Right Scroll Problem
I have a list box, on a form, in which the horizontal scroll bar works perfectly. However, the right scroll bar is stuck. I can scroll with the mouse wheel, but not the scroll bar. How can this be fixed?
View Replies !
View Related
Mouse Scroll
Hi all, I have read much about disabling the mouse scroll bar - but my problem is that while I want the use of the scrollbar, it is very jumpy. Does anyone know how I can control the functionality of the scroll bar? Cheers Robert
View Replies !
View Related
Scroll Bars
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 Replies !
View Related
Record Scroll Loc
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!
View Replies !
View Related
Mouse Scroll Event......
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
View Replies !
View Related
Updating A Text Box To Scroll
OK, this one is doing my head in! 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? Many thanks in advance for any assistance!
View Replies !
View Related
Listbox HELP: Horizontal Scroll???
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 !
View Related
Combobox Scroll Problem
Hi Group, First post here. 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. Any idea what's happening? Thanks in advance, Randy
View Replies !
View Related
Disable Mouse Scroll
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? Thank you, TJ Bernard.
View Replies !
View Related
|
TRACKER
