473,757 Members | 10,263 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Sequence of columns in a datasheet subform

5 New Member
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 7265
DonRayner
489 Recognized Expert Contributor
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 New Member
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 Recognized Expert Contributor
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,572 Recognized Expert Moderator MVP
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,572 Recognized Expert Moderator MVP
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 New Member
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 Recognized Expert Contributor
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
5359
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 entering customers and their respective orders, the first order entered is fine with the "tab" field orders correct. On the second and subsequent orders, when I go from the Order form to the subform "OrderDetail", the curser goes to the wrong field...
13
3613
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 grid control. I tried many grid controls (DBGrid, DataGrid, MSFlexGrid), the ADO Data Control and everything I can think of, with no success. Here are the contraints I faced: (1) Populating any of the grid controls manually is too slow for my...
3
13423
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 I am having is that when I change the query all the column widths remain the same. This doesn't look very good. I can't figure out a way to set the column widths. I have tried.. Subform.controls(Name of Column).columnwidth = IntColumnWidth
1
2323
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 position I wanted it. No records are returned by the form's query (it has a "Where ID = -1" clause and the GoToRecord proc on the main form changes the subform's recordsource). When I opened the form and started adding data to the subform,...
1
2053
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 the users activation of the scrollbar, so that the last record is visible. got any idea? thanx for your help, Helmut
5
8628
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, and the subform Detail section's Can Grow property is Yes. The report Detail section's Can Grow property is also Yes. When run, the select query's memo field has all the data. However, when I run the report, the subform does not show all the...
7
6261
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 subform is for parts used on the work order. On the main form I have a LaborTotal (from main form), PartsTotal (from subform) and TotalCost (which is Labor + Parts). All works fine as is. Now to the question: I have a button on my main form to browse...
2
4265
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 if the printout spans multiple pages. FYI, the records displayed in the sub-form are dynamically obtained based on some ad-hoc querying in the main form. Any report, etc. generated will have to have the same set of records.
1
5788
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
9298
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10072
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9737
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8737
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7286
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5172
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3829
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3399
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.