How do I set up and use Access Recipe program?

[Recipe questions]

I can enter my recipe's but cannot pull them up in any of the catagories.
i.e. I want to pull up only dessert recipe's.

 

[Jeanette Cunningham]

Hi,
I haven't heard of the Access Recipe program.
Would you post back some details about it.

Such as:
did you create this program?
is it a free template?
is it shareware?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Create a query using the Recipes table and the Food Categories table.
Sort by the RecipeName column.
Save this query with the name Search.
Use this query to build a continuous form that shows recipe names.
You can hide the fields for RecipeID and FoodCategoryID.

Open the new form in design view and put a combo in the header.
Name the combo as cboFind
Give it 2 columns, make the first column hidden.
Use a query based on the Food Categories table for the row source of the
combo.
Put the FoodCategoryID as the first column of the query.

On the After Update event of the combo, put code like this

If Len(Me.cboFind) >0 Then
With Me.RecordsetClone
.FindFirst "[FoodCategoryID] = " & Me.cboFind
If Not .NoMatch Then
.Bookmark = Me.Bookmar,
End If
End With
End If

Post back if there is not enough detail in the above.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Watch out for the typo on the 6th line from the end, at the end of the line.
Replace the comma with the letter k.


Line with typo -->
..Bookmark = Me.Bookmar,

It should be -->
..Bookmark = Me.Bookmark


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Create a query using the Recipes table and the Food Categories table.
Sort by the RecipeName column.
Save this query with the name Search.
Use this query to build a continuous form that shows recipe names.
You can hide the fields for RecipeID and FoodCategoryID.

Open the new form in design view and put a combo in the header.
Name the combo as cboFind
Give it 2 columns, make the first column hidden.
Use a query based on the Food Categories table for the row source of the
combo.
Put the FoodCategoryID as the first column of the query.

On the After Update event of the combo, put code like this

If Len(Me.cboFind) >0 Then
With Me.RecordsetClone
.FindFirst "[FoodCategoryID] = " & Me.cboFind
If Not .NoMatch Then
.Bookmark = Me.Bookmar,
End If
End With
End If

Post back if there is not enough detail in the above.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I can enter my recipe's but cannot pull them up in any of the catagories.
i.e. I want to pull up only dessert recipe's.