A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't enter data into a form for new entry



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 07:38 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Can't enter data into a form for new entry

I am trying to enter information for a NEW record into a form. When I go to
that field, I can't enter information for the new record, but I am able to
modify information in that same field for an existing record. Any ideas why?

Thanks
--
Dave S
  #2  
Old February 22nd, 2006, 07:56 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Can't enter data into a form for new entry

Is this a Linked SQL Server table?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Dave S" wrote in message
...
I am trying to enter information for a NEW record into a form. When I go

to
that field, I can't enter information for the new record, but I am able to
modify information in that same field for an existing record. Any ideas

why?

Thanks
--
Dave S



  #3  
Old February 22nd, 2006, 09:50 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Can't enter data into a form for new entry

Parts of the data contained on the record are linked to other tables. The
field that is NOT allowing me to enter new information is linked to another
table. Not sure if it is an SQL Server table. How would I determine that?

Thanks for responding
--
Dave S


"Roger Carlson" wrote:

Is this a Linked SQL Server table?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Dave S" wrote in message
...
I am trying to enter information for a NEW record into a form. When I go

to
that field, I can't enter information for the new record, but I am able to
modify information in that same field for an existing record. Any ideas

why?

Thanks
--
Dave S




  #4  
Old February 23rd, 2006, 02:00 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Can't enter data into a form for new entry

You'd know if it was a SQL Server table. Describe the problem more fully.
What are the table names and what are they for? What is the name of the
field you are having problems with and what data type is it? Are there any
relationships between the tables involved?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Dave S" wrote in message
...
Parts of the data contained on the record are linked to other tables. The
field that is NOT allowing me to enter new information is linked to

another
table. Not sure if it is an SQL Server table. How would I determine

that?

Thanks for responding
--
Dave S


"Roger Carlson" wrote:

Is this a Linked SQL Server table?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Dave S" wrote in message
...
I am trying to enter information for a NEW record into a form. When I

go
to
that field, I can't enter information for the new record, but I am

able to
modify information in that same field for an existing record. Any

ideas
why?

Thanks
--
Dave S






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Customers- Contracts form problem GL Using Forms 10 February 7th, 2006 04:05 PM
Pulling data from values selected in dropdown list-values back to babs Using Forms 1 January 26th, 2006 07:40 PM
Combo Box NotInList - How To Add Data To Underlying Table 10SNUT Using Forms 19 July 8th, 2005 09:12 PM
Thinking about an unbound data entry form... Fred Boer Using Forms 16 May 6th, 2005 05:55 PM
Rapid input Via datasheet RudyR_Seattle General Discussion 4 January 31st, 2005 01:33 AM


All times are GMT +1. The time now is 07:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.