PMJI, but you're right, Phil. The form should remember your last "view". I remember seeing the datasheet view save itself before. I had to resort to coding the column positions and widths in the form's Load event to keep it from getting messed up.
Try saving the form before closing.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Phil Knowles <pdk444444@...> wrote:
>
> Further thought - do you mean moving the columns in datasheet view of the table rather than in datasheet view of the form?
> Â
> I normally move columns in datasheet view of the form and as i say it normally works fine
>
>
> ________________________________
> From: John Viescas <JohnV@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, 9 July 2013, 19:49
> Subject: RE: [MS_AccessPros] Re: Moving columns in datashett view
>
>
> Â
>
> Phil-
>
> You shouldn't have had to move the columns in table design. Switching to Datasheet view, moving the columns, then *saving* the table before closing should have done it.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: mailto:MS_Access_Professionals%40yahoogroups.com [mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of Phil Knowles
> Sent: Tuesday, July 09, 2013 8:39 PM
> To: mailto:MS_Access_Professionals%40yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Moving columns in datashett view
>
> Hi Bill
>
> Aha that's interesting!
>
> No the form is not based on a query - it is based on a table.
>
> However, I went to table design and moved the field to the position I want it in. I then displayed the form in datasheet view and the columns hadn't moved but this time when i moved it and saved it - it stayed where I want it.
>
> Not sure I quite understand why but it seems to have solved my problem (please feel free to explain)
>
> Thanks for nudging me in the right direction
>
> Phil
>
>
> ________________________________
> From: Bill Mosca <mailto:wrmosca%40comcast.net>
> To: mailto:MS_Access_Professionals%40yahoogroups.com
> Sent: Tuesday, 9 July 2013, 19:24
> Subject: [MS_AccessPros] Re: Moving columns in datashett view
>
>
>
>
> Phil
>
> You're right. It should open to the last layout unless something is changing it. Is there a query as the RecordSource? If so, arrange the fields in the order you want them within the query.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals http://www.thatlldoit.com/ Microsoft Office Access MVP https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com/
>
> --- In mailto:MS_Access_Professionals%40yahoogroups.com, "pdk444444" <pdk444444@> wrote:
> >
> > Hi
> >
> > I am trying to move a column in datasheet view but when I save it and then reopen the form again (it defaults to datasheet view), it reverts to its original position.
> >
> > I have many forms that I use in this way and I can move cols and save them and they stay in the new position.
> >
> > What could it be about this particular form?
> >
> > NB no subforms are involved and the form is opened via a macro in
> > order to default to datasheet view
> >
> > I would appreciate any help
> >
> > Phil
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar