Append Query Question

I'm just starting trying to put together an Access app for the first time
and would appreciate some help.

I've read and updated data in Access database files from VB programs but
never done it within an Access module. Can I still use ADO and read/write
data to the MDB file from within a module of the MDB file, or is there some
object of the application that I can execute sql queries and updates against?

Thanks for any help.

Yes, you can. In fact, Access makes it easier for you to establish the
connection to the current database with CurrentProject.Connection.

Check Access VB Help on the Connection Property of CurrentProject.

HTH
Van T. Dinh
MVP (Access)



"AccessNewbie" wrote in message
...

I'm just starting trying to put together an Access app for the first time
and would appreciate some help.

I've read and updated data in Access database files from VB programs but
never done it within an Access module. Can I still use ADO and read/write
data to the MDB file from within a module of the MDB file, or is there
some
object of the application that I can execute sql queries and updates
against?

Thanks for any help.

Van, thanks for the tip. That at least got me started. Now I have another
problem...

The form I am working with uses navigationbuttons for moving among the
table's records. The form has several controls that are bound to various
fields. I want to use the value of one of the controls after the user moves
to a different record. My current problem is that I don't know how to
determine the current record number. Can you help?

thanks

"Van T. Dinh" wrote in message
...
Yes, you can. In fact, Access makes it easier for you to establish the
connection to the current database with CurrentProject.Connection.

Check Access VB Help on the Connection Property of CurrentProject.

HTH
Van T. Dinh
MVP (Access)

Not sure what you meant by "to use the value of one of the Controls" but
check Access Help on the following Properties of the Form:

* CurrentRecord
* BookMark

--
HTH
Van T. Dinh
MVP (Access)




"AccessNewbie" accessnewbie wrote in message
...
Van, thanks for the tip. That at least got me started. Now I have another
problem...

The form I am working with uses navigationbuttons for moving among the
table's records. The form has several controls that are bound to various
fields. I want to use the value of one of the controls after the user
moves
to a different record. My current problem is that I don't know how to
determine the current record number. Can you help?

thanks

Thanks again. that helps but I'm still left with issue of event. I can't see
any event that corresponds to the user clicking one of the form navigation
buttons.


"Van T. Dinh" wrote in message
...
Not sure what you meant by "to use the value of one of the Controls" but
check Access Help on the following Properties of the Form:

* CurrentRecord
* BookMark

--
HTH
Van T. Dinh
MVP (Access)




"AccessNewbie" accessnewbie wrote in message
...
Van, thanks for the tip. That at least got me started. Now I have
another
problem...

The form I am working with uses navigationbuttons for moving among the
table's records. The form has several controls that are bound to various
fields. I want to use the value of one of the controls after the user
moves
to a different record. My current problem is that I don't know how to
determine the current record number. Can you help?

thanks

Use the Form_Current Event???

--
HTH
Van T. Dinh
MVP (Access)


"AccessNewbie" accessnewbie wrote in message
...
Thanks again. that helps but I'm still left with issue of event. I can't
see
any event that corresponds to the user clicking one of the form navigation
buttons.