Solved

setfocus in MS Access (VBA)

Posted on 2004-10-05
9
597 Views
Last Modified: 2012-06-27
I am finding it quite difficult to do a simple task in VBA within Access. Here is the code I am trying:

Me.ChangeFlag.Visible = False
Me.histdate.setfocus

The error I get on the first line is "you can't hide a control that has the focus". So, when I switch the lines around and try this:
Me.histdate.setfocus
Me.ChangeFlag.Visible = False

I get "Access can't move the focus to the control HistDate". HistDate is a text box. Any ideas?

Glenn
0
Comment
Question by:tkecowboy
9 Comments
 
LVL 6

Expert Comment

by:snavebelac
ID: 12231170
Is Histdate disabled or locked ?  That would explain why the focus cannot move to it.

In your event to hide your first control, if you can move the focus to something else first - an enabled and unloacked control, it should work.

HTH

C
0
 

Author Comment

by:tkecowboy
ID: 12231290
well, I changed the code to look like this:

me.histdate.enabled = true
me.histdate.locked = false
Me.histdate.setfocus
Me.ChangeFlag.Visible = False

and I still get the error. In fact, I can't set the focus to any control on the form, which leads me to believe that there is sometihng in particular I must do within Access before setting focus on a control.
0
 
LVL 6

Expert Comment

by:snavebelac
ID: 12231458
Are the controls part of a locked or disabled tab control or options group ?

The code you have should work just fine.  Is HistDate definitely a textbox ?

C
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:tkecowboy
ID: 12231571
The controls look like they are on a standard form. I inherited this app, but I'm pretty sure there's nothing wierd going on. histdate is definitely a textbox.
0
 
LVL 6

Accepted Solution

by:
snavebelac earned 43 total points
ID: 12231713
I have created a simple form here and use dthe code an it works just fine.  I did manage to generate the same error by trying to move the focus to an option button.

Can you check the properties of the texbox (if you have not done so already) to make sure there is nothing strange going on there.

This seems a little odd to me...

C
0
 
LVL 41

Assisted Solution

by:shanesuebsahakarn
shanesuebsahakarn earned 41 total points
ID: 12232639
Are you absolutely sure that histdate is the name of the *textbox* and not the field within the textbox? Check the textbox's Name property in the properties window.
0
 

Assisted Solution

by:Mr_Ahmad
Mr_Ahmad earned 41 total points
ID: 12238049

Hi

Make sure the initial properties on the controls are set to visible = true, locked = false, the code will work afte that, else it will give you that error message.

Reg
Zaf
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now