Runtime Error 2164

I have never used a barcode reader before, so I don't know about the focus on the barcode field. Are you aComputer / IT professional?Join Tek-Tips Forums! Do you want to fix Runtime error 2164 in a cheap and fast way? http://www.thescripts.com/forum/thread643047.html May 26 '07 #2 reply Expert 2.5K+ P: 3,072 nico5038 Hmm, why not add a << (First) and >> (Last) button that can be enabled always and ease the scrolling weblink

V_R posted Dec 6, 2016 at 9:57 AM WCG Stats Tuesday 06 December 2016 WCG Stats posted Dec 6, 2016 at 8:00 AM Loading... There SHOULD be a way to disable the button once you click it. If I am at the last record, there should not be an enabled button that allows me to go to the last record or the first record. This cannot be done if the buttons are on the form bound to a recordset.

I am clueless at this point as to what to do Reply With Quote 12-07-03,00:56 #9 bluejamul View Profile View Forum Posts Registered User Join Date Dec 2003 Posts 16 Re: If I set the focus to a control on the main form, fAAA, I still cannot set both command buttons on the subform with .Enabled = False. Posts 326 Give something else the focus, the Enabled=False the button Private Sub cmdDeleteuser_LostFocus() ***SomeOtherControl.SetFocus*** cmdDeleteuser.Enabled = False End Sub All code ADO/ADOX unless otherwise specified. OldBirdman Jun 7 '07 #9 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account.

Are all of these controls on the same form? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? All I did was change the tabbing and I don't have a clue what the error message means! http://www.access-programmers.co.uk/forums/showthread.php?t=150546 It's quick & easy.

how to requery a subform after a record added in another subform Using a button to populate another form's auto# field. For example, to represent the employee number lngEmployeeID as a barcode on my report, I have control source of the text box control, txtEmployeeID, set equal to Code: txtEmployeeID.ControlSource = "*" Here ...... Besides such a datasheet subform I offer a set of buttons with the basic actions like [Add], [Update], [Delete], [Print], etc.

Eventually, you computer will be free from system error messages and sluggish performance. http://www.utteraccess.com/forum/Error-2164-disable-co-t496916.html Click on the button disables it. Expand|Select|Wrap|Line Numbers ... Expand|Select|Wrap|Line Numbers IfboolStartThen'Iamatfirstrecord cmdNextRec.SetFocus cmdPrevRec.Enabled=False EndIf IfBoolEndThen'Iamatlastrecord cmdPrevRec.SetFocus cmdNextRec.Enabled=False EndIf If I apply a filter that only has one record, so boolStart = True and boolEnd = True.

Any ideas? have a peek at these guys Shaun, Aug 18, 2004, in forum: Microsoft Access Form Coding Replies: 0 Views: 1,489 Shaun Aug 18, 2004 error '2164' can't disable a control while it has the focus Guest, Oct Similarly with cmdPrevRec. Teaching is not filling a bucket but lighting a fire.

Forms!fAAA.SetFocus Forms!fAAA!txtTitleName.SetFocus Forms!fAAA!subformNavButtons.Form!cmdNextRec.Enabled=False The above lines of code should move the focus to the main form fAAA and set the focus to a textbox named "txtTitleName". for those of you following along at home, the moral of the story is that both a main form and sub form can each carry their own focused control - setting Advertisements Latest Threads Hand-made CPU on a HUGE scale Ian posted Dec 7, 2016 at 12:04 PM What would you like to see more reviews of? check over here What is Runtime error 2164?

Apparently true only if there are no controls on the form when loaded. it exists, is enabled, is visible) izy currently using SS 2008R2 Reply With Quote 12-06-03,11:14 #8 shassouneh View Profile View Forum Posts Registered User Join Date Nov 2003 Posts 104 Nope. Don't know why I didn't think of this.

Are you just trying to get Access to set the focus somewhere by doing it so many times?

Example of working code: Private Sub btn1_Click() Me.Frame2.SetFocus Me.btn1.Enabled = False End Sub Private Sub btn2_Click() Me.Frame2.SetFocus Me.btn2.Enabled = False End Sub The form contains 3 controls: 2 buttons (btn1, btn2) Access Help for SetFocus Method implies that the form can have the focus if there is no control able to have the focus. The time now is 07:38 AM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored http://objectifiers.com/runtime-error/runtime-200.html In my opinion, it is the most important step for you to fix Runtime error 2164 and avoid other runtime errors effectively.

As for the idea of the boolena variable, I CAN do it that way, but that is both unclean and not optimum. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums PC based Database Applications Microsoft Access Can't Disable Control While it has focus Me.ControlBox.SetFocus ? From what i have read of the barcode scanner manual, you can practically forget the fact that it is a barcode scanner at all.

Moving focus should work. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not