MS access - clearing

Hi guys :D ,

I need a little advice,

I need to reset ALL the contect with in a Selected colloum in my access database

Database name is mutisavers.mdb
table name is table1
collum name is PoS_scan

Any adice or same code is MOST welcomed :)

Thanks in advance
Drew :WAVE:

[324 byte] By [Drew_gable] at [2007-11-11 6:58:29]

«« Picture Box
»» Backwards Compatable

# 1 Re: MS access - clearing

Assuming that PoS_scan contains Text data, you can do this:

UPDATE table1 SET PoS_scan = ""

or

UPDATE table1 SET PoS_scan = Null

Phil Weber at 2007-11-11 17:27:42 >

# 2 Re: MS access - clearing

Thanks

I have to say i was expecting pages of code but I like the simple ways ;o)

Drew

Drew_gable at 2007-11-11 17:28:42 >

# 3 Re: MS access - clearing

It is not working.

Am i doing something wrong

What i forgot to mention is i am using a vba program as my interface to the database (ado)

do i need to change the coding some how??

Drew_gable at 2007-11-11 17:29:37 >

# 4 Re: MS access - clearing

I don't know. Please post your code and describe how it is "not working" (error messages, etc.)

Phil Weber at 2007-11-11 17:30:42 >

# 5 Re: MS access - clearing

The code I am using is as follows

UPDATE table1 SET PoS_scan = "0"

I am not getting any error codes or anything do I need to link it to the data1 control unit before I run the command?

Drew_gable at 2007-11-11 17:31:41 >

# 6 Re: MS access - clearing

Post more of your code. We can't tell if it's a syntax error or WHAT with that little piece of code!

Laurel at 2007-11-11 17:32:40 >

# 7 Re: MS access - clearing

it's ok guys I have found a quicker way too re set my figures :o)

Drew_gable at 2007-11-11 17:33:43 >

This is a Technology portal site for all the developer, It's a community, here you can post your question when you are learning, working, and soso...we'll make it better than yesterday Everyday...

MS access - clearing

Developer Tech

All Classified

Developer Tech New Topic

Developer Tech Hot Topic