Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2005

Tip: Looking for answers? Try searching our database.

My form won't let me enter new records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cheryl48 - 31 Jan 2005 18:21 GMT
I am very new to access, and am creating an address database. I'm tying to
create a pretty simple table for the contacts, and another table with zip
codes, cities and states. When I try to create a relationship between the 2
tables, to create a form to enter the data, it gives me an index message. Can
you help? The form, created from the query, won't let me enter new data.
Lynn Trapp - 31 Jan 2005 19:29 GMT
Cheryl,
When  you say "index message" can you be a bit more specific about what that
is? Also, could you paste the table structure for your two tables and what
the recordsources is for your form.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

>I am very new to access, and am creating an address database. I'm tying to
> create a pretty simple table for the contacts, and another table with zip
[quoted text clipped - 3 lines]
> Can
> you help? The form, created from the query, won't let me enter new data.
Cheryl48 - 31 Jan 2005 20:19 GMT
Well, actually, I figured out how to make the relationship work, but it still
won't let me input new data into a form that I created from a query with both
tables included in the query. I created 2 tables, one for the contacts, and
one for the zip code. The zip code one only has 3 fields, (zip, city and
state). The contact table has 31 fields. I created a query, sorting the last
and first names, using both tables, and created a form from that "alpha
query". I've gotten the tabs to cooperate (skipping over the city and state),
but the form will not allow me to enter a new record.

> Cheryl,
> When  you say "index message" can you be a bit more specific about what that
[quoted text clipped - 8 lines]
> > Can
> > you help? The form, created from the query, won't let me enter new data.
Lynn Trapp - 31 Jan 2005 20:48 GMT
Can you post the SQL statement for the query?

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Well, actually, I figured out how to make the relationship work, but it
> still
[quoted text clipped - 29 lines]
>> > you help? The form, created from the query, won't let me enter new
>> > data.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.