new Record Yoshi 12/1/2008 9:21:00 PM 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?

Re: new Record John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/1/2008 11:28:40 PM On Mon, 1 Dec 2008 13:21:00 -0800, Yoshi <Yoshi[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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? > 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 -- John W. Vinson [MVP]

Re: new Record Yoshi 12/2/2008 12:21:00 AM I am not a vb expert, but is there a way to do it in design view? "John W. Vinson" wrote: [Quoted Text] > On Mon, 1 Dec 2008 13:21:00 -0800, Yoshi <Yoshi[ at ]discussions.microsoft.com> > wrote: > > >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? > > > > 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 > > -- > > John W. Vinson [MVP] >

Re: new Record John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/2/2008 12:48:24 AM On Mon, 1 Dec 2008 16:21:00 -0800, Yoshi <Yoshi[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I am not a vb expert, but is there a way to do it in design view? <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? -- John W. Vinson [MVP]

Re: new Record Yoshi 12/2/2008 2:10:05 AM I am not using VB to create the form. I think there is a way to convert it to VB. "John W. Vinson" wrote: [Quoted Text] > On Mon, 1 Dec 2008 16:21:00 -0800, Yoshi <Yoshi[ at ]discussions.microsoft.com> > wrote: > > >I am not a vb expert, but is there a way to do it in design view? > > <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? > -- > > John W. Vinson [MVP] >

Re: new Record John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/2/2008 6:05:37 AM On Mon, 1 Dec 2008 18:10:05 -0800, Yoshi <Yoshi[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I am not using VB to create the form. > >I think there is a way to convert it to VB. 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? -- John W. Vinson [MVP]

Re: new Record Yoshi 12/2/2008 7:26:11 PM I have the data linked from one form to the other. "John W. Vinson" wrote: [Quoted Text] > On Mon, 1 Dec 2008 18:10:05 -0800, Yoshi <Yoshi[ at ]discussions.microsoft.com> > wrote: > > >I am not using VB to create the form. > > > >I think there is a way to convert it to VB. > > 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? > -- > > John W. Vinson [MVP] >

Re: new Record John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/2/2008 7:58:13 PM On Tue, 2 Dec 2008 11:26:11 -0800, Yoshi <Yoshi[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I have the data linked from one form to the other. 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!!! -- John W. Vinson [MVP]