How to add a record into exisiting DBs by clicking a command butto

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a form to add/delete/preview records into existing DBs by
clicking a command button. When I click a button, I would like to display
another form showing all data fields and their associated values row by row.
I have been looking for some examples for this, but I can't find anyone
unfortunately. I deeply appreciate if anyone can send me some examples what I
can use for learning this subject by myself. I do have some experience with
VB abd VBA, but I have very little experience with ACCESS programming. Hope
to hear from you soon. Thanks.
 
All you need do is to open the table in datasheet view.

DoCmd.OpenTable "MyTable", acViewNormal, acEdit

It's not really a recommended way to develop an application though.
All data manipulation should be done via forms.

-Dorian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Add New Record Command Button 7
Using Recordset Objects 4
add record command button in a form 7
recording Macros 10
Can't go to new record 1

Back
Top