[AccessD] Open Form As Datasheet

[Kostas Konstantinidis]

    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