saving record

[bluey]

how do i save a record without using a button.
i know acces saves records but i get a write conflict if i dont save manually.

 

[Travis]

Lookup Docmd.RunCommand acCMDSaveRecord

 

[bri822]

If you are closing your form, another way to save is:

DoCmd.Close , , acSaveYes

Upon closing your form it saves the data you entered, therefore you don't need to have a button

 

[bluey]

No i dont want the form to remain open i would like it to save when it closes.
and if possable save the record NOT the form
please

 

[bluey]

yes i did read it and in this particular instance it needs to be saves using some other means.

if you read my first post you would have seen ?
I stated that i under stood it saved automatically but a conflict occurs unless my data is saves another way.

i dont want to save anotherway but if i cant find another way of saving the records automatically ile have no choice.

(probably wont though)

 

[Carolyn]

Hi Pat,

Thanks for the information I find your knowledge to be very valuable. Please tell me where do I put
Lookup Docmd.RunCommand acCMDSaveRecord?

Thank you for your time

Carolyn

 

[ghudson]

Carolyn,

Put the code

Docmd.RunCommand acCMDSaveRecord

in an event or assign it to a command button to save the record.

Here is an example of using the Docmd.RunCommand acCMDSaveRecord in the On Click event for a command button named bSave.

Private Sub bSave_Click()
DoCmd.RunCommand acCmdSaveRecord
End Sub

HTH

 

[Carolyn]

Thank you ghudson and Pat I think I actually understand!

Carolyn

 

[bluey]

humm quite possably:
it dosen't matter if you cant help ile probably figure it out aventually.

My input form is initially a query but it is also linked to a macro which is made up of a delete qry\ update date qry\2 append qrys.

Im telling you this stuff so hopefully you will be able to understand what ime trying to do or not.

The qry/form has date/dayno/dayname/rota name. which can have data typed in to it manually, to create the records desired
you press a button after all the data a is entered and a macro is run in this order

setwarnings
open qry Delete dates:
open qry Generate dates} run 7 times in order shown
open qry increase date qry} run 7 times
open qry generate dates
open qry create rota records: this is were all the data is put in to my main form.
Cose the input form is closed

The delete qry deletes things in a table called days of week which containd a date field and 5 dates.

The update field updates a table called rota control this contains
a date /day no/rota name there is only one set of records in this table at a time.
this is nesasarry so i can specify what i want updating and so i dont get everything updating at once.

Finally i have an append qry which puts all this data into days of the week. and another append qry which appends allthe data from all the tables in to my mane form

I get the problem when i try to change things in the input form
probably more than you wanted to know.....os im sorry .
but it is complicated.

 

[bluey]

ok