Access Module
[140 byte] By [requiem78] at [2007-11-11 11:59:49] 
Hi.I want to make a module in access which it will replace data in a specific field on a specific table.Does anyone how I can illustrate it?
# 1 Re: Access Module
Welcome to dev-archive :WAVE:You need to supply some more details. What do you mean by "module"? How will it replace data in a specific field? What data and with what will it be replaced?
Hack at 2007-11-11 23:42:33 >
# 2 Re: Access Module
In microsoft access you can add a module and write code in VBA.So I want this code to get access in my table "Vlaves" and to replace data in the field "SYMPTOM" in all records.It is like search and replace in Excel in one column.requiem78 at 2007-11-11 23:43:33 >
# 3 Re: Access Module
Then I would run an SQL UPDATE query that would go something like:UPDATE vlaves SET symptom = 'New Value'Without the WHERE clause, this would affect ALL records in your database.Hack at 2007-11-11 23:44:39 >
# 4 Re: Access Module
I found out the way.Thanks at allrequiem78 at 2007-11-11 23:45:45 >
# 5 Re: Access Module
If you aren't using an UPDATE query, then please post your solution.It might help someone else with the same or similiar question.
Hack at 2007-11-11 23:46:44 >
