DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

[kennedymr2]

I seem to be having a problem with:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

If i immediately open the recordset again and find the last record entered, the above acsaverecord does not seem to be saved.

If i wait for 10 seconds or so... it seems to be ok

Is this an issue with access ..????? or am i imaginging it ??

If this is the case , is there any way of forcing it write immediately


Regards Kennedymr2

 

[dhookom]

Open a recordset"? Can you share some additional code? I would try to avoid the DoMenuItem in favor of some other code (depending on what you are attempting to save)?

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya kennedymr2 . . .

Try:

[blue]docmd.RunCommand acCmdSaveRecord[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[kennedymr2]

Thanks for the replies..


I seem to have solved the problem by .refresh ie refreshing the datasource

I am not 100% sure this has solved the problem.. if not i will repost here.

Regards Kennedymr2

 

[TheAceMan1]

[blue]I am not 100% sure this has solved the problem..[/blue]

Don't guess ... let the pro's handle it. You can start by answering [blue]dhookom's[/blue] latest post (I was waiting for this myself). You can shrug it off or pin it down ... the choice is yours!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[assets]

Duane is right so is aceman1 save record

Never give up never give in.

There are no short cuts to anything worth doing