Updating table via form

[Guest]

Two months ago I created a database along with several forms and queries.
The database contains basically two tables. The source of the primary data
is obtained (updated) once a month from the office (I get the data in the
form of a .txt file that is exported from an Access 2003 database and then
import it into my 2003 database). The secondary data, notes I make
concerning the primary data, is stored in a second table (related) in my
database alone. The main data input and update form (data imput and correctin
form) has an associated query. When I first created the database I was able
to update the two tables from the the form. Now that I have gone through a
couple of update cycles (imported the primary source data from the office),
Access will no longer allow me to make corrections via the form to the
tables. Please provide any help. I know it is something really simple, but
right now I am just too tired to see it. Thanks in advance.

 

[John Vinson]

Now that I have gone through a
couple of update cycles (imported the primary source data from the office),
Access will no longer allow me to make corrections via the form to the
tables. Please provide any help.

Well, you're too tired to see it - and I'm too far away.

Please post the Recordsource property of the Form and of the subform;
if one or both are queries, please post the SQL view of the query. If
you open the recordsource as a datasheet, can you update that?

John W. Vinson[MVP]

 

[Guest]

I am a little new to all this; I hope this is what you wanted when you asked
for the SQL view of the query:

SELECT April2006subscribers.MemNum, April2006subscribers.LastName,
April2006subscribers.FirstName, April2006subscribers.MiddleName,
April2006subscribers.Prefix, April2006subscribers.Suffix,
April2006subscribers.Nickname, April2006subscribers.DOB,
April2006subscribers.BirthPlace, April2006subscribers.Spouse,
April2006subscribers.HPhone, April2006subscribers.WPhone,
April2006subscribers.CPhone, April2006subscribers.Fax,
April2006subscribers.EMail, April2006subscribers.TempStartDate,
April2006subscribers.TempEndDate, April2006subscribers.Recurring,
April2006subscribers.OccupationTitle, April2006subscribers.Employer,
April2006subscribers.StatusTitle, April2006subscribers.StatusType,
April2006subscribers.StatusDate, April2006subscribers.LastAnnualRpt,
April2006subscribers.DuesTitle, April2006subscribers.FratDuesTitle,
April2006subscribers.TotalDue, April2006subscribers.Arrears,
April2006subscribers.Type, April2006subscribers.Address1,
April2006subscribers.Address2, April2006subscribers.Address3,
April2006subscribers.City, April2006subscribers.State,
April2006subscribers.Zip, April2006subscribers.Foreign,
April2006subscribers.County, SuplementaryTBL.MemNumSupp,
SuplementaryTBL.ScratchPad, SuplementaryTBL.SelectDeselect
FROM April2006subscribers LEFT JOIN SuplementaryTBL ON
April2006subscribers.MemNum = SuplementaryTBL.MemNumSupp;

The record source property for the query is: April2006subscribers Query

There is only the one query.

There is no subform. I have a a form with TAB SHEET views. THe fields on
the second sheet are fields from my second table and are pulled by the one
query.

I hope I have provided the right information for you.

When I first made the database and populated it with the first download,
everythng worked fine. It was when I did the second download that everything
stopped working.

And yes, when I open the recordsource as a datasheet, I can update the table
without a problem.

 

[John Vinson]

FROM April2006subscribers LEFT JOIN SuplementaryTBL ON
April2006subscribers.MemNum = SuplementaryTBL.MemNumSupp;

Is MemNum the Primary Key of April2006Suppliers? Have you defined a
Relationship between the two tables? The query will probably not be
updateable otherwise.

The record source property for the query is: April2006subscribers Query

There is only the one query.

There is no subform. I have a a form with TAB SHEET views. THe fields on
the second sheet are fields from my second table and are pulled by the one
query.

If it's a one to many relationship, you'll find that a Subform will be
much easier to use.

I hope I have provided the right information for you.

When I first made the database and populated it with the first download,
everythng worked fine. It was when I did the second download that everything
stopped working.

Sounds like there's some difference between the two downloaded tables
- indexing or the like. I'd really suggest creating a CurrentDownload
table as a permanent table, and import the monthly files *into this
table*, rather than creating a new table for each month's import.

And yes, when I open the recordsource as a datasheet, I can update the table
without a problem.

And that is [April2006subscribers Query] that you're opening? Odd!

John W. Vinson[MVP]

 

[Guest]

Sorry the name of the query is: DataInputQRY

I am a little new to all this; I hope this is what you wanted when you asked
for the SQL view of the query:

SELECT April2006subscribers.MemNum, April2006subscribers.LastName,
April2006subscribers.FirstName, April2006subscribers.MiddleName,
April2006subscribers.Prefix, April2006subscribers.Suffix,
April2006subscribers.Nickname, April2006subscribers.DOB,
April2006subscribers.BirthPlace, April2006subscribers.Spouse,
April2006subscribers.HPhone, April2006subscribers.WPhone,
April2006subscribers.CPhone, April2006subscribers.Fax,
April2006subscribers.EMail, April2006subscribers.TempStartDate,
April2006subscribers.TempEndDate, April2006subscribers.Recurring,
April2006subscribers.OccupationTitle, April2006subscribers.Employer,
April2006subscribers.StatusTitle, April2006subscribers.StatusType,
April2006subscribers.StatusDate, April2006subscribers.LastAnnualRpt,
April2006subscribers.DuesTitle, April2006subscribers.FratDuesTitle,
April2006subscribers.TotalDue, April2006subscribers.Arrears,
April2006subscribers.Type, April2006subscribers.Address1,
April2006subscribers.Address2, April2006subscribers.Address3,
April2006subscribers.City, April2006subscribers.State,
April2006subscribers.Zip, April2006subscribers.Foreign,
April2006subscribers.County, SuplementaryTBL.MemNumSupp,
SuplementaryTBL.ScratchPad, SuplementaryTBL.SelectDeselect
FROM April2006subscribers LEFT JOIN SuplementaryTBL ON
April2006subscribers.MemNum = SuplementaryTBL.MemNumSupp;

The record source property for the query is: April2006subscribers Query

There is only the one query.

There is no subform. I have a a form with TAB SHEET views. THe fields on
the second sheet are fields from my second table and are pulled by the one
query.

I hope I have provided the right information for you.

When I first made the database and populated it with the first download,
everythng worked fine. It was when I did the second download that everything
stopped working.

And yes, when I open the recordsource as a datasheet, I can update the table
without a problem.