View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JR Hester JR Hester is offline
external usenet poster
 
Posts: 170
Default 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!