Linked Table doesn't allow Edits (is there a way to allow them)

[boblarson]

IT doesn't

If you append records into a table with an autonumber it WILL add the autonumber for you. But if it isn't then either the autonumber seed is off or the table is corrupt.

 

[hardhitter06]

Wow...I was being extremely stupid...my apologies.

Yes this does work with the Autonumber.


Is there a way by any chance to export this data to excel, to a specific template that formats the fields better?

I know how to export it to excel, but the Time field comes up as "00-JAn-00" for all records. Also, some of the State and Research accounts aren't show because the colum isnt wide enough and I have to fix that to see all of the data.

So I'm wondering if its possible to set something up like that for excel to eliminate these formatting issues because I need export to excel on a daily basis.

??

Thank you Mr. B and Bob for your earlier help with the Append Query..again my fault.