C
Corey-g via AccessMonster.com
Hi All,
I am having trouble getting this to work, and was hoping somebody out there
had some suggestions.
Background:
Access 2K3 FE to Oracle 10g BE
DSN-Less connection
ADO
Users connect to FE via citrix
Access as Run -Time
(Side note, still in development - so no citrix or runtime, yet - Anyone have
any gotcha's I should be aware of?)
I have a main data entry form that has multiple unbound combo boxes, each
with it's own recordset. When a user enters data into one of the combo boxes
that isn't already in the list, I have a new form pop up to finish inputting
the details for the new record (using the not_in_list event). This all works
okay, but I don't understand how to 'requery' when using recordsets.
So, what I would like to do is have the new data visible in the cbo when the
user is returned from adding the new record. I know that if I had bound
controls it would be easy, but do I have to create and attach a new recordset
each time this happens?
While I'm asking, I might as well try and get some clarification as well. If
I am using all unbound controls and recordsets, am I able to update values in
the BE database easily? Of course i realize it's not as easy as bound
controls, but is there a way to use the existing recordset rather than
creating an update statement dynamically?
Maybe I'm going aboput this all wrong, and I should be doing it another way...
Thanks in advance.
Corey
I am having trouble getting this to work, and was hoping somebody out there
had some suggestions.
Background:
Access 2K3 FE to Oracle 10g BE
DSN-Less connection
ADO
Users connect to FE via citrix
Access as Run -Time
(Side note, still in development - so no citrix or runtime, yet - Anyone have
any gotcha's I should be aware of?)
I have a main data entry form that has multiple unbound combo boxes, each
with it's own recordset. When a user enters data into one of the combo boxes
that isn't already in the list, I have a new form pop up to finish inputting
the details for the new record (using the not_in_list event). This all works
okay, but I don't understand how to 'requery' when using recordsets.
So, what I would like to do is have the new data visible in the cbo when the
user is returned from adding the new record. I know that if I had bound
controls it would be easy, but do I have to create and attach a new recordset
each time this happens?
While I'm asking, I might as well try and get some clarification as well. If
I am using all unbound controls and recordsets, am I able to update values in
the BE database easily? Of course i realize it's not as easy as bound
controls, but is there a way to use the existing recordset rather than
creating an update statement dynamically?
Maybe I'm going aboput this all wrong, and I should be doing it another way...
Thanks in advance.
Corey