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

mme



145 posts

Master Geek
+1 received by user: 1

Subscriber

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

Hi

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

Thanks

Create new topic
2483 posts

Uber Geek
+1 received by user: 4

Trusted

  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!

mme



145 posts

Master Geek
+1 received by user: 1

Subscriber

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

how would I do that?

168 posts

Master Geek
+1 received by user: 7


  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.


mme



145 posts

Master Geek
+1 received by user: 1

Subscriber

  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:



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.