Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-15-2015, 12:36 AM   #1
skoolz
Newly Registered User
 
Join Date: Jun 2015
Posts: 32
Thanks: 7
Thanked 0 Times in 0 Posts
skoolz is on a distinguished road
Delete Extra Blank Columns at end of a table

Hi All, I have an Access table with data fields however at after the last field column, I have about 15 blank and unselectable or uneditable columns that I don't want there. Any ideas how I delete these?

Reason I want to delete them is because table is a subform on a main form and these extra columns are visible on it and they also cause a scroll bar to shown

Thanks in advance!

skoolz is offline   Reply With Quote
Old 07-15-2015, 01:50 AM   #2
spikepl
Eledittingent Beliped
 
spikepl's Avatar
 
Join Date: Nov 2010
Location: San Serriffe
Posts: 6,144
Thanks: 77
Thanked 980 Times in 958 Posts
spikepl is a jewel in the rough spikepl is a jewel in the rough spikepl is a jewel in the rough
Re: Delete Extra Blank Columns at end of a table

Your subform is wider than the subform control in which it is housed. So change the width of one or the other or both.
__________________

Don't tell us what did not happen.
Do you tell the mechanic about your car "it doesn't work" or vague stuff like:
I couldn't, No joy, To no avail, No go
, Incorrect, Wrong, Seems, Without success, It didn't let me, I/it failed.

Do tell us what did happen
:

I want this ... to happen, I attempted this ..., using this ... code and pressing these buttons, the system did this ... in response, and I got this ... error in this ... line.

Did it help? Pass it forward!

Joys of Access:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

spikepl is offline   Reply With Quote
Old 07-15-2015, 02:00 AM   #3
skoolz
Newly Registered User
 
Join Date: Jun 2015
Posts: 32
Thanks: 7
Thanked 0 Times in 0 Posts
skoolz is on a distinguished road
Re: Delete Extra Blank Columns at end of a table

Thanks for the response spikepl however that is not the case. The subform table is mirroring the parent table which has the extra columns... the issue is with the table and therefore need a way to remove/delete the extra blank columns....

If it helps, the tables where initially setup using Import from excel function so whether doing that has somehow caused these extra table columns, i don't know.

All advice welcome...

skoolz is offline   Reply With Quote
Old 07-15-2015, 07:26 AM   #4
spikepl
Eledittingent Beliped
 
spikepl's Avatar
 
Join Date: Nov 2010
Location: San Serriffe
Posts: 6,144
Thanks: 77
Thanked 980 Times in 958 Posts
spikepl is a jewel in the rough spikepl is a jewel in the rough spikepl is a jewel in the rough
Re: Delete Extra Blank Columns at end of a table

Show screenshot, and remember that pictures dispel many linguistic misunderstandings.

Either there are normal columns in the table, in which case remove them in the table design, or it is misalignment between subform and subform control sizes.
__________________

Don't tell us what did not happen.
Do you tell the mechanic about your car "it doesn't work" or vague stuff like:
I couldn't, No joy, To no avail, No go
, Incorrect, Wrong, Seems, Without success, It didn't let me, I/it failed.

Do tell us what did happen
:

I want this ... to happen, I attempted this ..., using this ... code and pressing these buttons, the system did this ... in response, and I got this ... error in this ... line.

Did it help? Pass it forward!

Joys of Access:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

spikepl is offline   Reply With Quote
Old 07-16-2015, 12:08 AM   #5
skoolz
Newly Registered User
 
Join Date: Jun 2015
Posts: 32
Thanks: 7
Thanked 0 Times in 0 Posts
skoolz is on a distinguished road
Re: Delete Extra Blank Columns at end of a table

Table image



Table subform view

skoolz is offline   Reply With Quote
Reply

Tags
blank columns , delete , extra

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank extra page when sub report is blank Sharkfin Reports 5 01-06-2012 06:32 AM
Filling in Blank Columns in a Table proballin Modules & VBA 1 02-05-2009 01:13 PM
Delete blank records from linked table arifmasum Macros 5 04-27-2008 09:04 PM
How to count table non blank cells in columns? Jakboi Reports 4 12-01-2006 11:30 AM
#Delete in all my columns when I open a linked table debbie_315 General 1 03-17-2003 08:47 PM




All times are GMT -8. The time now is 05:48 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World