LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 170
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form for data entry Lin Light Excel Discussion (Misc queries) 2 October 9th 07 06:01 PM
Data Entry Form Brian T Excel Discussion (Misc queries) 8 March 5th 07 02:23 PM
Can I use a FORM to enter data if I have more than the 32 fields? Graciemygirl Excel Discussion (Misc queries) 3 March 23rd 06 11:01 PM
Data Entry Form Bethany L Excel Worksheet Functions 0 February 20th 06 06:23 PM
data entry form Tess Excel Discussion (Misc queries) 0 March 2nd 05 03:43 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"