Hey, just a quick question that I hope someone out there maybe able to help with :-) In form view I don't want the mousewheel to scroll through my records when I use it, Can someone tell me what is the easiest way of turning this option off? I tried editing the [event procedure] in the form properties but it bought up a page in VB which I have no idea how to use. Sorry if that is confusing, basically i only want mousewheel to scroll down the form page that I'm on and NOT iterate through all my records. Any help would be much apprecitated :-) Thanks
I'm using access 2000, and have built a long form. My users would like to be able to use their mouse wheel to scroll down the length of the form rather than having to click the scrollbar. is there a way to do this? (I'm sorry if I missed this being answered in another thread, I looked but did not find.)
Hope somebody can help with this. I checked the archives but not luck. My continuous form allows entry of 12 records. On the thirteenth record the new row scrolls to the top and all the previous rows disappear. Every new record after that scrolls up out of view and a new blank row is at the top. I can scroll up to see the previous records but they do not scroll one at a time as data entry is performed. Data Entry is set to No, Allow Additions is set to Yes.
I have a table with about 290 record. When I'm in the "Form View" and click the "Next Record" arrow it scrolls by order of Employee instead of the primary key "Record Number".
After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.
After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)
I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.
Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?
(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)
I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.
Why the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.
Maybe someone can help me with this, probably very simple(?), question?
I have 4 tables and around 440 records but can only view up to 417 in the form I have designed. I have been adding new records via form and it has been added to my main table, but when i try to view it in form view - the record is not available to view. What do I need to do to correct this problem?
I have checked that there are no filters, data entry is set to No, Auto deletions, additions and edits are set to yes.
Also to mention it seems that the problem has arisen since I set up some new queries, there is a one to one relationship between the tables!
I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it to be in datasheet view because i want to show multiple records at the same time.
If u kno how i could resolve this please offer ur help
Hi, I am in the process of creating a new database - I am a bit new to this. I have a main form, which also contains two subforms. The record source of the main part of the form is 11 tables, and then each of the subforms is based on one table each (so there are 13 tables altogether).
Everything seems to be linked up ok, and when I add new information to the form (and the subforms), the information gets saved to the tables as it should be. However, I want to be able to view past records in the form view, so that users can regularly update past records using form view. I can't do this. Each time I open the form view, the thing at the botton left says 'record one of one.' THen if I put the curser in (for eg) the box called 'client name' and click on the search button, I get a message saying:
"you can't find or replace now, the fields are not searchable due to: - the fields are controls; - the fields have no data; - there are no fields to search."
well I don't really know what that means. There is definately data in there somewhere, because I can view it in the table view, but I'd like to be able to view and update old records, and search, in the form view.
Does anyone know why with some combo boxes, when I grab the scroll bar and haul it to the bottom of the records, after I let go of the mouse button, the scroll jumps back up to around the middle of the combo box? Then, I have to keep pulling it to the bottom several times before it finally gets to the last record. Thanks
This is not an other post about disabling the mouse wheel in access application but an other issue that is starting to really bug me... Some of my forms have a continuous subform, I can normally use the scroll wheel to go up and down the different record in the subform BUT i have noticed that if there is just a small amount of record in the subform (let's say three for example) when I scroll down the different records, they disapear in the detail header frame of the subform and only the last record is visible which I guess I don't mind to much. What annoys me is that if I scroll back up nothing happens the 2 records stay hidden behind the frame and the only way to put it back to normal is to use the scrolling bar on the right of the subform!??? I was wondering if anybody had a similar problem and if there is any solution to it?
In Access (2003) I was able to (by default?) scroll through records with the mouse scroll wheel. That no longer works. How can I have the form scroll backwords and forwards with the mouse wheel?
I've been reading threads and it sounds like MS "fixed" a feature that I was relying on heavily to move through records. I can't find a way to enable it again......
how can i stop wheel mouse scrolling on certain forms? it is ok on some forms but others where specific data is viewed can be scrolled to a blank space.
This is kind of ridiculous, but I'd like to get to the bottom of it.
I have a form with a tab control on it, which holds all my controls on several pages. The tab control takes up almost the entire form; there's only a small area of the underlying form visible around it. For some strange reason, every time I open the form or switch from design mode to form mode, the form scrolls down a bit, on its own, so that my tabs are hidden and I have to manually scroll back up to see them. Apart from being very annoying, this may also hide the fact from some unsuspecting future user, that there are any tabs at all.
Can somebody explain this, and, hopefully, suggest a solution?
This doesn't appear to be covered off in any "Scroll" type threads.
I have a continous form with several 100 records.
What I want to happen is when a record is selected it will automatically scroll to the top of the display (this is because my user is computer illiterate and gets confused where they were up to easily).
I can achieve this in Visual Basic but its not pretty.
If the user is scrolling down I can do this in the "On Current" Event by remembering where the previous "Current Record" was and using Command "GotoRecord" to go to the Last Record (so the screen instantly scrolls all the way to the bottom) and the using Command "GotoRecord" Last Record Number + 1 (so the screen scrolls back bringing the desired record to the top).
This works but looks messy as screen flashes a lot.
Similarly if the user is scrolling up (just use go to First Record first instead).
The best way would be if there was a Visual Basic equivalent to what you get when you Right Click on the Vertical Scroll bar where the option "Scroll Down" or "Scroll Up" is available. It would be simple if I could call that!
Any suggestions (apart from getting another user?). Any ideas would be appreciated.
I'm trying to prevent use of the scroll wheel in my subforms but allow for it in the main form. I've looked at the "mousetrap" posted by gHudson. I'm not trying to prevent changes as I am trying to prevent a blank or new record from displaying if one already exists. Any Ideas on how to do this?
it is the correct width so it doesn't need a horizontal scroll bar. However the length of the vertical can be unlimited so it therefore needs a vertical scroll bar. However when i try to scroll in the sub-form the records disappear. if i change the setting to neither scroll bars then i do not get the problem. the next time i open the form the records have re-appeared. what is the reason for this and how can i stop it?
Hi, been lurking on here for a while and can find most things im looking for but for some reason cant find any info on auto scrolling of data?
Im chasing something that will scroll a sub form which is displaying data from a query. slowly scrolling down all the data. It wont have anything entered or edited simply displaying the data. It is to be displayed on a monitor/tv and preferably have either a pause button or stop when focus command or something should they want it to pause. I was thinking it might be something like a move next loop or similar but Im terrible at code, can read alot but cant write it if that makes sence.
i will have a refresh/requery command when it gets to the end i think and or on a 1min cycle? to make sure it displays the most appropriate data.
Anyone point me in the right direction?
(sorry its long, just trying to be a good newbie poster :D )
I have a form with a group of controls on the left side and a control on the right side.
Is it possible to somehow lock down the controls on the left side so when scrolling through the form, only the control on the right side scrolls and the left side stays in position so it is always visible?
We have a system which calls a form from a hyperlink. The called form opens in Dialog mode (a box with a border which "Overlays" the screen). It has been working well until now when a new user has started using a computer with a smaller screen which can't display all of the dialog box (they don't have access to critical fields).
For now I have changed the mode of opening to normal which provides scroll bars but this only opens to the right of the navigation menu. Is there a way to set up scrolling within the dialog box.
I have a form (frmCommoditySupplierSpend)and a subform (frmCommoditySupplierSpendSubForm1ByVend). I have a control button in the main form that will scroll down the page of the main form to a point I desire by using:
The problem that I am having is in my subform I have a button as well and when a user clicks the button in the subform I want the main form to scroll down to the same point. I thought the same exact code should work, but it ends up scrolling down the subform instead of the mainform, even though the main form is being stated. how to scroll down my main form when using a contol in subform.
I have a Combo Box on a form who's selection determines the records shown in a Sub-Form. However if there is more than 1 record in the Sub-Form and I try to scroll or navigate to the nest record I get an error message Saying that my action will create a duplicate record and it will not me allow me to view the next record.
I merely want the Sub-Form to be read only and I have set all the editing functions etc. to No.where I am going wrong?
Combo Box is fed from one table and sub form from another. The tables have a one to many relationship.
I have got the following code off another thread which works great!
I was just wondering if there was any way I can link the scrolling messages to a table so rather than having to go into the code to alter the messages the user can change them through a form or in the table.
Option Compare Database Option Explicit
Public txtScrollStatus As String ' Needed for Status Bar
Private Sub Form_Load() DoCmd.Maximize ' Text for Caption of Form Me.Caption = " CAPTION MESSAGE " & Space(25)
' Text for Label on Form Me.lblScrollingLabel.Caption = " SCROLLING LABEL MESSAGE " & Space(100)
' Text for Status Bar txtScrollStatus = " STATUS BAR MESSAGE " & Space(25)
End Sub
Private Sub Form_Timer()
' Produce the Scrolling Text in Caption on the Form Me.Caption = Mid(Me.Caption, 2, _ (Len(Me.Caption) - 1)) & Left(Me.Caption, 1)
' Produce the Scrolling Text in Label on the Form Me.lblScrollingLabel.Caption = Mid(Me.lblScrollingLabel.Caption, 2, _ (Len(Me.lblScrollingLabel.Caption) - 1)) & Left(Me.lblScrollingLabel.Caption, 1)
' Produce the Scrolling Text in Status Bar of Access SysCmd acSysCmdSetStatus, txtScrollStatus txtScrollStatus = Mid(txtScrollStatus, 2, (Len(txtScrollStatus) - 1)) & Left(txtScrollStatus, 1)
