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
|
|||
|
|||
adding a reference to the table
Hello,
I have several tables of data in my access database and they are from different sources. How can I keep a reference or track or add a note to the table for identifying the source? Is there any way this can be done in access! Thanks for any help. talktobatchu. |
#2
|
|||
|
|||
Is there any reason you can't add a field to the table that would hold a
text string or other value that would identify the source of the data record? You could populate that field whenever a new record is added to the table. -- Ken Snell MS ACCESS MVP "talktobatchu" wrote in message ... Hello, I have several tables of data in my access database and they are from different sources. How can I keep a reference or track or add a note to the table for identifying the source? Is there any way this can be done in access! Thanks for any help. talktobatchu. |
#3
|
|||
|
|||
It is inbuilt in Access!
If you hover the mouse on the Table name in the Tables tab of the Database Containers window, the Connection String (the source) will appear for the Table looking like a ToolTip. Alternatively, in code: CurrentDb.TableDefs("TableName").Connect will give you the Connection String. If you really want to (after the above), you can right-click on the Table then select Properties and you can type your note in the Description box. -- HTH Van T. Dinh MVP (Access) "talktobatchu" wrote in message ... Hello, I have several tables of data in my access database and they are from different sources. How can I keep a reference or track or add a note to the table for identifying the source? Is there any way this can be done in access! Thanks for any help. talktobatchu. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |