By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

To save from a temporary table??

P: n/a
Hi,

I have unbelievable problems just to save a record!

I make an input to a record in a subform, which has a
temporary table as its recordsource.

When I am done, and want to save the record, I want to bring
the data from the temporary table over to the regular table.
But the data isn't in the temporary table yet, it is still
on the form.

So I do the obvious 'DoCmd.Save'. That has no effect.
The temporary table is empty.
I do 'Parent.SetFocus' to leave the subform and possibly
force a saving. This has no effect.
The temporary table is empty.
I try to use the Recordsetclone of the subform to get the
data from it, but this is for some reason empty.
I do 'Docmd.Close acForm, Me.Name', referring to the
subform. Plus 'DoEvents'. But the subform does not close at
this moment.
And still the data does not appear in the temporary table
which is/was the recordsource for the subform.

Not until I have completely left the Saving procedure does
the subform close and the data appears in the temporary
table.
But the first idea with the Saving procedure was just to
bring the data over from the temporary table.

Of course I can now open a new procedure and catch the data
from the now filled temporary table...

But it cannot be this stupid, I must have missed something.
Can you give me some hints?

Larry
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Larry <lm****@telia.com> wrote:

Please ignore the posting from starwars. He's being rather disruptive.
When I am done, and want to save the record, I want to bring
the data from the temporary table over to the regular table.
But the data isn't in the temporary table yet, it is still
on the form.

So I do the obvious 'DoCmd.Save'.


That saves the form. Not the record. You really wanted:
docmd.RunCommand acCmdSaveRecord

However it's been my experience in A2000 that if the record does not need saving this
causes an error. Thus you're better off using the following:

if me.dirty = true then me.dirty = false

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2

P: n/a

"starwars" <no****@tatooine.homelinux.net> wrote in message
news:84******************************@tatooine.hom elinux.net...
Larry wrote:
Hi,

I have unbelievable problems just to save a record!

I make an input to a record in a subform, which has a
temporary table as its recordsource.

When I am done, and want to save the record, I want to bring
the data from the temporary table over to the regular table.
But the data isn't in the temporary table yet, it is still
on the form.

So I do the obvious 'DoCmd.Save'. That has no effect.
The temporary table is empty.
I do 'Parent.SetFocus' to leave the subform and possibly
force a saving. This has no effect.
The temporary table is empty.
I try to use the Recordsetclone of the subform to get the
data from it, but this is for some reason empty.
I do 'Docmd.Close acForm, Me.Name', referring to the
subform. Plus 'DoEvents'. But the subform does not close at
this moment.
And still the data does not appear in the temporary table
which is/was the recordsource for the subform.

Not until I have completely left the Saving procedure does
the subform close and the data appears in the temporary
table.
But the first idea with the Saving procedure was just to
bring the data over from the temporary table.

Of course I can now open a new procedure and catch the data
from the now filled temporary table...

But it cannot be this stupid, I must have missed something.
Can you give me some hints?

Larry

Are you also "Larry Linson"?

That sounds like the "Larry Linson" everybody around here knows.

Nov 12 '05 #3

P: n/a
Thanks,Tony!!
/Larry (not Linson)
Nov 12 '05 #4

P: n/a
Steve Jorgensen <no****@nospam.nospam> did not write that posting.
Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.


This is a forgery.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #5

P: n/a
Steve Jorgensen didn't write:

Comments: This message did not originate from the Sender address above.
X-No-Archive: Yes

--
Bas Cost Budde
http://www.heuveltop.nl/BasCB

Nov 12 '05 #6

P: n/a
Bas Cost Budde <ba*@heuveltop.org> wrote in message news:<bv**********@news2.solcon.nl>...
Steve Jorgensen didn't write:

Comments: This message did not originate from the Sender address above.
X-No-Archive: Yes


Sometimes it's nice to be reading USENET via Google. People who post
with X-No-Archive rarely have anything to say that's worth reading :-)
Nov 12 '05 #7

P: n/a
ph*****@hotmail.com (phobos) wrote:
Sometimes it's nice to be reading USENET via Google. People who post
with X-No-Archive rarely have anything to say that's worth reading :-)


<chuckle> Good one.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.