Append to Table ..... KRISH

K

KRISH

Hi! everyone,
Please help how to append rows to table from vb code. Whenever i start
appending i want to delete old data & stop message box saying say "You are
deleting....". Actually I want to append each day during given from date and
todate as criteria. Please help how can i do this.
Thanks
Krish
 
O

Ofer

Try this

Docmd.SetWarnings False ' Turn off the messages
Docmd.RunSQL "DELETE TableName.* FROM TableName" 'Delete query
Docmd.RunSQL "INSERT INTO TableName1 SELECT TableName.* FROM TableName" '
Append Query
Docmd.SetWarnings True ' Turn on the messages

-
\\// Live Long and Prosper \\//
BS"D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Randam No...... KRISH 1
How to append running number 2
Data changes in append query 1
Please help... KRISH 7
Prob... please Help.... KRISH 0
Preventing duplicate entries with an Append Query 3
Append Query To Table 3

Top