|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2004, 08:39 AM
|
|||
|
|||
I need an explanation to a line in a code for a Data Dictionary
Im creating a data dictionary and have a line of code from the
CmdCreateDD_Click procedu DoCmd.RunSQL "delete tblDD.* from tblDD;" it works but I dont understand what the procedure is doing and why it is needed; why delete? Im using Access 2003 
|
|
#2
October 27th, 2004, 10:02 AM
|
|||
|
|||
|
"RedCentreLPlater" wrote in
message ... Im creating a data dictionary and have a line of code from the CmdCreateDD_Click procedu DoCmd.RunSQL "delete tblDD.* from tblDD;" it works but I dont understand what the procedure is doing and why it is needed; why delete? Im using Access 2003 The code deletes all the records from the table tblDD. As to why it should do this, I'm afraid that is a question for whoever designed the thing.
|
|
#3
October 27th, 2004, 10:05 AM
|
|||
|
|||
|
It's a Delete action query, deleting everything in table tblDD, most likely
in order to exclude duplication because next thing in the code the table is re-populated from scratch. HTH, Nikos "RedCentreLPlater" wrote in message ... Im creating a data dictionary and have a line of code from the CmdCreateDD_Click procedu DoCmd.RunSQL "delete tblDD.* from tblDD;" it works but I dont understand what the procedure is doing and why it is needed; why delete? Im using Access 2003
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Barcodes | TarponZeke | General Discussion | 4 | October 25th, 2004 08:04 PM |
| Barcode Scanner Input | NC Beach Bum | General Discussion | 3 | October 25th, 2004 04:15 PM |
| Is it possible to plot this kind of data in a (line) chart w/ preferred axis? How? | pgtr | General Discussion | 4 | September 15th, 2004 02:05 AM |
| Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
| How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Linear Mode
