473,322 Members | 1,523 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

rant about focus - has this happened to you

I just spent two hours trying to work out why my procedure wouldn't
allow me to set the focus to a control in a subform. The control is in
a tab control in the subform

My code looked like this

forms!mainform.form!subform.setfocus
forms!mainform.form!subform!control.setfocus

Simple enough I think you would agree.

Nothing I tried would work and now the boss is starting to look at me
funny.
Last resort, I copied the control to the clipboard deleted it and
exited the database. I re-opened the database and ran the procedure,
which it didn't like because now the control doesn't exist. I then
went to design mode and pasted the control back into the form saved it
and ran the procedure again.

Hey presto it now works!

Has anyone seen a problem like this?
Nov 12 '05 #1
3 1944
Yes, controls can get corrupted in Access. It happens relatively
frequently. It seems to happen more when renaming or copying controls
(especially between form sections), and it seems to be worse with name
autocorrect turned on, though it can sure still happen with name
autocorrect turned off.

On 13 Oct 2003 23:47:22 -0700, we****@hotmail.com (Michael) wrote:
I just spent two hours trying to work out why my procedure wouldn't
allow me to set the focus to a control in a subform. The control is in
a tab control in the subform

My code looked like this

forms!mainform.form!subform.setfocus
forms!mainform.form!subform!control.setfocus

Simple enough I think you would agree.

Nothing I tried would work and now the boss is starting to look at me
funny.
Last resort, I copied the control to the clipboard deleted it and
exited the database. I re-opened the database and ran the procedure,
which it didn't like because now the control doesn't exist. I then
went to design mode and pasted the control back into the form saved it
and ran the procedure again.

Hey presto it now works!

Has anyone seen a problem like this?


Nov 12 '05 #2
no****@nospam.nospam (Steve Jorgensen) wrote in
<da********************************@4ax.com>:
Yes, controls can get corrupted in Access. It happens relatively
frequently. It seems to happen more when renaming or copying
controls (especially between form sections), and it seems to be
worse with name autocorrect turned on, though it can sure still
happen with name autocorrect turned off.


Does anyone who knows anything about Access development actually
run with Name AutoCorrect on, except accidentally (as happened to
me this week after importing into a new MDB)?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #3
On Tue, 14 Oct 2003 20:01:49 GMT, dX********@bway.net.invalid (David W.
Fenton) wrote:
no****@nospam.nospam (Steve Jorgensen) wrote in
<da********************************@4ax.com>:
Yes, controls can get corrupted in Access. It happens relatively
frequently. It seems to happen more when renaming or copying
controls (especially between form sections), and it seems to be
worse with name autocorrect turned on, though it can sure still
happen with name autocorrect turned off.


Does anyone who knows anything about Access development actually
run with Name AutoCorrect on, except accidentally (as happened to
me this week after importing into a new MDB)?


Certainly not I. Its about the surest way to mangle your database, and
that's not even talking about the mangling it can do when it's working
properly!

I recommend never using the name autocorrect feature, though I also leave
it on by accident for a while sometimes.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

303
by: mike420 | last post by:
In the context of LATEX, some Pythonista asked what the big successes of Lisp were. I think there were at least three *big* successes. a. orbitz.com web site uses Lisp for algorithms, etc. b....
3
by: Terry Murray | last post by:
Hi All: I would like to know how to set the focus on a radio button (if it is possible) I tried button.focus() but with no luck The reason that I need to do this is to validate a form. If...
13
by: theintrepidfox | last post by:
Dear Group I wondered whether you can help me with this. I do have a page that contains a button and an IFrame. The IFrame contains a dummy page that is set to redirect to a word document when...
3
by: Simon Wigzell | last post by:
When I validate a form on submission I use the javascript focus function to scroll the page to the location of the form error e.g. document...focus(); If you happened to have the page scrolled...
0
by: Edward | last post by:
westmj@hotmail.com (Michael) wrote in message news:<aff51963.0310132247.1a6f5efd@posting.google.com>... > I just spent two hours trying to work out why my procedure wouldn't > allow me to set the...
5
by: Bryan Masephol | last post by:
Hi All I got a datagrid and a ComboBox on a form. I populate the combobox with years for all the data avaiable. When the user chooses a year the datagrid is populated with the specific years...
3
by: Steve Yerkes | last post by:
There seems to be way too much confusion over how to set focus on the a field using a field validator. I looked all over the web and found people trying to do this, but not getting anywhere. There...
8
by: Jamie | last post by:
Hello Newsgroup: This is my little rant about security and why we have home directories. You may choose to ignore it or disagree with it, that is your perogative and I won't care, but... this...
3
by: ELohman | last post by:
Is there a way to know which control had focus when the post in the browser happened ? Thank you in advance.
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.