473,322 Members | 1,307 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Sequence of columns in a datasheet subform

5
Access 2003 has suddenly reordered the sequence of columns in a datasheet subform.

Specifically the last column has stayed in place but the others are back to front. There are about 50 columns in total.

Any ideas as to what is causing this? And what is a permanent solution?

I had a assumed that the sequence was taken from the sequence of the columns in the query in the form's record source. But as this hasn't changed I don't know if there is another place where the column sequence is recorded.

I can drag the columns back into the correct sequence but this has not prevented another involuntary reordering of the columns.
Sep 26 '08 #1
7 7225
DonRayner
489 Expert 256MB
When datasheets start acting up on me I normally select all of the columns then on the format menu I select Freeze columns. They normally behave after that.
Sep 27 '08 #2
MayoM
5
Thanks for the suggestion.

I have just frozen all the columns.

But now the horizontal scroll bar has disappeared and all the columns over to the right are unreachable.
Sep 27 '08 #3
DonRayner
489 Expert 256MB
Thanks for the suggestion.

I have just frozen all the columns.

But now the horizontal scroll bar has disappeared and all the columns over to the right are unreachable.
Check the formating for the subform itself (not the formating for the subform control on the main form) and make sure that the scroll bars are set for both.
Sep 27 '08 #4
NeoPa
32,556 Expert Mod 16PB
When you run the query simply as a query, are the columns in the same order as the form or do they match the order listed in the query?
Sep 29 '08 #5
NeoPa
32,556 Expert Mod 16PB
In a query display, it is possible to move columns around by dragging them with a mouse. This doesn't change the order of the columns in the query definition (nor the underlying SQL itself).

Your problem sounds similar to this so it may be worth checking if it behaves that way.
Sep 29 '08 #6
MayoM
5
Thanks for the replies

a) Concerning the horizontal scroll bar: The subform has both specified. It just seems that if I freeze columns which extend beyond the width of the screen the horizontal scroll bar disappears (or maybe moves over to an invisible position over to the right)

b) Concerning the underlying query: The fields are in the sequence which I want displayed (and in which were the fields were displayed originally).

So the it seems that freezing columns is not really a solution and the only way of correcting the sequence is to drag the columns when in Form View.
Sep 29 '08 #7
DonRayner
489 Expert 256MB
Thanks for the replies

a) Concerning the horizontal scroll bar: The subform has both specified. It just seems that if I freeze columns which extend beyond the width of the screen the horizontal scroll bar disappears (or maybe moves over to an invisible position over to the right)

b) Concerning the underlying query: The fields are in the sequence which I want displayed (and in which were the fields were displayed originally).

So the it seems that freezing columns is not really a solution and the only way of correcting the sequence is to drag the columns when in Form View.
Sorry the freeze didn't work, I never use datasheet view when I can't display all of the data in the space available so had never run accross the problem.

I did take a closer look at it and the order that the colums are defaulted to seams to be the same order as the tab index for form view. I tried making changes to these in one of my test databases and it changed the order in the datasheet view.
Sep 29 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: ivan | last post by:
I have a form (CustomerImfo) that has a subform within it (order). Within that subform is another subform (OrderDetail). That subform (OrderDetail) is displayed in Datasheet view. When I am...
13
by: Aladdin | last post by:
I have an MS Access form on which I have a listbox listing tables in that database. I want to be able to click on any of those tables and view its contents on the same form using subforms or any...
3
by: A Clark | last post by:
I have a subform that displays a datasheet. There are a couple of different queries that can be displayed in the datasheet. The queries are available in a combo box on the main form. The problem...
1
by: Richard Sherratt | last post by:
I added a new field to a table in the tables database. In the code database, I added a new column for the new field to a datasheet subform. I opened it in datasheet view and moved the column to the...
1
by: Helmut Blass | last post by:
hi folks, I have embedded a datasheet as a subform and I want that every time the datasheet is updated, the focus be set on the last record and be visible for the user. that is like simulating...
5
by: kotowskil | last post by:
A report has a subform. The subform is set to datasheet view and its RecordSource is a select query that includes a memo field from the source table. The memo field's Can Grow property is Yes,...
7
by: Ken Mylar | last post by:
First a quick background on the form: I have a form that is normally viewed in Single form mode. It has a subform on it that is in datasheet view. The main form is for work orders and the...
2
by: ghat12 | last post by:
Hi, I am trying to print a subform containing approx 50 columns in datasheet view. The printout cannot fit more than 8-10 columns. Does anyone know of any way to print all columns; i don't care...
1
by: Simon | last post by:
Dear reader, In a datasheet form you have the possibility to hide or unhide columns. But in case the datasheet form is a sub-form this functionality is not longer available.
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.