Good day all,
I have a strange problem.
I created a table with daily appends from outlook via a query and an append query.
The append data file has the date signature of outlook as a key field with no supplicates.
The input query lists all my input box entries.
Appending each day would have a result of a progressive duplicate errors except for the new days entries.
This worked for 5 days and 236 records. Worked on the data file last night. (no appends done just editing data)
Today I ran the append query, found one entry but I can't edit the data file via the form, BUT in sheetview I can change the data!!!
The new record icon at the bottom of the screen is grey, hence no addition either.
Appreciate your input,
Blessings,
I have a strange problem.
I created a table with daily appends from outlook via a query and an append query.
The append data file has the date signature of outlook as a key field with no supplicates.
The input query lists all my input box entries.
Appending each day would have a result of a progressive duplicate errors except for the new days entries.
This worked for 5 days and 236 records. Worked on the data file last night. (no appends done just editing data)
Today I ran the append query, found one entry but I can't edit the data file via the form, BUT in sheetview I can change the data!!!
The new record icon at the bottom of the screen is grey, hence no addition either.
Appreciate your input,
Blessings,