> Just 2 thoughts - the column I was trying to move was the rightmost column and it is a tickbox - not sure if one or both of these could have caused the problem.
No, that wasn't the problem. It sounds to me like the database was a bit corrupted. When was the last time you compacted it?
Bill
--- In MS_Access_Professionals@yahoogroups.com, Phil Knowles <pdk444444@...> wrote:
>
> Bill and John
> Â
> Strangely, having resorted to moving the fields in table design to sort it out, the problem now seems to have sorted itself out !!!! I can now move the columns about in datasheet view (of the form) and they stay where I move them to.
> Â
> Just 2 thoughts - the column I was trying to move was the rightmost column and it is a tickbox - not sure if one or both of these could have caused the problem.
> Â
> Anyway - thanks very much for your help
> Â
> Phil
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, 9 July 2013, 21:53
> Subject: [MS_AccessPros] Re: Moving columns in datashett view
>
> Â
> 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 mailto:MS_Access_Professionals%40yahoogroups.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: mailto:MS_Access_Professionals%40yahoogroups.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]
> >
>
>
>
>
> [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 (13) |
Tidak ada komentar:
Posting Komentar