Solved

Linked Oracle table refresh question

Posted on 2009-05-14
1
248 Views
Last Modified: 2012-05-07
In my Access form, it's linked to an Oracle table, seems only when I close the access form, the current records are saved to Oracle table (they are linked), how to force save or synchronize the linked table? Thanks.
0
Comment
Question by:heyday2004
1 Comment
 
LVL 2

Accepted Solution

by:
michael1174 earned 500 total points
ID: 24388266
On your save button add:
    DoCmd.RunCommand acCmdSaveRecord
    Me.Dirty = False

On your exit button add:
If Me.Dirty = False Then
    DoCmd.Close acForm, "frmEdit", acSaveNo
ElseIf MsgBox("Save Changes?", vbYesNo, "Save") = vbNo Then
    If Me.Dirty = True Then
        Me.Undo
    End If
    DoCmd.Close acForm, "frmEdit", acSaveNo
Else
        DoCmd.Close acForm, "frmEdit", acSaveNo
End If

On your forms properties, set Close button to No.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access Crosstab Query with Multiple Values 4 32
VBA SQL statement - 2 "OR"s and 1 "And" 4 27
Report with several filters - Issue with query? 3 23
Filter a form 8 15
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question