Auto Select Records - Microsoft Access / VBA

Troy

Hello

I have a macro that opens up a table. I am wanting to delecte all
records from this table and then close the table. I do not want to
delete the table just all contents then close it. I have tried a few
different ways to delete all the records automatically but it does not
work.

Anybody know how to edit the macro to automatically select all the rows
of records and delete them then close the table?

Thank you

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #1

Subscribe Post Reply

1438

Danny J. Lesandrini

Try this in code ...

CurrentDB.Execute "DELETE FROM tblMyTable"

Just make sure you really want to delete them. This will do it!
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Troy" <an*******@devdex.com> wrote ...

Hello

I have a macro that opens up a table. I am wanting to delecte all
records from this table and then close the table. I do not want to
delete the table just all contents then close it. I have tried a few
different ways to delete all the records automatically but it does not
work.

Anybody know how to edit the macro to automatically select all the rows
of records and delete them then close the table?

Thank you

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

Similar topics

Auto Increment Problem with Dataset

by: Bruce Stockwell | last post by:

the setup: Webservice/WinClient application/SQL server. VS.Net (visual basic) winform wizard creates a simple form with load cancel cancelall and datagrid bound to a simple Dataset with one...

.NET Framework

What to do with AUTO-ID column when I add a new record to the data

by: Alpha | last post by:

I retrieve a table with only 2 columns. One is a auto-generated primary key column and the 2nd is a string. When I add a new row to the dataset to be updated back to the database. What should I...

C# / C Sharp

Auto-generate recently visited record-list

by: AA Arens | last post by:

Hi, I have a database with 2 main forms. Contacts and companies. I share the base with two others via LAN. On the companies form I have buttons to navigate throught the records (>400). We are...

Microsoft Access / VBA

HELP WITH AUTO EXE PROGRAMMING/CODE

by: Liam.M | last post by:

Hey guys, Forgive me if my question my be alittle silly, but I would very much appreciate and assistance that could be given! My situation is as follows: I have created a Button, and set...

Microsoft Access / VBA

reading auto increment number before it is written?

by: x0054 | last post by:

Ok, this is a stupid problem, I admit. I have a scrip that adds records to a table. The records are for photos. So, after adding a record the scrip also uploads a picture from users computer and...

PHP

Auto Number mysql

by: S.Dickson | last post by:

I had an access database that i use as an ordering system. I have a form for entering customer details. When i add a new customer on the form the customer number is an auto number that appears when...

MySQL Database

Auto Populate Based on fields from another table

by: joshua.nicholes | last post by:

I have an access database that consists of two tables.A data collection table and a species list table. The data collection table has about 1500 records in it and the species list has about 600....

Microsoft Access / VBA

Auto-increment field not letting me insert multiple records at once

by: chumlyumly | last post by:

Hello scripters - OS: Mac OSX Language: PHP w/ MySQL database I've created an insert page where a user inputs his info, which then goes to four different tables in a MySQL database. The...

PHP

Auto-populate second table based on combobox selection

by: Ronald | last post by:

I hope somebody can help. I can't get into the specifics of my project, but I'll try to create a simple example: tblVehicle * VIN (text box) * Make (text box) * Model (text box) frmRepair

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General