[AccessD] Open Form As Datasheet

[Paul Hartland]

No worries, glad I could be of help, this group has helped me a lot over
the years.

On 6 October 2016 at 14:09, Kostas Konstantinidis <kost36 at otenet.gr> wrote:

>     DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
>
> That make the difference
>
> Thank's Paul
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Paul Hartland via AccessD
> Sent: Thursday, October 6, 2016 3:56 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Cc: Paul Hartland <paul.hartland at googlemail.com>
> Subject: Re: [AccessD] Open Form As Datasheet
>
> hmmm, what happens if you remove the stLinkCriteria and just try the line
> DoCmd.OpenForm stDocName, acFormDS
>
> On 6 October 2016 at 13:48, Kostas Konstantinidis <kost36 at otenet.gr>
> wrote:
>
> > I tried also acnormal and  acdatash with no luck
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> > Of Paul Hartland via AccessD
> > Sent: Thursday, October 6, 2016 2:53 PM
> > To: Access Developers discussion and problem solving
> > <accessd at databaseadvisors.com>
> > Cc: Paul Hartland <paul.hartland at googlemail.com>
> > Subject: Re: [AccessD] Open Form As Datasheet
> >
> > one of the comma's can't remember which off-hand should be a datamode
> > and I think you can specify how you want the form to open there, I had
> > problems in the past where the default mode wouldn't open correctly
> > when using docmd.openform unless I also specified it in the docmd line
> >
> > On 6 October 2016 at 12:27, Kostas Konstantinidis <kost36 at otenet.gr>
> > wrote:
> >
> > > Hi all,
> > > It works but although the "OffersData" is by default open as
> > > datasheet it opens as single form
> > >
> > >     Dim stDocName As String
> > >     Dim stLinkCriteria As String
> > >     DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
> > acMenuVer70
> > >     stDocName = "OffersData"
> > >     stLinkCriteria = "[CustomerId]=" & Me![Id]
> > >
> > >     DoCmd.OpenForm stDocName, , , stLinkCriteria
> > >
> > >
> > > Could you please help?
> > >
> > > Thank's
> > > /kostas
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> >
> > --
> > Paul Hartland
> > paul.hartland at googlemail.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com