Question about my recipe database

[monks89]

Hi, I'm trying to put my quantity of ingredient, ingredients, and comments on a report. Also, how do I make it so I don't have repeating entries in my report (it seems that for every ingredient in the recipe, the report is making a separate entry of the identical recipe)? I'm trying to make it so I have one recipe per page and to move between recipes would require clicking of the |> button or manual insertion of the page number.

I've hosted the file online to make it easy -> Hosted Database

Thanks

 

[MSAccessRookie]

Hi, I'm trying to put my quantity of ingredient, ingredients, and comments on a report. Also, how do I make it so I don't have repeating entries in my report (it seems that for every ingredient in the recipe, the report is making a separate entry of the identical recipe)? I'm trying to make it so I have one recipe per page and to move between recipes would require clicking of the |> button or manual insertion of the page number.

I've hosted the file online to make it easy -> Hosted Database

Thanks

I do not have Access 2007 here at work, but your problem sounds like it could be related to the Join in the query that the Report is based on. If you could post that query, I could try to assist.

 

[monks89]

Right now it's not based on any query.....should it be?

 

[MSAccessRookie]

Right now it's not based on any query.....should it be?

If it is based on a single table that should not happen. I assumed that it was based on 2 or more tables that were joined together to allow access to the information.

 

[monks89]

I have 3 tables.....Here's a link to some printscreens -> http://www.mediafire.com/?sharekey=0ad336f308b73c9b0f83d91f6dff7c38e04e75f6e8ebb871

Thanks

 

[Simon_MT]

On your report Sort on RecipeID with a Header/Footer.

Put the RecipeID and Recipe Title on this Header.

In the Detail put the Qty and Ingredient.

Simon

 

[Simon_MT]

Have a look at this change what you want. I've removed the images, all you want is Query1 and Report 1. It would be better to use jpeg images and larger if possible.

Simon

 

[monks89]

I tried to do that and it gave me some ole object error message.....not sure the exact wording. Thanks for the file and your help.

 

[Simon_MT]

Well, it is the first time I've tried inserting an image into a database, and it is still crap.

I have some scripts to load an image and do it properly, so can you give me the image for the first couple of recipes, decent size if you got them.

Simon

 

[monks89]

Ok....I've attached 5. Thanks

 

[Simon_MT]

You will need to modify the Module1 and specify where the Images are held.

Function GetImageDir() As String
    GetImageDir = "C:\Databases\Images\"
End Function

I changed the report and added comments and a Page per Recipe on the Group / Sort.

This works with Report Preview.

Simon

 

[monks89]

Got it......thanks for everything.

 

[Simon_MT]

My pleasure,

You could do with bigger images as they are small and enlarging them makes them pixelate.

Simon