Is There A Way To See The Links Between All Tables, Queries, Reports?

May 20, 2005

I was recently doing a little Spring Cleaning in my database and deleting old tables and queries that were no longer used or had been for experimental purposes. Unfortunately, I unknowingly deleted a query that was being used by a report I still needed and it took me several hours to find and correct the problem.

Not wanting to repeat this mistake, I began searching for a way to display my reports, queries, and tables and all the objects each is linked to. I thought it would be nice, for instance, to have a hard copy list of all my queries that showed where they are derived from and what other objects reference them. Is there a way to do this?

I've tried using the "Relationships" button and working with the Documenter, but I haven't found what I'm looking for. I have also tried a Google search, but, admittedly, I may not be using the proper terminology to get good results.

Thanks for your time.

View Replies


ADVERTISEMENT

Queries Using Tables W/o Links

Feb 20, 2008

I have a query where I am trying to set the where criteria expression using an unlinked table. The unlinked table name is INV DATES. The criteria field is [THE_DATE]. I cannot really link the fields for the two tables since I am using an expression. This design works, but it goes really slow.

Any ideas?

SELECT DISTINCT DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER, DSSAPP_FULL_WIP_PROD_STATS.OPERATION, DSSAPP_FULL_WIP_PROD_STATS.OPERATION_START_TIME, DSSAPP_FULL_WIP_PROD_STATS.OPERATION_END_TIME, DSSAPP_FULL_WIP_PROD_STATS.CURRENT_QUANTITY AS QUANTITY, DSSAPP_FULL_WIP_PROD_STATS.CURRENT_QUANTITY_TIME AS [DATE], DSSAPP_FULL_WIP_PROD_STATS.LOT_HOLD_FLAG, DSSAPP_FULL_WIP_PROD_STATS.ACTIVE_FLAG, [INV DATES].THE_DATE, [INV DATES].WEEK_NUMBER_IN_YEAR, [INV DATES].MONTH_NUMBER_IN_YEAR INTO ROXES
FROM DSSAPP_FULL_WIP_PROD_STATS, [INV DATES]
WHERE (((DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R1*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R2*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R4*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "R5*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "RR" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B0*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B1*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B2*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B5*" Or (DSSAPP_FULL_WIP_PROD_STATS.LOT_NUMBER) Like "B4*") AND ((DSSAPP_FULL_WIP_PROD_STATS.OPERATION_START_TIME)<=[INV DATES]![THE_DATE]) AND ((DSSAPP_FULL_WIP_PROD_STATS.OPERATION_END_TIME)>[INV DATES]![THE_DATE] Or (DSSAPP_FULL_WIP_PROD_STATS.OPERATION_END_TIME) Is Null) AND ((DSSAPP_FULL_WIP_PROD_STATS.CURRENT_QUANTITY_TIME )>=Now()-600) AND ((DSSAPP_FULL_WIP_PROD_STATS.FACILITY)="STPPRD" Or (DSSAPP_FULL_WIP_PROD_STATS.FACILITY)="EPIPRD"))
ORDER BY DSSAPP_FULL_WIP_PROD_STATS.OPERATION;

View 1 Replies View Related

Reports :: Insert Pictures In Reports From Links

Jan 13, 2014

I am creating a database that people can upload links to pictures within the database. (I do not want them to upload the pictures themselves because I am afraid the data will get to large - or am I misunderstanding how pictures are added to a database in access?) Now I want to be able to put those pictures in some reports.

Questions:
1) is it possible to insert a picture from a link (instead of an attached picture)?
2) If not would it work if I uploaded the picture to the database?
3) Am I incorrect about the way access deals with uploaded pictures? Does it just save a link or does it actually upload a picture into the database making it that much larger?

View 1 Replies View Related

How Do I Make A List Of Links To My Reports?

Jul 5, 2006

I am using 97 and have been running into problems with tutorials from microsoft since they are in 2000 format. Its not a big difference so maybe I just cant figure it out...

Anyways, I wanted to make a list of the reports I had for the user to click on one and have it pop up. Anyone know how I can make this list?

My idea is to somehow create the names in the list box using a query or something and have them be links to the report somehow...

Please help...Thanks :)

View 14 Replies View Related

Tables :: Establish Tables And Proper Joins - Links

Sep 19, 2013

I have a PATIENT TABLE with PAT_ID Autonumber / Primary Key.I want to set up an Invoice and a Receipt. I know the fields I need. how many tables I should create and how they should be linked PROPERLY.

INVOICE TABLE would contain (field names and data type):
Invoice_ID Autonumber / Primary Key
PAT_ID Number (as the link to the Patient Table)
Invoice_Date Date/Time
Invoice_ Contact Text
Invoice_SentDate Date/Time
Invoice_Paid Date/Time
Invoice_Comments Memo (not to be printed on invoice just info for me)

[code]...

Note: The rest of the fields needed on the receipt are in the Patient table (i.e. services rendered to). For the receipt, the description of the service(s) will be limited to a standard text that will be set in a label on the report.

View 4 Replies View Related

Reports :: Print Out Single Page Reports (or Forms) To Show Detail From Several Tables And Queries

Apr 21, 2014

I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have developed queries that return the most up to date height, weight, 40 time etc., and that single most up to date number is what should print, not the entire table. When I try to build a report it will let me bring in multiple tables, but not queries.

View 2 Replies View Related

Photo Links In Tables

Mar 5, 2008

I have recently learned how to link photos to a database using a form and a table listing the path to each photo. Is there anyway to format the records in the table so that when you click on the path the photo shows up?

I have browsed around past threads and have not found and answer.

Thanks

View 5 Replies View Related

Creating Links In Tables

Dec 2, 2004

Hi all.

As i'm still what can be called a "newbie" in MS Access, maybe one of you wizards
can help me out with this.

I'm having a product table in ms access, containing a few columns. The regular stuff (type, ID, ..).
It also contains a column i want to store the links to their documentation to, called "download'.

The fields of that table are loaded into a data access page.

Now the data access page is loaded into the frame of an HTML page. Everything works well, but when it
comes to the download-field, i get no link, but a piece of code instead.

Now these links are relative links (not absolute ones). What i'm searching for (for quiete some time now), is a way to make the links show as normal links.

Is there anyone who could give me a hint or who can help me out with this?

Thank you very much in advance,

Kind regards

View 8 Replies View Related

Relative Links For Linked Tables

Jan 6, 2006

Hi,

I'm buliding an access system in which the forms and tables stored in seperate databases as such:

forms: \serverdirmyDatabase.mdb
tables: \serverdirdatamyTables.mdb

myDatabase has a load of linked tables from myTables. Problem; my network drives are mapped differently from the users, so the links do not work for me.

So - does anyone know how I can set up a relative link, so myDatabase looks for datamyTables? i.e. it looks from the source directory rather than checking the whole path back to the root?

Hope this is making sense . . .

Dave

View 2 Replies View Related

Do Links To External Tables Ever Get Dropped?

May 22, 2007

Once external tables have been linked to a database can the links ever get dropped accidentally.

ie should I test for missing links and recreate them programatically or assume that it will never happen?

It is easy enough to identify links which are present but any code which loops through the tabledefs will only identify links which are present.

I think the best approach, if this is necessary, would be to count the number of external links, compare the answer to what it should be, and refresh all the links if theree is a difference.

View 3 Replies View Related

Is There Any Way To Change (in Bulk) The Links For Linked Tables

Mar 14, 2008

I have heaps of Linked Tables and the main data bases are in My Documents.

My Documents is also the shared name but I need to change it to MyDocuments as the space fouls up some other stuff.

I have a feeling I will need to delete all the linked tables and do it again.:D

View 1 Replies View Related

Storing Links To Images In MS Access Tables

Sep 24, 2004

I have an application in MS Access that contains some forms and reports. I want to be able to show pictures on the forms. So I am saving images on file system and storing links to those images in MS Access tables so that they can be retrieved and be shown on the forms. Can someone throw light on the effects of this approach on performance of the application (especially vis-a-vis the approach of storing images in the Access tables as OLE objects)?

Would appreciate if responses can be directed to my email-id Satya_Nadiminti@infosys.com

Thanks,
Satya

View 1 Replies View Related

Tables :: Connecting Refreshing Links Between Databases

Feb 13, 2015

I have a club member registration application consisting of a program database and a data database. They reside in the same directory. There is an autoexec macro which runs at the beginning. This macro has to find the DATAdb and make sure that the required tables are linked (Not all tables). If it cannot find the DATAdb and then has to make a call to the user to use a different procedure.

Now to find the DATAdb I have used the following code that works. The function GetPathAndName parses the string db.name and outputs the path and name of the PROGdb. Up to here no problems.

Code:
GetPathAndName db.Name, FrontPath, dName

Then I use the following code to get the fullpath of the last database used and thereby find the path and name of the last DATAdb. The path of PROGdb is used in place of the existing path of DATAdb to check whether the file exists.

Code:
Dim rs As Recordset, cPath As String, cName As String
Set rs = CurrentDb.OpenRecordset("SELECT Database, Type " & _
"FROM MSysObjects " & _
"WHERE ((MsysObjects.Type) = 6) AND ((MsysObjects.Name) = 'MembersTbl') " & _
"ORDER BY MsysObjects.DateUpdate DESC;")

[Code] .....

As the final step I use the table definitions to refresh links that already exist and connect tables that are not linked The code is below. But I can not get it to work. It links 7 tables instead of 16 and when tested in different folder says invalid operation and so on. There is fundamental error some place but I could not figure it out.

Code:
On Error GoTo Error_Linking
Debug.Print "TableDefs.Count="; db.TableDefs.Count
For I = 0 To db.TableDefs.Count - 1
Debug.Print "TableDefs("; I; ").Connect="; db.TableDefs(I).Connect
Debug.Print "TableDefs("; I; ").Name="; db.TableDefs(I).Name

[Code] .....

View 7 Replies View Related

Code To Link Tables - Overwrite Specific Links

Oct 13, 2006

I searched and couldn't find anything on this specific issue.

I'm on the verge of designing a pretty big database and I've run into what may become a bit of a problem. There will probably be several backends in different locations. Should another backend ever be created or if the location for one changes, the user can use a form to refresh the links to the tables on that specific database.

The way I've done this so far is by having a piece of code that checks the tables for a connection string. If the table has a connection string, its a linked table, so the link gets deleted and replaced with the new link. Well this will no long work since there will be several backends and only 1 of them may need its tables relinked and using that code will delete all the table links, including the good ones.

Is there a way to make 'DoCmd.TransferDatabase' overwrite table names instead of giving the duplicate tables a number suffix? I think that doing this would be easier than retrieving the table names from the new backend and comparing them with the linked table names in the frontend so the old links could then be deleted.

View 1 Replies View Related

Tables :: Code To Refresh Sharepoint List Links?

Oct 29, 2012

I found 2 examples of code to refresh my attached table link to sharepoint lists.

I have a scheduled task open my Access 2010 db and an autoexec macro runs and closes the db.

My problem is my tables disconnect from sharepoint 2010 and the update fails.

I added the code I found to a module and added a line in my macro to run the code. Now I cannot get the code to work.

Am I at least on the right track? I just want to know before I spend many hours getting this code to work.

These are the two locations of code I found.

[URL]

I think part of my problem is that I have a regular table that I add a txt file to that is not linked to sharepoint so I need to exclude it from the code.

View 4 Replies View Related

Locating A Backend And Automatically Creating The Links For Link Tables

Aug 25, 2006

Is there a way to just select like through a find dialog box, the location of a databases backend location and just automatically create all the links for the link tables...

The reason Im asking, is my boss wants the database to be on his laptop in the event that the network is down, and also so that he can work away from the company's location but I was showing him the implications of having it installed locally on his machine should his laptop go down....

So now I'm wondering if i could

1. do some automation that allows him to just choose the location of the databases backend that he would be working from, be it on the network or on his machine

and


2. using both backends to update or overwrite each other depending on which he was working from or did updates to..


Really would love all the help and input I can get on this... Im willing to work on developing a sample for this if nothing is exactly already out there so that it can be reposted cause i think this would be very useful to everyone's database applications.

View 1 Replies View Related

General :: How To Create Forms In Access DB Which Uses Links From Source Files As Its Tables

Sep 7, 2012

I have a client who needs a Database created in Access for him. he would like to regularly auto-populate this Access DB from an Excel file - like twice a week.In addition, he wants me to create Forms, Queries, reports and Macros for him in the Access, which will have 2 Tables from Excel files and about 3 Tables created in Access.I figured that I could do that if I gave him a link to the Tables he needed from the Excel file(s). But how do I work remotely for him- the path to those files is on his computer. I can load them to mine, but then he can't open the files.How can I create Forms etc. in an Access DB which uses links from source files as its Tables?

View 2 Replies View Related

Reports And Queries Not Getting Data From Tables

Jun 17, 2005

Hi all,

I'm trying to create a database to track all the students details, I've created the data base with all the tables, relationship etc. i tested it with dummy data too and it worked fine.

I then imported the proper data from a .csv file, using the "File-Get External Data-Import" method rather than a macro, it imports the data with a couple of errors but the data still got through, i had previously created queries and reports and they worked fine with the dummy data but will not show any of the new imported data, its like it hasn't got a link or something but if i create a linked form, it will pick up the data, meaning the relationships are working. hence my problem

Thanks

Dellero

View 2 Replies View Related

Tables, Queries, Forms, Reports And Modules Have Disappeared

May 24, 2006

Good morning All.

I have a database which updates via a Function in a module every morning (i.e imports and exports data).

Yesterday the DB crashed and incurred a problem. The DB was closed down and re-opened.

When it was re-opened all the Tables, Queries, Forms, Reports and Modules were no longer showing in the DB window.

When I selected the Tables tab the following message appeared:

Operation Invalid Without Current Index

this was then followed by another message:

"Isn't an index in this table. Look in the indexes collection of the TableDef object to determine the valid index names

This also appears if I try selecting the other tabs i.e. Queries, Modules etc.

The strange thing is the DB still updates at its stipulated time, and still imports and exports data. I am running Access 97.

Does anybody have any idea of how I can sort this out?

Regards

Chathag :confused:

View 1 Replies View Related

General :: Naming Of Tables / Queries / Forms And Reports For Identification

Sep 22, 2013

Is there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?

View 1 Replies View Related

Reports :: Summing Calculated Fields On Reports And Tables To Include Cents?

Feb 18, 2014

In my tables i have used calculated fields. one of the fields is to "total expenses." In a report, i need to show the sum of all the "total expenses", the filed populates in the report but the cents are missing. for example if the amount is 6080.40 it shows as 6080. how can i get around this? I have tried changing the decimal point value to 2 at which point the value turns to 6080.00 when it should be 6080.40 (i am a beginner at this i am assuming the answer will probably involve c++ or visual basic's, two concepts i am not familiar with.)

View 2 Replies View Related

Odbc Links

Mar 18, 2008

sorry if thi9s is the wrong place but I thought I would try somewhere.

I would like to create links to table trough an odbc link.

whta I have is an estimation programme that creates 4 tables in a directory/folder each time you create a new estimate I have an odbc link that points to the given folder where the tables are being created. What I would like to do is to search this folder and link specific tables to my database which is a contract control programme. the tabels are given unique name for each estimate example names are: 0001_assembly, 0001_data, 0001_increment, 0001_system

so to sum up is it possible to create a lnk to these tables on the fly. any one got any ideas and possible codes samples for doing this.

Thanks

View 10 Replies View Related

Fuzzy Links Possible?

Aug 22, 2006

Hi all,

I've got two vast tables of data which I need to link, however the field unique to each was, at it's source, a typed field, and as such both have errors, typos, formatting problems, known deviations etc.

An example would be something like this:

Table1: SFOC0912JB3
Table2: F0CO9I2JB3

(These are harware serial numbers for what it's worth). I could do with creating a link between the two tables which would return a true based on a number of possibilities, such as:
Match if:
- String matches with prepended 'S', 'C' and/or
- String matches with substituted 'I' and '1' in any or all positions and/or
- String matches with substituted 'O' and '0' and/or
etc.

I think Levenshtein had the right answer from what I've been reading, but I haven't yet found an implementation for access (freely) available.

Any ideas?

Thanks,
Alex

View 1 Replies View Related

Button Links

Feb 21, 2005

i have constructed a switchboard/main menu and have set up buttons which link to forms. i have also made a 'return to main menu' button which does as it says, the only problem is that after going back to the main menu both forms are now open...any ideas on how to stop this problem

View 4 Replies View Related

Access/Excel Links

Dec 20, 2005

Hi,

I would like to set up a form in Access that accepts the input of an Excel spreadsheet file (browse for file) and then creates a pivot table on one of the sheets, and appends that data to an Access database table..

can you give me some ideas on how i should approach the problem?

Many thanks :)

View 1 Replies View Related

Removing Table Links

Mar 2, 2007

This may seem like a silly question, but I can’t find the answer to it on this forum. People only say 'Remove the table links' but never how. I can’t seem to be able to remove the table links completely, so I only have one database file (no backend or frontend). I can’t seem to do it though the Table link manager or any other way. Any help?

Thanks in advance

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved