How do I Add/ Edit/ Delete using Unbound MS Access .adp Project/ VBA F

[ndindi22]

HI guys,

How do I Add/ Edit/ Delete using Unbound MS Access .adp Project/ VBA Form

I need to populate the form manually by executing SQL statements in the VBA code. Add buttons to the form to position to the first, last, next, and previous row. Add buttons that facilitate add, edit, and delete through the use of SQL.

My MS Access form, should be a 'adp' project and connected to SQL Server data, or if it difficult to do, I can use MS Access data

Ndindi

 

[Remou]

Is this a school project? Either way, you have a lot of reading to do.

 

[ndindi22]

How do I connect to a .adp database or is it different from .mdb

 

[genomon]

Wow. BTW .adp is an Access Database Project. Generally, it "connects" to SQL Server or other linked data sources.
Please heartily embrace kind Remou's advice, and read a book on beginning Access (or ask quetions in class).

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."