Re: Autonumber needed in form when new record opens

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

"terry beckman" <terrybeckman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:405C5470-E8EB-4EF0-9360-1343DFAC53DC@xxxxxxxxxxxxx
> I have not changed anything in this area. That is what is
> frustrating. An older version of the programs has no problems in
> this area. It does not save records from the form either. It there
> a way to check a return code when the record is attempted to be
> written.
>
> Thanks!
> Terry
>
> "Dirk Goldgar" wrote:
>
>> "terry beckman" <terrybeckman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:6C823812-D377-44B4-ABDC-089D596F881F@xxxxxxxxxxxxx
>>> Record now does not save at all, even from the form. Is there
>>> something I am missing?
>>> SQL database with Access Project
>>
>> Is this something you just upsized? Can you save any record from the
>> form, even without using this code? If you open the table directly
>> as a datasheet, can you update records in it? If your form is based
>> on a query (view or SQL statement), can you update records in that
>> query? Make sure the table has a primary key, if you want it to be
>> updatable. I'm not sure about ADPs, but I know that in ODBC-linked
>> MDBs, Access really likes there to be a timestamp field in the table.

Please answer the questions I asked. In what you posted above, when you
say, "It does not save records from the form either," I can't tell
whether you are referring to the "older version of the program", and
saying that old version can't save records from the form (implying
something about the back-end has changed), or whether are just sayiung
that this new version can't and the old version could.

What did you change between the old version and the new version?
Plainly you changed something, or there wouldn't *be* a new version.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: Autonumber needed in form when new record opens
    ... >> SQL database with Access Project ... > query, can you update records in that query? ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Autonumber needed in form when new record opens
    ... > SQL database with Access Project ... query, can you update records in that query? ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL vs. Access
    ... I can't say I know the rules in depth, but typically if you are using /linked/ tables in Access and you're not using a "pass-through" type query, then Access could be reading all the data it "thinks" is necessary to do the necessary joining/filtering, which may require a lot of data to pass between our SQL database and Access, which could I assume lead to behaviour which either looks like a hang or is a hang. ... Security. ... plain text logon/password information into your Word file or a .odc file. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Autonumber needed in form when new record opens
    ... can you update records in it? ... >>> query? ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: how to get last records out of 4 records per customer?
    ... One method (can update records if needed): ... FROM SPECIMEN as Temp ... Also this query cannot be created in query design view, but must use the SQL view to create the query. ... records for each customer with different dates, ...
    (microsoft.public.access.queries)