Phil-
Yes, fix the Datasheet of the table.
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: Tuesday, July 09, 2013 9:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Moving columns in datashett view
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@msn.com>
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]
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar