DATA FORM problem

S

saziz

Hello Gurus,
I am facing yet another problem. I have created a small data bas
tracking parts inventory and usage. I am using DATA-Form for users t
input parts usage. But sometimes pats are added to the list and th
FORM does not capture the added colums to show up in the form. How ca
I solve this problem.
Also I want a trigger or perhaps a button which if clicked, should g
throug the list and print a list of parts to be ordered if under mi
level.
appreciate your help. I using Excell 2002.
sazi
 
A

Anders Silven

Hi saziz,

Excel Help says that a Data>Form can contain a maximum of 23 fields. Is that the
problem, perhaps?

For your second question, please describe how your spreadsheet is organized.

Regards,
Anders Silven
Excel 2002
 
D

Dave Peterson

Slightly lesdyxic: 32 fields.

<bg>

Anders said:
Hi saziz,

Excel Help says that a Data>Form can contain a maximum of 23 fields. Is that the
problem, perhaps?

For your second question, please describe how your spreadsheet is organized.

Regards,
Anders Silven
Excel 2002
Click to expand...
 
A

Anders Silven

Not me this time, Dave!

Copied and pasted from Excel XP Help - Swedish:

"Dataformulär kan innehålla högst 23 fält."

You can skip the translation; 23 in Swedish is the same as 23 in English.

BTW, when I prepared my reply, I tried to access
http://office.microsoft.com/assistance/offhelp/offxp/excel/
that I have used on and off, to get the help text in English.
However, now I got redirected to Microsoft Sweden where that page does not
exist.
www.microsoft.com is "user friendly" and redirects me to Swedish content all the
time without me asking for it. Don't know what to do about it.

Anders Silven
Sweden
 
S

saziz

Hi Anders,
No that is not the problem, as I said it is not capturing the coulmn
which are added after I wrote the macro, I hve less than 15 columns..
All I need macro to do is to capture all the cells having data to pu
in FORM. These are less than 23 columns.
My next Q is about a script which would go through tmy list of part
and capture those parts which are below set minimum level, compile
list with part no. and print.
saziz
 
A

Anders Silven

Hi again saziz,

Data>Form question: Post your code.

Print macro question: How is the worksheet organized? Column/Row headers? Where
is minimum level vs. current level?

Regards
Anders Silven
 
D

Debra Dalgleish

That must be 32 converted to kronors! Dave's right (for once <vbg>),
according to Microsoft:

XL2000: Error Using Data Form If Too Many Fields Are Present
http://support.microsoft.com/default.aspx?id=214303

Anders said:
Not me this time, Dave!

Copied and pasted from Excel XP Help - Swedish:

"Dataformulär kan innehålla högst 23 fält."

You can skip the translation; 23 in Swedish is the same as 23 in English.

BTW, when I prepared my reply, I tried to access
http://office.microsoft.com/assistance/offhelp/offxp/excel/
that I have used on and off, to get the help text in English.
However, now I got redirected to Microsoft Sweden where that page does not
exist.
www.microsoft.com is "user friendly" and redirects me to Swedish content all the
time without me asking for it. Don't know what to do about it.

Anders Silven
Sweden
Click to expand...
 
A

Anders Silven

I did not challenge Dave's statement that the maximum number of fields in a Data
Form is 32. My point was that I based my post on the Swedish Microsoft Excel
Help File where it says 23. Making fun of people who can't read or write can be
funny sometimes, but being lesdyxic, dyslectic, sydslected, or even odd is often
even
better.

Debra Dalgleish said:
That must be 32 converted to kronors! Dave's right (for once <vbg>),
according to Microsoft:

XL2000: Error Using Data Form If Too Many Fields Are Present
http://support.microsoft.com/default.aspx?id=214303
Click to expand...
 
S

saziz

Anders,
Thanks for baring with me. The spread sheet columns has the parts no.
and the rows gets filled in as the data is entered. I am targeting
particular column (say column F) which has an embeded formula to adjus
the inventory of an item. Once any part get sbelow set minimum level.
My script captures it and copy the relevant info cells of that item an
puts into another sheet and prints it.
Debra's idea of (dynamic range) for DATA FORM worked and I am almos
getting there..
saziz;
 
Top