A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Split Form Data sheet focus



 
 
Thread Tools Display Modes
  #1  
Old January 7th, 2008, 09:23 PM posted to microsoft.public.access.forms
Vass[_2_]
external usenet poster
 
Posts: 8
Default Split Form Data sheet focus

I would like when I open a split form for it to open and the focus to be on a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.
  #2  
Old January 7th, 2008, 11:58 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Split Form Data sheet focus

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you tried using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus to be on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.



  #3  
Old January 8th, 2008, 07:12 AM posted to microsoft.public.access.forms
Vass[_2_]
external usenet poster
 
Posts: 8
Default Split Form Data sheet focus

Dear Jeff, I created the form under the 'create' tab. From the 'forms'
section I selected 'split form'. I used the .setfocus.command but it directs
it in the same field on the form view section and not on the datasheet form
section (the upper section of the form) where I want my cursor to be on
opening the form. Thanks Vassilis

"Jeff Boyce" wrote:

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you tried using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus to be on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.




  #4  
Old January 8th, 2008, 07:54 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Split Form Data sheet focus

Where did you use the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff, I created the form under the 'create' tab. From the 'forms'
section I selected 'split form'. I used the .setfocus.command but it
directs
it in the same field on the form view section and not on the datasheet
form
section (the upper section of the form) where I want my cursor to be on
opening the form. Thanks Vassilis

"Jeff Boyce" wrote:

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you tried
using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus to be
on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.






  #5  
Old January 8th, 2008, 08:54 PM posted to microsoft.public.access.forms
Vass[_2_]
external usenet poster
 
Posts: 8
Default Split Form Data sheet focus

At the Form Property Sheet on Load parameter.
Vassilis

"Jeff Boyce" wrote:

Where did you use the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff, I created the form under the 'create' tab. From the 'forms'
section I selected 'split form'. I used the .setfocus.command but it
directs
it in the same field on the form view section and not on the datasheet
form
section (the upper section of the form) where I want my cursor to be on
opening the form. Thanks Vassilis

"Jeff Boyce" wrote:

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you tried
using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus to be
on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.






  #6  
Old January 9th, 2008, 12:48 AM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Split Form Data sheet focus

Vass

I'm still having trouble visualizing what you're doing.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
At the Form Property Sheet on Load parameter.
Vassilis

"Jeff Boyce" wrote:

Where did you use the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff, I created the form under the 'create' tab. From the 'forms'
section I selected 'split form'. I used the .setfocus.command but it
directs
it in the same field on the form view section and not on the datasheet
form
section (the upper section of the form) where I want my cursor to be on
opening the form. Thanks Vassilis

"Jeff Boyce" wrote:

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you tried
using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus to
be
on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.








  #7  
Old January 9th, 2008, 05:12 AM posted to microsoft.public.access.forms
Vass[_2_]
external usenet poster
 
Posts: 8
Default Split Form Data sheet focus

Dear Jeff

Thanks for keep trying to assist me. I use Access 2007

regards
Vassilis


"Jeff Boyce" wrote:

Vass

I'm still having trouble visualizing what you're doing.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
At the Form Property Sheet on Load parameter.
Vassilis

"Jeff Boyce" wrote:

Where did you use the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff, I created the form under the 'create' tab. From the 'forms'
section I selected 'split form'. I used the .setfocus.command but it
directs
it in the same field on the form view section and not on the datasheet
form
section (the upper section of the form) where I want my cursor to be on
opening the form. Thanks Vassilis

"Jeff Boyce" wrote:

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you tried
using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus to
be
on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.









  #8  
Old January 9th, 2008, 05:14 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Split Form Data sheet focus

Vassilis

As this point, I'm going to suggest that you try re-posting your question,
including all the information that's come out as we've worked on this. I
have less experience with the new features in Access 2007 than those in the
earlier versions, so you'd probably have better luck (and more eyes on your
question) if you post mentioning A'07 to start with.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff

Thanks for keep trying to assist me. I use Access 2007

regards
Vassilis


"Jeff Boyce" wrote:

Vass

I'm still having trouble visualizing what you're doing.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
At the Form Property Sheet on Load parameter.
Vassilis

"Jeff Boyce" wrote:

Where did you use the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff, I created the form under the 'create' tab. From the
'forms'
section I selected 'split form'. I used the .setfocus.command but
it
directs
it in the same field on the form view section and not on the
datasheet
form
section (the upper section of the form) where I want my cursor to be
on
opening the form. Thanks Vassilis

"Jeff Boyce" wrote:

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you
tried
using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus
to
be
on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.











  #9  
Old January 9th, 2008, 07:56 PM posted to microsoft.public.access.forms
Vass[_2_]
external usenet poster
 
Posts: 8
Default Split Form Data sheet focus

Thanks Jeff

I will follow your suggestion.

Vassilis.


"Jeff Boyce" wrote:

Vassilis

As this point, I'm going to suggest that you try re-posting your question,
including all the information that's come out as we've worked on this. I
have less experience with the new features in Access 2007 than those in the
earlier versions, so you'd probably have better luck (and more eyes on your
question) if you post mentioning A'07 to start with.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff

Thanks for keep trying to assist me. I use Access 2007

regards
Vassilis


"Jeff Boyce" wrote:

Vass

I'm still having trouble visualizing what you're doing.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
At the Form Property Sheet on Load parameter.
Vassilis

"Jeff Boyce" wrote:

Where did you use the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Vass" wrote in message
...
Dear Jeff, I created the form under the 'create' tab. From the
'forms'
section I selected 'split form'. I used the .setfocus.command but
it
directs
it in the same field on the form view section and not on the
datasheet
form
section (the upper section of the form) where I want my cursor to be
on
opening the form. Thanks Vassilis

"Jeff Boyce" wrote:

Vass

We aren't there. We can't see what you're looking at.

We may not share the same definitions.

What do you mean by "a split form"? Who created it? Have you
tried
using
the .SetFocus command?

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Vass" wrote in message
...
I would like when I open a split form for it to open and the focus
to
be
on
a
field on the datasheet view part and not on the form view part.
Any ideas?

Thanks in advance for any help.












 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.