Phil-
There shouldn't have been a problem. The only thing that comes to mind is perhaps you were failing to click Save after changing the form in Datasheet view. It'll silently revert if you don't save 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: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Phil Knowles
Sent: Wednesday, July 10, 2013 4:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Moving columns in datashett view
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@comcast.net>
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-6427
> 0730881E
> 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]
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar