Geekzone: technology news, blogs, forums
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


145 posts

Master Geek
+1 received by user: 1

Topic # 26953 8-Oct-2008 14:45
Send private message


Does anybody know how I would make a macro in access 2007 that deletes all data in a certain column in a certain table?


Create new topic
2483 posts

Uber Geek
+1 received by user: 4


  Reply # 169876 8-Oct-2008 14:57
Send private message

Make update query on that particular column.

Find me on Twitter!

I posted 1, 2 x 10^3 times!


145 posts

Master Geek
+1 received by user: 1

  Reply # 169896 8-Oct-2008 15:55
Send private message

how would I do that?


163 posts

Master Geek
+1 received by user: 5

  Reply # 169903 8-Oct-2008 16:17
Send private message

I'm using 2003, but I assume the same applies in 2007.

- Create a new macro.
- From the Action dropdown, select RunSQL.
- In the SQL Statement box enter:

UPDATE [TableName] SET [FieldName]=NULL;

- Save the macro.

Run the macro to delete the data from FieldName in TableName.


145 posts

Master Geek
+1 received by user: 1

  Reply # 169985 8-Oct-2008 21:00
Send private message

Thanks so much :D

All solved

Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:

Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:

Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:

News »

Stuff Pix enters streaming video market
Posted 21-Mar-2018 09:18

Windows no longer Microsoft’s main focus
Posted 13-Mar-2018 07:47

Why phone makers are obsessed with cameras
Posted 11-Mar-2018 12:25

New Zealand Adopts International Open Data Charter
Posted 3-Mar-2018 12:48

Shipments tumble as NZ phone upgrades slow
Posted 2-Mar-2018 11:48

Oppo R11s: high-end Android, budget price
Posted 27-Feb-2018 16:27

Samsung New Zealand introducing the Galaxy S9 and S9+
Posted 26-Feb-2018 07:00

Fujifilm X beats its best with new top of the range, high-performance camera
Posted 24-Feb-2018 14:05

One million kiwis affected by cybercrime
Posted 24-Feb-2018 13:58

New Zealanders want to engage with government online and via mobile apps
Posted 24-Feb-2018 13:56

Samsung launches Samsung Max
Posted 24-Feb-2018 13:52

CPTPP text and National Interest Analysis released for public scrutiny
Posted 21-Feb-2018 19:43

Foodstuffs to trial digitised shopping trolleys
Posted 21-Feb-2018 18:27

2018: The year of zero-login, smart cars & the biometrics of things
Posted 21-Feb-2018 18:25

Intel reimagines data centre storage with new 3D NAND SSDs
Posted 16-Feb-2018 15:21

Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.