Datasheet View and Runtime

[Jay]

I would like to be able to switch between Form and Datasheet view in
Runtime. I can add a command button to switch to Datasheet view but then
I cannot get back (without closing the form) since there no
Header/Footer display in Runtime and the right click does not work. Any
suggestions?

Thanks,
J

 

[Rick Brandt]

I would like to be able to switch between Form and Datasheet view in
Runtime. I can add a command button to switch to Datasheet view but then
I cannot get back (without closing the form) since there no
Header/Footer display in Runtime and the right click does not work. Any
suggestions?

Right-Click works fine in the runtime. You just have to create your own
shortcut menu.

 

[Barry A&P]

Jay
You could use a Form with a Subform and on the Mainform add buttons to
switch the datasheet however you want it..

If this helps Please Check Yes

Barry

 

[Jay]

Thanks Barry & Rick

-----Original Message-----
From: Barry A&P [mailto:[email protected]]
Posted At: Wednesday, February 24, 2010 4:15 PM
Posted To: microsoft.public.access.formscoding
Conversation: Datasheet View and Runtime
Subject: RE: Datasheet View and Runtime


Jay
You could use a Form with a Subform and on the Mainform add buttons to
switch the datasheet however you want it..

If this helps Please Check Yes

Barry

 

[Jay]

One more question.

I took the subform approach and it looks good. I have a delete button in
the footer of the main form (I don't want a footer in the subform). How
do I code it so that it deletes the active record in the subform.

-----Original Message-----
From: Jay [mailto:[email protected]]
Posted At: Wednesday, February 24, 2010 5:00 PM
Posted To: microsoft.public.access.formscoding
Conversation: Datasheet View and Runtime
Subject: Re: Datasheet View and Runtime


Thanks Barry & Rick

-----Original Message-----
From: Barry A&P [mailto:[email protected]]
Posted At: Wednesday, February 24, 2010 4:15 PM Posted To:
microsoft.public.access.formscoding
Conversation: Datasheet View and Runtime
Subject: RE: Datasheet View and Runtime


Jay
You could use a Form with a Subform and on the Mainform add buttons to
switch the datasheet however you want it..

If this helps Please Check Yes

Barry

 

[Barry A&P]

Jay
Im not sure about your second question a delete button on the main form
might not be good if the subform is in datasheet maybe add a unbound control
with "Delete" As its text and a Sql in the controls double click event then
it will be there in form view or datasheet view.
but you will have better luck with one question per post, try re-posting
your new question..

Also if your previous question was answered please update it as so..

Barry

One more question.

I took the subform approach and it looks good. I have a delete button in
the footer of the main form (I don't want a footer in the subform). How
do I code it so that it deletes the active record in the subform.

-----Original Message-----
From: Jay [mailto:[email protected]]
Posted At: Wednesday, February 24, 2010 5:00 PM
Posted To: microsoft.public.access.formscoding
Conversation: Datasheet View and Runtime
Subject: Re: Datasheet View and Runtime


Thanks Barry & Rick

-----Original Message-----
From: Barry A&P [mailto:[email protected]]
Posted At: Wednesday, February 24, 2010 4:15 PM Posted To:
microsoft.public.access.formscoding
Conversation: Datasheet View and Runtime
Subject: RE: Datasheet View and Runtime


Jay
You could use a Form with a Subform and on the Mainform add buttons to
switch the datasheet however you want it..

If this helps Please Check Yes

Barry

I would like to be able to switch between Form and Datasheet view in
Runtime. I can add a command button to switch to Datasheet view but
then I cannot get back (without closing the form) since there no
Header/Footer display in Runtime and the right click does not work.
Any suggestions?

Thanks,
J

.