is there a limit on the columns that return data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The sql that I run is

SELECT [WCC Dealers].[COMPANY NAME], WCC_Technicians1.LastName,
WCC_Technicians1.FirstName, WCC_Technicians1.StudentID,
WCC_Technicians1.CircuitsMeters, WCC_Technicians1.ThreedayElectricBrake,
WCC_Technicians1.ThreedayEnginePerformanceTransmission,
WCC_Technicians1.FivedayIntensiveTraining, WCC_Technicians1.IntensivePWSat,
WCC_Technicians1.FourdayRDP, WCC_Technicians1.RDPSat,
WCC_Technicians1.WOW04WinterServiceTrgInternet,
WCC_Technicians1.WOWSpring04ServiceTrgInternet,
WCC_Technicians1.VibrationCorrection,
WCC_Technicians1.FourdayAdvancedElectricalDiagnosis,
WCC_Technicians1.RearAxleDriveLine,
WCC_Technicians1.FourdayAdvancedDriveabilityDiagnosis,
WCC_Technicians1.WOWWinter05, WCC_Technicians1.WOWServiceAdvisor05,
WCC_Technicians1.WOWPP, WCC_Technicians1.WCCHVAC,
WCC_Technicians1.ThreedayDieselfamilar, WCC_Technicians1.FiveDayWSeries, [WCC
Dealers].REGION
FROM WCC_Technicians1 INNER JOIN [WCC Dealers] ON WCC_Technicians1.[DLR
CODE]=[WCC Dealers].[DLR CODE]
ORDER BY [WCC Dealers].[COMPANY NAME];

then in a form at each text box ControlSource is =Techlist.column(a number
goes here) all works fine until I exceed (20) then no data is displayed for
all references above 20.
Example: WCC_Technicians1.FiveDayWSeries is =Techlist.column(21) and wont
return the data.
 
My fault
The user clicks a name and the following runs
SELECT WCC_Technicians1.StudentID, WCC_Technicians1.LastName,
WCC_Technicians1.FirstName, WCC_Technicians1.CircuitsMeters,
WCC_Technicians1.ThreedayElectricBrake,
WCC_Technicians1.ThreedayEnginePerformanceTransmission,
WCC_Technicians1.FivedayIntensiveTraining, WCC_Technicians1.IntensivePWSat,
WCC_Technicians1.FourdayRDP, WCC_Technicians1.RDPSat,
WCC_Technicians1.WOW04WinterServiceTrgInternet,
WCC_Technicians1.WOWSpring04ServiceTrgInternet,
WCC_Technicians1.VibrationCorrection,
WCC_Technicians1.FourdayAdvancedElectricalDiagnosis,
WCC_Technicians1.RearAxleDriveLine,
WCC_Technicians1.FourdayAdvancedDriveabilityDiagnosis,
WCC_Technicians1.WOWWinter05, WCC_Technicians1.WOWServiceAdvisor05,
WCC_Technicians1.WOWPP, WCC_Technicians1.WCCHVAC,
WCC_Technicians1.ThreedayDieselfamilar, WCC_Technicians1.FiveDayWSeries,
WCC_Technicians1.[DLR CODE]
FROM WCC_Technicians1
WHERE (((WCC_Technicians1.[DLR CODE])=[Form].[Dealer_CODE]));

Then I have 21 text fields on the form with there control sources set to
retrive the column number 0-22

Jeff Boyce said:
David

I don't see where you're getting "Techlist.Column(#)" from.

--
Regards

Jeff Boyce
<Office/Access MVP>

David Michigan said:
The sql that I run is

SELECT [WCC Dealers].[COMPANY NAME], WCC_Technicians1.LastName,
WCC_Technicians1.FirstName, WCC_Technicians1.StudentID,
WCC_Technicians1.CircuitsMeters, WCC_Technicians1.ThreedayElectricBrake,
WCC_Technicians1.ThreedayEnginePerformanceTransmission,
WCC_Technicians1.FivedayIntensiveTraining, WCC_Technicians1.IntensivePWSat,
WCC_Technicians1.FourdayRDP, WCC_Technicians1.RDPSat,
WCC_Technicians1.WOW04WinterServiceTrgInternet,
WCC_Technicians1.WOWSpring04ServiceTrgInternet,
WCC_Technicians1.VibrationCorrection,
WCC_Technicians1.FourdayAdvancedElectricalDiagnosis,
WCC_Technicians1.RearAxleDriveLine,
WCC_Technicians1.FourdayAdvancedDriveabilityDiagnosis,
WCC_Technicians1.WOWWinter05, WCC_Technicians1.WOWServiceAdvisor05,
WCC_Technicians1.WOWPP, WCC_Technicians1.WCCHVAC,
WCC_Technicians1.ThreedayDieselfamilar, WCC_Technicians1.FiveDayWSeries, [WCC
Dealers].REGION
FROM WCC_Technicians1 INNER JOIN [WCC Dealers] ON WCC_Technicians1.[DLR
CODE]=[WCC Dealers].[DLR CODE]
ORDER BY [WCC Dealers].[COMPANY NAME];

then in a form at each text box ControlSource is =Techlist.column(a number
goes here) all works fine until I exceed (20) then no data is displayed for
all references above 20.
Example: WCC_Technicians1.FiveDayWSeries is =Techlist.column(21) and wont
return the data.
Click to expand...
Click to expand...
 
David

I still don't see where the columns are coming from, unless you mean that
the query is used to populate a combo box, and you are trying to load/fill
textboxes based on the columns in the combo box. If so, you need to
re-check the syntax for the .Column() method, which uses zero-based
counting. That is, when you reference .Column(0), you're telling Access to
look at the 1st column, .Column(1) looks at the second, etc.

This means that if your combo box source has 22 columns, you'll be using
..Column(0) through .Column(21).

--
Regards

Jeff Boyce
<Office/Access MVP>

David Michigan said:
My fault
The user clicks a name and the following runs
SELECT WCC_Technicians1.StudentID, WCC_Technicians1.LastName,
WCC_Technicians1.FirstName, WCC_Technicians1.CircuitsMeters,
WCC_Technicians1.ThreedayElectricBrake,
WCC_Technicians1.ThreedayEnginePerformanceTransmission,
WCC_Technicians1.FivedayIntensiveTraining, WCC_Technicians1.IntensivePWSat,
WCC_Technicians1.FourdayRDP, WCC_Technicians1.RDPSat,
WCC_Technicians1.WOW04WinterServiceTrgInternet,
WCC_Technicians1.WOWSpring04ServiceTrgInternet,
WCC_Technicians1.VibrationCorrection,
WCC_Technicians1.FourdayAdvancedElectricalDiagnosis,
WCC_Technicians1.RearAxleDriveLine,
WCC_Technicians1.FourdayAdvancedDriveabilityDiagnosis,
WCC_Technicians1.WOWWinter05, WCC_Technicians1.WOWServiceAdvisor05,
WCC_Technicians1.WOWPP, WCC_Technicians1.WCCHVAC,
WCC_Technicians1.ThreedayDieselfamilar, WCC_Technicians1.FiveDayWSeries,
WCC_Technicians1.[DLR CODE]
FROM WCC_Technicians1
WHERE (((WCC_Technicians1.[DLR CODE])=[Form].[Dealer_CODE]));

Then I have 21 text fields on the form with there control sources set to
retrive the column number 0-22

Jeff Boyce said:
David

I don't see where you're getting "Techlist.Column(#)" from.

--
Regards

Jeff Boyce
<Office/Access MVP>

The sql that I run is

SELECT [WCC Dealers].[COMPANY NAME], WCC_Technicians1.LastName,
WCC_Technicians1.FirstName, WCC_Technicians1.StudentID,
WCC_Technicians1.CircuitsMeters, WCC_Technicians1.ThreedayElectricBrake,
WCC_Technicians1.ThreedayEnginePerformanceTransmission,
WCC_Technicians1.FivedayIntensiveTraining, WCC_Technicians1.IntensivePWSat,
WCC_Technicians1.FourdayRDP, WCC_Technicians1.RDPSat,
WCC_Technicians1.WOW04WinterServiceTrgInternet,
WCC_Technicians1.WOWSpring04ServiceTrgInternet,
WCC_Technicians1.VibrationCorrection,
WCC_Technicians1.FourdayAdvancedElectricalDiagnosis,
WCC_Technicians1.RearAxleDriveLine,
WCC_Technicians1.FourdayAdvancedDriveabilityDiagnosis,
WCC_Technicians1.WOWWinter05, WCC_Technicians1.WOWServiceAdvisor05,
WCC_Technicians1.WOWPP, WCC_Technicians1.WCCHVAC,
WCC_Technicians1.ThreedayDieselfamilar,
Click to expand...
WCC_Technicians1.FiveDayWSeries,
[WCC
Dealers].REGION
FROM WCC_Technicians1 INNER JOIN [WCC Dealers] ON WCC_Technicians1.[DLR
CODE]=[WCC Dealers].[DLR CODE]
ORDER BY [WCC Dealers].[COMPANY NAME];

then in a form at each text box ControlSource is =Techlist.column(a number
goes here) all works fine until I exceed (20) then no data is
Click to expand...
displayed
for
all references above 20.
Example: WCC_Technicians1.FiveDayWSeries is =Techlist.column(21) and wont
return the data.
Click to expand...
Click to expand...
Click to expand...
 
DooooH I have been way over thinking this. I guess my answer is Yes there is
a column count limit if you are the one who set it.
After looking into every property I inadvertantly set the column count to
20 of the textbox that has the row source
of the SQL posted earlier. I do however appreciate all of your effort in
helping. I hope not much of your valuable time was wasted.

Jeff Boyce said:
David

I still don't see where the columns are coming from, unless you mean that
the query is used to populate a combo box, and you are trying to load/fill
textboxes based on the columns in the combo box. If so, you need to
re-check the syntax for the .Column() method, which uses zero-based
counting. That is, when you reference .Column(0), you're telling Access to
look at the 1st column, .Column(1) looks at the second, etc.

This means that if your combo box source has 22 columns, you'll be using
..Column(0) through .Column(21).

--
Regards

Jeff Boyce
<Office/Access MVP>

David Michigan said:
My fault
The user clicks a name and the following runs
SELECT WCC_Technicians1.StudentID, WCC_Technicians1.LastName,
WCC_Technicians1.FirstName, WCC_Technicians1.CircuitsMeters,
WCC_Technicians1.ThreedayElectricBrake,
WCC_Technicians1.ThreedayEnginePerformanceTransmission,
WCC_Technicians1.FivedayIntensiveTraining, WCC_Technicians1.IntensivePWSat,
WCC_Technicians1.FourdayRDP, WCC_Technicians1.RDPSat,
WCC_Technicians1.WOW04WinterServiceTrgInternet,
WCC_Technicians1.WOWSpring04ServiceTrgInternet,
WCC_Technicians1.VibrationCorrection,
WCC_Technicians1.FourdayAdvancedElectricalDiagnosis,
WCC_Technicians1.RearAxleDriveLine,
WCC_Technicians1.FourdayAdvancedDriveabilityDiagnosis,
WCC_Technicians1.WOWWinter05, WCC_Technicians1.WOWServiceAdvisor05,
WCC_Technicians1.WOWPP, WCC_Technicians1.WCCHVAC,
WCC_Technicians1.ThreedayDieselfamilar, WCC_Technicians1.FiveDayWSeries,
WCC_Technicians1.[DLR CODE]
FROM WCC_Technicians1
WHERE (((WCC_Technicians1.[DLR CODE])=[Form].[Dealer_CODE]));

Then I have 21 text fields on the form with there control sources set to
retrive the column number 0-22

Jeff Boyce said:
David

I don't see where you're getting "Techlist.Column(#)" from.

--
Regards

Jeff Boyce
<Office/Access MVP>

The sql that I run is

SELECT [WCC Dealers].[COMPANY NAME], WCC_Technicians1.LastName,
WCC_Technicians1.FirstName, WCC_Technicians1.StudentID,
WCC_Technicians1.CircuitsMeters, WCC_Technicians1.ThreedayElectricBrake,
WCC_Technicians1.ThreedayEnginePerformanceTransmission,
WCC_Technicians1.FivedayIntensiveTraining,
WCC_Technicians1.IntensivePWSat,
WCC_Technicians1.FourdayRDP, WCC_Technicians1.RDPSat,
WCC_Technicians1.WOW04WinterServiceTrgInternet,
WCC_Technicians1.WOWSpring04ServiceTrgInternet,
WCC_Technicians1.VibrationCorrection,
WCC_Technicians1.FourdayAdvancedElectricalDiagnosis,
WCC_Technicians1.RearAxleDriveLine,
WCC_Technicians1.FourdayAdvancedDriveabilityDiagnosis,
WCC_Technicians1.WOWWinter05, WCC_Technicians1.WOWServiceAdvisor05,
WCC_Technicians1.WOWPP, WCC_Technicians1.WCCHVAC,
WCC_Technicians1.ThreedayDieselfamilar, WCC_Technicians1.FiveDayWSeries,
[WCC
Dealers].REGION
FROM WCC_Technicians1 INNER JOIN [WCC Dealers] ON WCC_Technicians1.[DLR
CODE]=[WCC Dealers].[DLR CODE]
ORDER BY [WCC Dealers].[COMPANY NAME];

then in a form at each text box ControlSource is =Techlist.column(a number
goes here) all works fine until I exceed (20) then no data is displayed
for
all references above 20.
Example: WCC_Technicians1.FiveDayWSeries is =Techlist.column(21) and wont
return the data.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top