Savebutton Madness Continued

  • Thread starter Thread starter John S
  • Start date Start date
J

John S

Back again.

I have a form (frmprop) with pet ownership info, and a second form (sfPet)
that contains a datasheet with information on each of the pets owned.In
order to get a save button, I have bound the datasheet to a temporary table
so as to use a save button.. Problem is that the datasheet returns
"deleted#" for most of the fields, but will show the information when moved
in and out of design more.

I am first deleting, and then loading the temporary table in the form load
event of the main form. One of the newgroup experts suggested first setting
the recordsource to "", and then requerying. Doesn't appear to work. In
particular, when I tried this line -- [Form_sfPet].Form.RecordSource =
"[TEMPPETS]" -- , I received an error message that the Microsoft Jet
database couldn't find the input table (I checked and rechecked my
spelling).

Something basic I'm missing here?

John S
Aylmer, PQ
 
---------- "John S said:
I have a form (frmprop) with pet ownership info, and a second form (sfPet)
that contains a datasheet with information on each of the pets owned.In
order to get a save button, I have bound the datasheet to a temporary table
so as to use a save button.. Problem is that the datasheet returns
"deleted#" for most of the fields, but will show the information when moved
in and out of design more.

I am first deleting, and then loading the temporary table in the form load
event of the main form. One of the newgroup experts suggested first setting
the recordsource to "", and then requerying. Doesn't appear to work. In
particular, when I tried this line -- [Form_sfPet].Form.RecordSource =
"[TEMPPETS]" -- , I received an error message that the Microsoft Jet
database couldn't find the input table (I checked and rechecked my
spelling).

Something basic I'm missing here?
Click to expand...

John,

I'd ask why don't you simply use the standard form/subform construct
(owner in main form, owned pets in subform)? Why a temporary table,
and what would you want to save when? Also, if you have some code
please post it.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 
As indicated in part one of "SaveButton Madness", I want to be able to do
validation on items in the datasheet, and in effect to be able to roll back
changes. To do validation on the datasheet items, I must have a save
button, and bind the datasheet to a temporary table. Then I can manipulate
entries when updating from the temporary table to the permanent one.

Everything is now working EXCEPT this problem with refreshing or requerying
the datasheet after the delete

At the moment, I am using a standard prop/pet form/subform. Love the
datasheet, but it is scary: you have no control over the save process.

I haven't found much documentation on datasheets as controls: they really do
have a certain "black box" quality to them, and I suspect they don't
function like other controls (if they are indeed a control).

John S.
Aylmer, Quebec Canada.

Emilia Maxim said:
---------- "John S said:
I have a form (frmprop) with pet ownership info, and a second form (sfPet)
that contains a datasheet with information on each of the pets owned.In
order to get a save button, I have bound the datasheet to a temporary table
so as to use a save button.. Problem is that the datasheet returns
"deleted#" for most of the fields, but will show the information when moved
in and out of design more.

I am first deleting, and then loading the temporary table in the form load
event of the main form. One of the newgroup experts suggested first setting
the recordsource to "", and then requerying. Doesn't appear to work. In
particular, when I tried this line -- [Form_sfPet].Form.RecordSource =
"[TEMPPETS]" -- , I received an error message that the Microsoft Jet
database couldn't find the input table (I checked and rechecked my
spelling).

Something basic I'm missing here?
Click to expand...

John,

I'd ask why don't you simply use the standard form/subform construct
(owner in main form, owned pets in subform)? Why a temporary table,
and what would you want to save when? Also, if you have some code
please post it.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
Click to expand...
 
Back
Top