Re: Form and Subform record issues

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

On Mon, 26 Mar 2007 22:02:21 GMT, "Corey-g via AccessMonster.com" <u19162@uwe>
wrote:

Or any other work-around?

ummm... a local scratchpad table? Just empty it with a DELETE query on opening
the form (or some other appropriate event) and append its contents to the
linked Oracle table.

To prevent bloat, you may want to have a separate Access backend just for this
table (or for it and other temp tables).

John W. Vinson [MVP]
.

Relevant Pages

  • Re: weird null value handling
    ... Append Blank ... VFP is not behaving as it should, ... If your query will return nulls, use NVLon any affected column to ... provide that empty value on rows that contain null. ...
    (microsoft.public.fox.helpwanted)
  • Re: Combining several tables in MS Access 2007
    ... Make a new empty table or choose the existing table to be the ... Make a query for all field and records for the first table. ... and I selected that as my "Append to" destination. ...
    (comp.databases.ms-access)
  • Re: weird null value handling
    ... affects columns NOT included in the INSERT. ... If your query will return nulls, use NVLon any affected column to provide ... that empty value on rows that contain null. ... " if you use APPEND FROM or INSERT INTO to copy ...
    (microsoft.public.fox.helpwanted)
  • Which event to chech?
    ... The datasource of the starting form of my access program ... The query selects the field user and the ... If he is not then the query is empty an after ... opening the form I get empty grey form. ...
    (microsoft.public.access.formscoding)
  • Re: weird null value handling
    ... I didn't want to use NVL because there were a lot of fields. ... If your query will return nulls, use NVLon any affected column to provide ... that empty value on rows that contain null. ... " if you use APPEND FROM or INSERT INTO to copy ...
    (microsoft.public.fox.helpwanted)