new Record

  • Thread starter Thread starter Yoshi
  • Start date Start date
Y

Yoshi

I have having issue storing data into an Oracle database.
I created a form(unbound fields) to capture the data and then send the data
to a similar form(bound fields) for final storage into an Oracle database.

Every is good except that it will not store the data unless I make a manual
change to the fields.

Am I missing something? Is there a way to store the data when I am ready?
 
I have having issue storing data into an Oracle database.
I created a form(unbound fields) to capture the data and then send the data
to a similar form(bound fields) for final storage into an Oracle database.

Every is good except that it will not store the data unless I make a manual
change to the fields.

Am I missing something? Is there a way to store the data when I am ready?
Click to expand...

You'll need to take *some* action on the bound form. You should be able to
force it to save the record by adding a line after all the fields have been
copied by including a line

Forms!boundformname.Dirty = False
 
I am not a vb expert, but is there a way to do it in design view?
Click to expand...

<huh>?

Design view of what? You surely already have code of some sort to copy values
from the unbound form to the bound form, do you not? How are you doing that?
 
I am not using VB to create the form.

I think there is a way to convert it to VB.
Click to expand...

I'm sorry, Yoshi, but I don't think we're communicating at all!

Are you using Microsoft Access forms here?

I did not suggest using VB, nor did I suggest creating a form.

You said

I created a form(unbound fields) to capture the data and then send the data
to a similar form(bound fields) for final storage into an Oracle database.


That suggests that you have SOME process - you have not said what process - to
"send the data" from one (unbound Access) form to a different (bound) form.

What is that process? How do you send the data?
 
I have the data linked from one form to the other.
Click to expand...

How is it "linked"?

Yoshi, *I cannot see your database*. I can only see what you post here. Please
post enough information that someone might have a chance to understand what
you're doing!!!
 
Back
Top