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
I'm trying to create a many to many table (which I know how to do). But this is a little complicated.
I have several photos that are part of my database, so I have them in their own table which contains:
ID
CallName
PhotoType
Source
Computer Link (to where photos are stored on my hard drive)
The photo type comes from another table, one of the types is People.
So I want to have a many to many table so I can connect people photos to places where they live. That's pretty easy, you just put foreign keys for the photo CallName and for the Place Name.
However, I want the person's photo to show up also (in a container I will put on the form). In order to do this, I need to have a field for computer link that is automatically populated based on which Photo Call Name I choose. Can you do that in a many to many form? How?
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.
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;
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
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.
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
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.
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
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
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] .....
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.
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.
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.
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 RelatedHi everybody,
Recently I created a database for staff details in my company and I used OLE Object in Data type to make it. The problem now there are more than 500 employees in the company so it is very difficult to scan one by one photo. Is there any way that once I click on command button photo will be detected from scanner and saved directly in the field instead of doing it manually.
Thanks and regards
Hi there, this is my first post, hopefully not too many more problems i will encounter whilst designing my database.Anyway I am trying to add some fotos to each of my records, but not having as much luck as i would like. In the tables, i have made the field OLE object. When i try to add the foto (about 97kb) jpg format, all it does is add a picture of the jpg icon on my field. If i double click on the icon my foto will open, but i wish to have the foto showing in my record. Anyone help me with any ideas? I am using access 2003
View 2 Replies View RelatedPlease help!
Does anyone know what command will allow Access to pull Dimensions from Explorer into a Query?
I wish to have a query that will illustrate the exact Dimension of an image file (Jpeg). This will enable me to filter all images which do not meet my internet standard of 100x100 dpi and/or 300x300 dpi.
Your help is much appreciated. :D
I have written a form from a table which holds employees details. This table has a photo field. The form has a control which displays the employee’s photo. It uses the field, photo as the control source.
This works okay but if you wish to enter a photo from the form you have to click on insert. Browse for the file etc.
The Sample database “Northwind” on the access help has a similar form, but under the photograph there are command buttons to add/change or remove the photo which is obviously a much more professional way of doing it.
I have looked at the properties of these control buttons and they seem to work through a visual basic program. As someone who has a very limited knowledge of VB is there a simpler way of doing this or would I be able to cut and paste the code to work on my form somehow (If Legal)
Any advice would be greatly appreciated.
Hi all, I have a form of contacts wich I would like to put a photo for every contact, I would like to have a "ADD" button on the form wich will add me a photo in JPG or BMP in a certain field on the form, the photo ar stored in a folder in c: I also would like to have a "DELETE" button!!!
Thanks to all
Marco
When you query Photo.name, you get a line for each photo name attached to a record
1 aunt sally a.jpg
1 aunt sally b.jpg
1 aunt sally c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob l.jpg
What I would like is to have it appear like this
1 aunt sally a.jpg; b.jpg; c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob L.jpg
Hi I have a Contact form with all the details of the contacts, I would like to add a photo for each contact, how can I get to this?
Marco
I have a log in form and combo box.
Just want to ask if possible to change photo depends on combo box value?
Here is the link of my database. [URL] ....
I have a text box that is Hyperlink to a directory that opens fine and gives me access to files that I need. What I want is to place a photo of a particular button I've found (in the form) and on the click event have the hyperlink in the text box activate and open the directory.
1. I can't change the shape of the text box or place a picture within it...
2. I can set the pictures control source as the hyperlink text box but that serves no purpose...
3. Making the text box transparent and all the text white then overlay-ed the picture ...
It worked but I would like the appropriate way to do this.....being at such a critical stage of my access development......
I need to add a persons photo to their employee record and don't know where to start.
View 11 Replies View RelatedI may be going about this all wrong but I have a text box that is Hyperlink to a directory that opens fine and gives me access to files that I need. What I want is to place a photo of a particular button I've found (in the form) and on the click event have the hyperlink in the text box activate and open the directory.
1. I can't change the shape of the text box or place a picture within it...
2. I can set the pictures control source as the hyperlink text box but that serves no purpose...
3. I lazy manned it buy making the text box transparent and all the text white then overlay-ed the picture ...it worked but I would like the appropriate way to do this.....being at such a critical stage of my access development......