How to have users preview temp table on a form when a 144 columns?

  • Thread starter Thread starter Webtechie
  • Start date Start date
W

Webtechie

Hello,

My boss wants to review the data before my code processes the data. So I
tried to put a listbox on a form and then bind it "myTempTable". MyTempTable
has 144 columns. The listbox will only show 20 columns. I got an error
message when trying to bring over the columns.

How do I show the the whole Table without acutally letting them into the
database and the raw table?

They are reviewing the table and if they find an error, they may want to
edit the value and replace a value if one of the clerks miskeyed something.

Thanks.
 
Use a form with Allow Edits, Allow Additions and Allow Deletions all set to
False.
 
Thanks Douglas.

However, I am using VBA to show the user a form with a listbox on it. I am
not able to add the 144 columns to the listbox. That really was my question.
How do I present a form to my users with a listbox of a table with 144
columns.

Any ideas? Do you means bind a form to the table and adding each field the
form?

Thanks.

Tony
 
To simulate the listbox, you can create a form that's bound to the table
with each field on the form, and use that form as a subform on your existing
form, replacing the list box with the subform.
 
Douglas,

Great. I'm getting closer. I did as you suggested.

1) I created a form
2) I changed the record source to the table
3) I went to the field list
4) I highlighted the 144 fields.
5) I drug these fields onto the form.
6) It stopped adding fields at field 21

How do I add all 144 fields onto the form?

Thanks Douglas.
 
Hmm. I've never had that problem. Of course, 144 fields in a single table is
extremely unusual in a relational data model, so I've never approached that
number, but I just did a test with 25 fields and had no issue.

Once the 20 fields have been added, can you add anymore fields as a seventh
(or eighth or ninth...) step?

What version of Access are you using?
 
Douglas,

I am importing a flat file from linux. It has 144 for each activity or run.
I am bring it into a temporary table. Then I will allow the user to view
it.

Then I will put it into normalized tables once the data is approved.

Now I am thinking I need to add the fields via VBA, becuase each activity
can produce it's own flat file. In other words, sometimes the flat file will
have 144 columns. Sometimes the flat file will have 130.

I've tried to add the fields vertically and it stops after a certain number.
I've tried to add the fields horizontally and it stops after a certain
number. I can't seem to make the page wider to allow for the additional
fields, so there must be a max width on forms. Same with a max length.

I am using MS Access 2007.
 
Just got out of a meeting. Management has changed their mind.

I need to show 50 fields (which will always be the same) on a form to review.

At this point, I can show a little over 20, but after that the fields
overlap. I don't seem to be able to make the page wider or longer.

Thanks for any ideas.

Tony
 
True: the widest a form can be is 22 inches, and there's no way around that
limit.

Sounds like you'll have to change your approach so that you show fifty
fields on a single form, and they'll have to scroll through the single form
to see each row.
 
5) I drug these fields...

Drugging fields may have a tendancy for them to act unexpectedly. I would
advise against this, or at least take it slow at first and let them build
some sort of tolerance to it...

:-)

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
Back
Top