Forms :: Losing Focus After Hitting Enter In Memofield
Jul 5, 2013I have a form with a memofield (rich text). After hitting enter, a new line is added in, but the focus changes to the top of the memofield (of the same record).
View Replies
ADVERTISEMENT
Forms :: Cursor Position To Be Same After Hitting Enter?
Aug 4, 2014I have a text box which i use as a "search box"
I type in characters and my data sheet at the bottom will display all matches
What i want to happen is for the cursor to stay on the same text (search) box after hitting enter.
Forms :: Cancel When Hitting Form X Button
May 9, 2013Here's the setup:
- I have a parent form bound to a parent table with a subform bound to a subtable.
- The parent does not allow data entry and has its sole field filled by a listbox.
- The subForm is a data entry form which contains two buttons in addition to it's fields: btnCancel and btnOK
-btnOK checks to ensure that all required fields are filled out and then saves and closes the parent form. - ALL OK
- btnCancel closes undoes any changes andcloses the form - ALL OK
The issue I have is with the user utilizing the Parent form x button to close the form. For uniformity I would like to not remove this button but would like it to prompt the user whether to discard the changes if the form is dirty.
I attempted the following on both the parent and sub forms to no avail. I can't even get the event to trigger:
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim rspSaveorDiscard As VbMsgBoxResult
rspSaveorDiscard = vbYes
If Me.Dirty Then
intSaveorDiscard = MsgBox("Are you sure you want to close without saving?", vbYesNo, "Discard Changes")
[Code] .....
I was under the impression that when closing a form using the x button the before_update event was triggered first, then the close event, then the unload event. How should I handle this?
Forms :: Hitting Next Record Button Creates A New Job Instead Of Stopping?
Dec 28, 2014I created a basic database in Access 2013 to keep up with jobs, and each job has a job number assigned to make each job unique (Primary Key).
At first I had it where I had to enter the new job number manually for each job. I have updated it and now it takes the last job number and adds 1 to it and then fills in the Job Number field automatically.
The problem is when I clicked the Last Record button, it will go to the last existing record, but if I click the Next Record button while on the last record, it will create a new record. It creates a new job instead of stopping at the last record. I assume it has to do with the auto numbering I have setup for the job numbers, since it didn't do this before, but I am not sure why. I ONLY want to be able to click the New Record (Blank) button to create a new job, NOT by also clicking the Next Record button.
Is there a way to force only the New Record button to add a new record? I still need the Previous and Next Record buttons to maneuver through the existing records. I just don't want to create new jobs accidentally by clicking the Next Record button when I'm at the end of the existing records. It should just stop, or say last record or something similar.
Hitting Ctrl To Multi Select From ListBox
Jun 25, 2014I am having a form that has a listbox, which brings up a lot of records, and the user may choose multiple records, but when user wants to scroll down the page to multi select, he cant do it with the ctrl keyboard button, when he press ctrl the page jumps back up, is there any workaround for that?
View 14 Replies View RelatedGenerate Information From One Form To Another By Hitting Submit Button?
Dec 14, 2011I have been creating an inventory control system for my small business. I am looking for a code that will generate to another form. So for example if I take out 4 aprons from the first row by hitting the '-1' button 4 times leaving 46 in total how do I generate the information from one form to another by hitting that submit button.
My other form shows Product ID, Date Taken, Product Description, Employee who has taken it, Amount Taken, and Total left in inventory. I need the correct information to show accordingly in the Inventory control form.
I am attaching screen shots ....
Forms :: Set Focus To Sub Form?
Sep 14, 2014On a main form I have 2 sub forms. On the main form I have a command button that asks how many guests in a booking and depending on the response populates the subform with Guest Names. However it will only do this if I click on the subform and then click the command button.
I want to include some code that sits behind the command button on the main form that will duplicate the otherwise manual selecting of the sub form. And I am thinking this is a SetFocus procedure.
I have tried this code;
[Forms]![Booking].[SubForm1].SetFocus
where Booking is the name of the form. I do not know whether the Subform is #1
Forms :: How To Tell If A List Box Has Focus
Aug 1, 2015i have a button that allows you to "edit" the show that is selected. You can double click the show name from the list box, and it opens that show in viewing mode, but you cant edit it. You can click the edit show button in the form that you view the show with, but I want to be able to edit that show from the main form with the list box. But, the problem im having, is if someone clicks the "Edit show" button without have a show selected, they get a error.
If lstShows has focus Then
DoCmd.OpenForm "frmEventsEdit", , , "EventID = " & Me.lstShows
Else
'do nothing, since having no code here, it does nothing
End If
End Sub
That is what I want, but I cant get access to open that show up if its selected.I need to be able to tell if it has focus on it, and to open that selected show up.
Forms :: Set Focus To A Subform
Mar 20, 2014If i open a form with a sub form on can i open it so that the focus go directly to a control on a sub form.I have tried to do it with a macro on the on open event to go to control but it comes up that the control don't exists on the sub form.i am using access 2010.
View 6 Replies View RelatedForms :: Cannot Set Focus To The Control
Sep 1, 2013This code stopped working without explanation after the longest time. I can't seem to fix it.
Code:
Private Sub Send_Letter_AfterUpdate()
Call Set_CallDateUserId
End Sub
Private Sub Set_CallDateUserId()
Me.txtCallDate.SetFocus
[Code] .....
Forms :: How To Keep Focus On One Record
Jun 22, 2015I have a customer provide his or her SSN. If the SSN matches a record in a table the form opens specifically on that record (no problem). If the SSN doesn't match a record, the form adds a new record (again, no problem).
The issue I'm having is with the new record. The customer is able to scroll through other records (page up, page down), which is a no-no. I need the form to be locked on the new record. I've posted my code below.
Private Sub Command543_Click()
On Error GoTo Err_Command543_Click
Dim strCriteria As String
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
[Code] .....
Moving Focus/control On Sub Forms
Feb 16, 2006I have a parent form called "frm_job_enter"
and two sub-forms called "frm_fabricator" & "frm_engineer"
On the sub form "frm_fabricator" I have a combo box and after updating this combo box (called fabricator) I would like the cursor to jump into a field called “ApllicationsEng” on the other sub form "frm_engineer"
Any help would be appreciated thank you.
Forms :: Set Focus On Subform Control?
Mar 7, 2014I have a form with a subform on it. The subform has subforms. I need to set the focus on a control on one of the subforms. Here is what I am using.
START OF CODE
Forms!frmMain!frmMainSub.Form.frmContactLog.SetFoc us
Forms!frmMain!frmMainSub.Form.frmContactLog.Contac tMethod.SetFocus
END OF CODE
I use Code 1 to get to the third level. Code 1 works.
Code 1
Forms!frmMain!frmMainSub.Form.frmContactLog.SetFoc us
When I add the second line, Code 2, it doesn't work. I get the message "Run-time error 438: Object doesn't support this property or method."
Code 2
Forms!frmMain!frmMainSub.Form.frmContactLog.Contac tMethod.SetFocus
Forms :: How To Set Focus On Specific Text Box
Nov 11, 2013I have a continuous form with a combobox and a text box. In the after_update event of the combobox I want to setfocus on the text box - of the specific record that I'm on. I tried using Me.CurrentRecord but that returns me to a completely different record than the one I was on. How can I setfocus to the text box of the record I am on?
View 12 Replies View RelatedForms :: On Got Focus Move To New Record
Jun 23, 2013I have a subform that I use to scan in products using a barcode reader, when the item scans it moves to the quantity (Qty) field where I have this code:
Code:
Private Sub Qty_GotFocus()
Qty.Value = 1
DoCmd.GoToRecord , , acNewRec
txtOrderNo.SetFocus
End Sub
I am simply trying to set the Qty value to 1 and move onto the next record ready to scan another product in.
Forms :: Set Focus And Requery Data
Mar 17, 2013I have a Dynamic Search form, which I use to search for client, on the double click it takes me to the client, at which point I have the Forms Visible set to False.
When I click on a button to open that Form, the Visible turns back to True, however it shows my last search results, how do I clear it so that when I call it back up it is ready to search again, and my focus is set to the SearchFor box.
Forms :: Navigation In Textbox - Set Focus?
Dec 8, 2014In a form, I go to a textbox with setfocus. The whole text is selected then. But how can I place the cursor after the existing text, so that I can begin writing immediately?
View 3 Replies View RelatedForms :: Fields Jumping When Have Focus
Sep 1, 2013When the client clicks in a text-Box or Combo-box in a sub-form, the field seems to jump to the side. in this image it jumps to the left, but jumps to the right to..., it is quite irritating, especially attempting to open a combo-box list, and see the button jumping aside.We renewed the file many times, so I don't think it is corrupted, but go know..the file can be accessed via network or terminal server, the pic is from terminal, but happens via network too.
View 1 Replies View RelatedForms :: Set Focus To Last Line Of Subform
Jan 21, 2015I have a single main form with a datasheet subform. When I scroll through the records shon in the main form, each has a different set of child records shown in the subform.
I want the focus to be on the last record of the subform each time.
On the main form, I have a button and this code
Code:
Private Sub cmdLast_Click()
Me.frmRevisionsSub.Requery
Me.frmRevisionsSub.SetFocus
Me.frmRevisionsSub.Form.txtRevTag.SetFocus
DoCmd.GoToRecord , , acLast
End Sub
which works perfectly, when I click the button.
If I call this code from main form's OnCurrent, focus remains on the first line of the subform instead of going to the the last. I have an inkling that it has to do with when the requery of the subform takes place, when I scroll through the records on the main form.
General :: Setting Focus On Forms
Jun 26, 2015I am having trouble setting the focus on my forms... I have a parent form with two labels that are coded like this.
Private Sub Advisory Messages_Click()
Me![ Advisory Messages].Visible = _
Not Me![Advisory Messages].Visible
End Sub
[code]...
I have the visible property set to no on the subform allowing the user to toggle the visibility when the label is clicked. The problem though is when I click inside the subform to use the scroll bar to view records, it transfers the focus to the subform making it almost impossible to close by clicking the label again because the label is on the parent form. I found the "me.parent.setfocus" command and a few other set focus commands but I don't know what I should be applying the command to in order to make it work.
Forms :: Subform - Set Focus To Other Record
Jan 2, 2014I have a form with a subform which is sized to show several records at the same time. If Record A has the focus, and I click anywhere in Record B, then Record B gets the focus, as expected. ... Except if I click on an Image field in Record B, when the focus stays on Record A.
How I can force it to set the focus to the other record ? I don't think this can be done with Events handlers, as they need to have the focus set first.
Forms :: Can't Disable A Control While It Has Focus
Jul 18, 2015 I have a form that allows me to update entries in a table. When I select the line I need to update and hit the "edit" button I get a run time error '2164' You cant disable a control while it has the focus. when I debug the line in the code that is highlighted yellow is
Me.cmdEdit.Enabled = False.
I developed the database in access 2013, and now I am forced to run the database on a computer that has Access 2003. I have changed the database base to access 2000-2003.
Forms :: Can't Hide Control That Has Focus
Jan 18, 2015I have a toggle control on a form which depending on selection uses a loop and instr to make 'not visible' a set of controls on a subform.(forms! Mainform !subform.form)I get error 2165 but if I test immediatley before the make not visible process it returns the toggle frame as being the active control.
View 3 Replies View RelatedForms :: Tabbing And Setting Focus On A Button?
Oct 21, 2013I have a form with a tab control on it. The input for respective fields are placed inside the tab control, and I have the "Confirm" button placed outside, on the main form. Now I wanted to be able to navigate my focus from a control from inside to tab control, out to the Confirm button on the form, to allow smooth flowing data entry.
However, it seems like Access separates the tab indexes for the controls in the tab control and outside on the main form, so setting tab index does not work. I tried using the code ON LOST FOCUS and SET FOCUS;
Private Sub txtPurchaseNote_LostFocus()
Forms![frm Imported]![cmdConfirmPurchase].SetFocus
End Sub
But then a dialog box appears:
Run-time error '2110'
Microsoft access can't move focus to the control cmdConfirmPurchase
(cmdConfirmPurchase is a button control)
Forms :: Set Focus - Sending Cursor To First Field
Dec 31, 2014I have a form (Home_Interview_Form) with several subforms (AirFresheners, Pesticides1 etc), and I would like the cursor to move from the last field in one subform to the first field in the next subform on keydown. I have written the following code, but instead of sending the cursor to the first field (PestSpray) it is going to the next field (PestSprayCom) in the subform for some reason. I am using Access 2013.
Private Sub Fresh2React_KeyDown(KeyCode As Integer, Shift As Integer)
Forms!Home_Interview_Form!Pesticides1.SetFocus
Forms!Home_Interview_Form!Pesticides1.Form!PestSpr ay.SetFocus
End Sub
Forms :: Set Focus To Text Box Once Button Is Clicked
May 28, 2014What do I need to put into a macro attached to a command button to set the focus to a text box once the button is clicked?
View 1 Replies View Related