Re: Multiple Record Copy Transaction...

Are these Access tables?
Or attached tables from SQL Server or other database?
Access assigns the autonum *before* the update; SQL Server does not.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<davidgordon@xxxxxxxxxxxxxxxxxx> wrote in message
news:1126710933.696380.179790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Allen,
>
> Reading the new Autonumber before the .update throws up an error:
> Invalid use of Null
>
> I have commented out the sub-records code for now, I just want to
> understand what is happening with the main product first.
>
> Thanks
>
> PS: If you feel I have taken too much of your time, please let me know
> and i'll try to continue working it out :-(. Do you just answer posts
> for a full time job ?, what else do you do ?
>
> David
>


.

Relevant Pages

  • Re: How to queryvery many conditions in VBA
    ... But is that because Jet is putting those values into a temp table behind ... I've been told that SQL Server does this ... Allen Browne - Microsoft MVP. ... IN to a series of OR criteria. ...
    (microsoft.public.access.queries)
  • Re: Financial Comparison
    ... not really familiar with our SQL server, where a part of the data is coming ... However, the table that I have locally, which is being merged with the query ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.reports)
  • Re: how much computer power needed for run-time access?
    ... we're trying to keep costs down. ... is a special edition of sql server needed? ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Set table conditions to run Docmd
    ... Allen Browne wrote: ... as well as in SQL Server and ODBC ... name in square brackets: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Query Problem- Urgent Help Required
    ... And here is the sql Server 2000 version - which could almost be ... translated to jet sql - but I just can't get the syntax to work ... correctly (and this query also requires an Identity (autonum) column on ...
    (comp.databases.ms-access)