Re: Appending text data to existing table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I do not know what you mean by an index number. If you are referring to an autonumber field, then that should be created no matter how you enter records - import, typing, pasting, queries, etc.


What version of Access are you using?
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Richard wrote:
John,
You are right about the append part (not sure why it wasn't doing earlier).
However, the problem I'm having now is getting Access to automatically assign index numbers.
When I manually input, using what you call specificationNameasstring, it does assign an index. But when I do it from macro, the index number are absent.
.



Relevant Pages

  • Re: Textbook text candidate
    ... matter of popularity instead of a matter of fact. ... Good education addresses common questions. ... referring to the concept as an alternative to evolution, ...
    (talk.origins)
  • Re: Odd request - Anyone have any info on dial-up accounts?
    ... Deprecating habit of referring to people in such ways, ... yer serious idiot is not going to get the thing sorted, ... Matter of definition. ...
    (uk.rec.sheds)
  • Re: OT: The ACLU
    ... >> You should really stop referring to the NY Times. ... > What's the matter? ... I can repost the admission from the NY Times it's ...
    (alt.guitar.amps)
  • Re: Voyager performance with an engine down
    ... > The mention of REPs was only a passing thought, referring to my earlier ... > postings on the matter. ... it is badly mis-leading - the figures you have found for 221 ...
    (uk.railway)
  • Re: Recovery Time From A PA Event
    ... >> ruling class, as a way of legitimizing their rule. ... I am referring to claims of affiliation with whatever group or gang held sway before the apocalypse. ... I do not know why these sorts of claims would matter, ...
    (rec.games.frp.misc)