Re: Autonumber needed in form when new record opens

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

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.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>
.

Relevant Pages

  • 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: Autonumber needed in form when new record opens
    ... > frustrating. ... >>> SQL database with Access Project ... can you update records in it? ... >> query? ...
    (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: FORM Calculations. Please Help!!!!
    ... >> The Forms recordsource is a table called Trade Information Table. ... > It would be nice to compute the grouped sum in the query, ... So we're stuck with doing it in a controlsource ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)