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.
View RepliesI have an unbound form with a combobox which needs to be validated before the control is updated.In the Before Update event I check that the value is valid and need to reset the value back to the previous value if not valid and then change focus to another control.I thought that the following code would work but the selected value remains in the control and I cannot move the focus to another control.
Code:
Private Sub cboYears_BeforeUpdate(Cancel As Integer)
Dim dteNewDate As Date
dteNewDate = DateSerial(Val(Me.cboYears), Month(Me.txtCalendarHeading), 1)
[code]....
I have a listbox which is populated by a query from a table.
I also have a sub which allows users to quickly select multiple items from the listbox (based on a pre-defined criteria) rather than scrolling through and selecting them manually / individually
The sub works fine but when it is finished, the listbox is automatically scrolled to the bottom (or, rather, to the last selected item)
I would like to have the listbox scroll back to the very top once all of the appropriate items have been selected.
(I could loop through the listbox items in reverse - or 'bottom-up' - in the code but that would only have the desired effect if the topmost item was selected. I want it scrolled to the top regardless of whether the topmost item is selected or not).
I want to scroll through records in Access 2010 forms with the mouse scroll wheel.
View 10 Replies View RelatedI 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 have a set of membership records which have data input via a simple form. When looking for a particular record I use the standard Find menu item on the whole record set from the Form view, and move through the results using the Find Next button. Is there a way to move back through the records when I have got to the end of the results. eg. there may be numerous members with a surname Smith and I can move the the Smith records by using Find and Find Next but if I have moved past the record that I want is there a way of stepping back through the records?
Apologies if this is a really obvious question
I have a form that has four combo boxes on it that enable the user to select entrants in a golf tournament for tee off times and tee. (I have attached part of this database to this post) It all works fine but after selecting the first player in the first combo box and then selecting the second combo player I would like the player selected previously not to show up. Is this possible or do I have to rethink the way players are selected.
View 5 Replies View RelatedI have this estimate database for a construction company. In this database I calculate how much will a project cost. It's pretty much complete the only problem that I have is trying to figure out how to update the cost of a trade without affecting older records
Example let's say we have a painter that makes $15/hr in project A,B,C,D,E we decide to give him a raise so project F would have a new amount for painter. The problem with that is that it will affect record A-E
I don't want that my department wants to go back and view a history of records. Also take a look at my database it's my first time creating one ...
I am following mice and am trying to build a form that lets me add a new mouse to the database. I want to be able to either enter the the unique mouse id of the mother if I know it or be taken to another form that lets me identify the mother from the females already in my system. I know this is possible because I have seen examples of it where, in the find mother form, I give the strain name in a combo box which narrows down the selection of mice in the DOB combo box which in turn narrows down the unique mouse id which is the information I really want. I then want to carry that id back to the original form to enter it as the mother id.
In an ideal world the database would recognize this id being put in for a mother and note in the mothers record that she has had a litter. The litter id, which I am currently composing of motherid&fatherid&DOB, would go into the mothers record.
I've recently decided to move a database that had all its information on 1 table and divided it into multiple tables.
Attached is the relationship as well as the form.
The issue I have is that when I click the form, it only shows a blank record with none of previous records.
Data entry is already set to NO. I'm wondering if it's an issue with my relationships, tblStudioDescription is the parent table and the others are child tables so I linked them with the ID and set referential integrity.
I'm using the following code to clear selected records from a listbox after a button is pressed:
Code:
For i = 0 To lstProducts.ListCount - 1
lstProducts.Selected(i) = False
Next
The code works great except that it leaves the listbox scrolled all the way to the bottom. What is the best way to scroll back up to the top of the listbox without selecting another record?
Is there a way to make records automatically scroll from one record to another?
View 7 Replies View Relatedi 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 .
View 2 Replies View RelatedMy 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 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 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 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.
I have a subform that�s in datasheet view, is there a way to align the vertical scroll bar to the left side?
Using:
Win 7
Access 2010
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.
How do I make them normal?
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?
View 4 Replies View RelatedI 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?
Hi
I am tryin now (having cured my first troubles lol) to update multiple fields at once in my db from an asp web page. Code involved is
Code:DIM idid = request.querystring("id") strDSNPath = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};pwd=password; DBQ=" & Server.MapPath("....dbusers.mdb") strSQL_insert = "UPDATE * FROM CustRecords SET " & _"Cust_Name ='" & strName & "', " & _"Cust_LastName ='" & strLastName & "', " & _"Cust_Status ='" & strStatus & "', " & _"Cust_Orient ='" & strOrient & "', " & _"Cust_Address ='" & strAddress & "', " & _"Cust_City ='" & strCity & "', " & _"Cust_Country ='" & strCountry & "', " & _"Cust_PostCode ='" & strPostCode & "', " & _"email ='" & strEmail & "', " & _"Cust_PartName ='" & strPartName & "', " & _"Cust_PartOrient ='" & strPartOrient & "', " & _"Cust_Descrip ='" & strCustDescrip & "', " & _"Cust_Goal ='" & strGoal & "', " & _"Cust_Username ='" & strUsername & "', " & _"Cust_Password ='" & strPassword & "', " & _"Cust_Question ='" & strQuestion & "', " & _"Cust_Answer ='" & strAnswer & "', " & _"Cust_Type ='" & strLastName & "', " & _"Cust_IP ='" & strUserIP & "', " & _" WHERE id="&id Set Conn=Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Conn.Open strDSNPathConn.Execute strSQL_insert Conn.Close Set Conn = Nothing
Long winded I know but usually works and I am getting the following error
Code:Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. /sitesec/first_time1.asp, line 179
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.
I've got a form with a multiselect listbox (extended) that holds a very long list of items (~90,000):
1 | Apple
2 | Orange
3 | Banana
...............
35313| Corn cob
...............
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).
Hi
I was wondering if any one could help me.
I have a database at work with 5500 records, how ever the first 1000 have been lost. There remains records for each customer but the first 1000 records showing what they ordered have disapeared.
I have back ups of the database going back with the first 1000 records complete.
How would i take the 1000 records and add this to the current database where the information is missing? so it wouldnt mess up recent records?
could some one provide me with a step by step account. Would be much appreciated!
Many thanks