VBA, Edit a value in a table from code

Edit a value in a table from code

Author	Message
Chad Waldma #1 / 3	Edit a value in a table from code How can I edit the value in a column of a particular table, of a particular row (record) from within code? I am not very familiar with recordsets and can use some help with this probably simple procedure. I know I can do it by calling a query, but is there a better way than having to create a query for this procedure and running it... maybe just define a temp update query or something? I want to basically change the value in a yes/no field to the opposite of what it is. Chad Waldman P.S One more quick question... If you compact a database from within the front-end, will it also compact the backend? If not, how can I compact the backend (tables) from within the FE without ever having to close the FE session? Also, is compaction only for tables, or does it somehow compact the whole database in general?
Thu, 03 May 2001 03:00:00 GMT

Michael D. Falcone #2 / 3	Edit a value in a table from code Hi Chad, You probuably want something like: ---------------------------- Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("Put your SQL code here to find the particular record(s)") With rst .MoveFirst Do While .EOF = False .Edit !fieldname = newvalue .Update .MoveNext Loop .Close End With Set dbs = Nothing ---------------------------- All the best, Michael
Fri, 04 May 2001 03:00:00 GMT

Simon Lewi #3 / 3	Edit a value in a table from code Quote: >How can I edit the value in a column of a particular table, of a >particular row (record) from within code? I am not very familiar with >recordsets and can use some help with this probably simple procedure. I >know I can do it by calling a query, but is there a better way than >having to create a query for this procedure and running it... maybe just >define a temp update query or something? I want to basically change the >value in a yes/no field to the opposite of what it is. >Chad Waldman >P.S One more quick question... If you compact a database from within the >front-end, will it also compact the backend? If not, how can I compact >the backend (tables) from within the FE without ever having to close the >FE session? >Also, is compaction only for tables, or does it somehow compact the >whole database in general? Chad, If you want the code to run from a form, then a line like Me!chkMyCheck= not Me!chkMyCheck will toggle the value of the check box called chkMyCheck for the current record. Compacting 'front end' d/b will not compact a backend as well - they are different databases. You can't compact a database whilst it is in use. Whilst compacting mainly affects tables, it does reclaim other space as well. (It also does other things as well). Hope this helps. Simon Lewis
Fri, 04 May 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]