Editing Data in Tables vs. Forms

[canadaboy]

If I need to edit data in a table via VBA code, do I have to operate on the data through the form object or can I do it directly to a table.

I've tried it for data on a form, but it doesn't seem to work when I tried it directly on the table that a form was based on.

The reason I ask is because I don't want to have to create a form for every table I want to edit with VBA code.

Any takers???????

 

[pbaldy]

You do not need to work through a form. You can either execute an append/delete/update query through code, or open a DAO/ADO recordset and work with the data that way.

 

[canadaboy]

I think I would like to work with either the DAO/ADO recordsets, but I'm not up to speed with them. The help files in ACCESS seem to refer to the "recordset property", but always in the context of FORMS. Can you point me to any sample code where I can get an idea of how to work with these objects.

Thanks.

 

[pbaldy]

There's some sample code here of the various options; it's a good primer:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=55486

His "qryExample" can be a table name, query name or an actual SQL statement ("SELECT Blah FROM Blah WHERE Blah")

 

[canadaboy]

Thanks!!! Let me take a look at it, and I'll let you know how it goes.

Where can I read up on the advantages of ADO vs. DAO???

 

[canadaboy]

I'll have to put this into my specific application, but the reference you gave me looks extremely promising. It also answered my question about ADO and DAO (it appears to be dependent on the version of ACCESS). I'm using ACCESS 2000 to develop the database but plan to run it at work using ACCESS 97. Can I expect problems?

 

[pbaldy]

I've only used 97 a little. Make sure you use DAO then, and you'd just have to watch out that you don't use a feature or function not available in 97. Offhand I'm not sure which are new to 2000, but odds are you'll be okay. Here's more info, including

For more information about what is new in Access 2000, click Microsoft Access Help on the Help menu, type what's new in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

http://support.microsoft.com/default.aspx?scid=kb;en-us;208773&Product=acc2000