Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form does not allow entry in some fields
Excel XP on Windows XP
Excel database with only 4 fields( Name, date, type, notes). The data form displays all 4 fields and values in browse mode. When NEW buitton is selected to enter a new record, only the last field NOTES allows data entry. I should expand here a bit; the first three fields do not display the value box in NEW mode. There must be something controlling this that I can't locate. I tried adding a couple of new fields and those show up and allow data entry. Accepting any and all ideas suggestions, and thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form does not allow entry in some fields
Excel does not have databases. It has workbooks with worksheets. Excel does
not have browse mode. Are you confusing Excel, the spreadsheet processor, with Access, the database processor? Tyro "JR Hester" wrote in message ... Excel XP on Windows XP Excel database with only 4 fields( Name, date, type, notes). The data form displays all 4 fields and values in browse mode. When NEW buitton is selected to enter a new record, only the last field NOTES allows data entry. I should expand here a bit; the first three fields do not display the value box in NEW mode. There must be something controlling this that I can't locate. I tried adding a couple of new fields and those show up and allow data entry. Accepting any and all ideas suggestions, and thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form does not allow entry in some fields
Are the first 3 fields formulas?
Is the worksheet protected with the first 3 columns having the cells locked and the column having its cells unlocked? JR Hester wrote: Excel XP on Windows XP Excel database with only 4 fields( Name, date, type, notes). The data form displays all 4 fields and values in browse mode. When NEW buitton is selected to enter a new record, only the last field NOTES allows data entry. I should expand here a bit; the first three fields do not display the value box in NEW mode. There must be something controlling this that I can't locate. I tried adding a couple of new fields and those show up and allow data entry. Accepting any and all ideas suggestions, and thanks in advance! -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form does not allow entry in some fields
Database, table, or spreadsheet used to store data. The Excel Data Form
menu selection was what was where I was experiencing the problem. HAve yet to discover what caused the problem, but worked around it by copying data into a new workbook. The data entry form worked as expected in the new worksheet. I plan to use the corrupt workbook as a learning opportunity is this afternoons class. Thanks for your input "Tyro" wrote: Excel does not have databases. It has workbooks with worksheets. Excel does not have browse mode. Are you confusing Excel, the spreadsheet processor, with Access, the database processor? Tyro "JR Hester" wrote in message ... Excel XP on Windows XP Excel database with only 4 fields( Name, date, type, notes). The data form displays all 4 fields and values in browse mode. When NEW buitton is selected to enter a new record, only the last field NOTES allows data entry. I should expand here a bit; the first three fields do not display the value box in NEW mode. There must be something controlling this that I can't locate. I tried adding a couple of new fields and those show up and allow data entry. Accepting any and all ideas suggestions, and thanks in advance! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Form does not allow entry in some fields
You were right on target DAve, Thanks so much.. I had originally used a
choose formula to randomly populate my data table with sample data. Then I pasted specialvalues, leaving the formula in teh very last row( In case I needed to recreate that later) You prompted my memory-- as soon as I moved those formulas to a non-copntigous area the data entry form worked great. Thanks for jogging my memory! "Dave Peterson" wrote: Are the first 3 fields formulas? Is the worksheet protected with the first 3 columns having the cells locked and the column having its cells unlocked? JR Hester wrote: Excel XP on Windows XP Excel database with only 4 fields( Name, date, type, notes). The data form displays all 4 fields and values in browse mode. When NEW buitton is selected to enter a new record, only the last field NOTES allows data entry. I should expand here a bit; the first three fields do not display the value box in NEW mode. There must be something controlling this that I can't locate. I tried adding a couple of new fields and those show up and allow data entry. Accepting any and all ideas suggestions, and thanks in advance! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form for data entry | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Discussion (Misc queries) | |||
Can I use a FORM to enter data if I have more than the 32 fields? | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Worksheet Functions | |||
data entry form | Excel Discussion (Misc queries) |