Data Entry Only

[Ann]

Hi,

I hope someone will have some ideas for what I need. I have a form with a
save button for each new record. I need the save button at the time it's
clicked to bring up a message box asking if they are certain they want to
save the record (yes or no). If they say no they have to stay on the record
to change what is wrong. If they say yes I need the record to be written to
the table but no longer available to go back to in the form. I tried using
the data entry property but I can still go back to the previous records
entered.

Is there a way to create a form without a table or query but still have text
boxes that I can put the data into the correct table/field once the save
button is clicked? Thanks for any help that can be given.

 

[Banana]

Hi,

I hope someone will have some ideas for what I need. I have a form with a
save button for each new record. I need the save button at the time it's
clicked to bring up a message box asking if they are certain they want to
save the record (yes or no). If they say no they have to stay on the record
to change what is wrong. If they say yes I need the record to be written to
the table but no longer available to go back to in the form. I tried using
the data entry property but I can still go back to the previous records
entered.

Is there a way to create a form without a table or query but still have text
boxes that I can put the data into the correct table/field once the save
button is clicked? Thanks for any help that can be given.

I suppose a simple way to do this is to set Data Entry to Yes and
disable Navigation Buttons and set Cycle property to Current Record only.

This should leave your users with no mean of navigating back and the
buttons you have right now will handle this.

Be aware, though, if they close the form with a partial record, you need
to trap for that.

 

[Ann]

I did try that and I can't move back to a previous record but the current
data is still showing in the fields. How do I clear out the data from the
fields after the record is saved?

 

[Banana]

FWIW, I don't think it's always necessary to use code to disable mouse
wheels when setting the Cycle property to current record only will just do.

 

[Banana]

I did try that and I can't move back to a previous record but the current
data is still showing in the fields. How do I clear out the data from the
fields after the record is saved?

As Linq suggested, does your button actually have code to move the
pointer to a new record?

 

[ADB_Seeker]

Hello,
I followed your steps below and get compile error "Ambiguous name detected:
MouseWheelOFF". For the code to turn the mousewheel on, I get compile error
"Ambiguous name detected: MouseWheelON".
I imported modMouseHook into my database and I placed the .dll in the folder
where my database resides.
Thanks in advance for your help.
Linda

 

[Douglas J. Steele]

That implies that you already had modules named MouseWheelON and
MouseWheelOFF somewhere in your application. Search for them, and get rid of
one set.

 

[ADB_Seeker]

Thank you so much!! It now works perfectly.

That implies that you already had modules named MouseWheelON and
MouseWheelOFF somewhere in your application. Search for them, and get rid of
one set.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)





.