Search results

I have Microsoft Windows and fax viewer which is set as my default program for viewing jpg/jpegs. It works perfectly when I click on a jpg/jpeg file. In addition there are other photo programs including Microsoft Image Composer and Camedia (an Olympus Photo Program). Both these programs show...

Thanks but this is where I got the idea from originally. In the Microsfot article it says: "RESOLUTION Use a different interpreter, such as Microsoft Photo Editor, to insert the object. To see an example of how to do so, follow these steps: " The Problem is that...

The original problem that I am trying to correct is that when I store a jpg image in a table within an ole field, only the icon of the jpg shows up in the form and not the image itself. From what I understand, the purpose of using "Create New" is to be able to set this field up so that Access...

Although I may switch to linking via paths, for now, I have a form based on a table with an ole object type field. Any jpg I put in the field or picture (on the form) is viewed as a jpg icon. I understand that the way to fix this is to right click in the table field and select "insert object "...

Thanks Neil, I was able to solve that problem as far as the query was concerned with a similar answer to yours. However, I am now running into a further problem when it comes to the report itself. Please see post entitled "Report based on Totals Query giving Problems" Thanks Mike

I have query based on 2 tables, Plants and Photos. In order to bring up only unique records from the Plant Table, I have created a Totals Query and in the 2 Query fields from the Photos Table I have the Total Row selceted to First. All other fields are from the Plant Table and are set to Group...

Thanks again Hay, I think we're getting closer but what I want to do is to just have just 1 of those 5 related records showing so that even though there are 5 records (photos) associated with that particular plant i only want one (any one) to show up. Mike

Thanks Haley No. I am looking to retreive records that are not duplicated because one Plant Record has more than one Photo Record related to it. The two tables are related and are part of the same query. However, I need at least one instance of the plant record to show up even though there may...

I have a report based on a query that includes 3 tables. "Plant" is one table and "Photos" are another.In some cases, there can be multiple photos per plant record.In the query that runs this report I have some records that are duplicated in that there may, in some cases, be mutiple photos...

As I already have done in a form, I am trying to create an unbound object frame in a report to show photos for specific records. The photos are linked to the picture frame by a photo path field in the record. I have done this for a similar Form but when I attempt to do this in the report I get...

Thanks Glynch, A few questions: Would the new Unique Field in the Plant Table be better off as a # or a # with a letter suffix? In the new Master Database would the Photo table be linked to the Plant table by this new "Unique Field" and WOULD THIS FIELD THEN have to be designated the Primary...

I have two tables, Plants and Photos in my database. I have an autonumber index ID field for each table. Photo records are linked to a specific plant record by the Plant ID # contained in a field in the photo record. I have data being gathered and entered on a computer in 2 remote location into...