add new record progmatically

[richard harris]

hi,

does any one know if access has the feature to add a record progmatically
with out the need to physically open a form or a table.

something such as

table open
field 1 value ="a"
field value 2 = "b"
field value 3 = "c"
table close.

thanks

richard

 

[Wayne-I-M]

Yes - there are lots of methods

It depend on where you get your data from

You need to post my details to get a better answer

 

[Allen Browne]

Execute an append query statement.
There's an example of the code here:
http://allenbrowne.com/ser-60.html

Alternatively, you can OpenRecordset, and AddNew.

 

[richard harris]

thanks Wayne / Allen.

i just wanted to know if it could be done. im not ready to do it yet, but
it will influence the design of my application.

i did a search on new records but couldnt find anything to answer my question.

richard.