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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|