Replies

Just prior to the exit sub I would add

    txtCertainField.SetFocus

to take the user to the incomplete field.

Put this in the Field Line of the query and change

Gabi,

Use a Shift /Click to select and deselect various controls. You can also Shift/Drag to select controls. The properties that they share will be available for update.

Is the third one Object Oriented Programming ?

You are an exceptional artist. Your rendition of a polar bear eating a marshmallow in a blizzard is wonderful!

As you drag a file, watch for the

I did something like this before. To open the new form using the contents of a text box as the link criteria, add something like this to the text box

vbProperCase will turn names like McDonald into Mcdonald. This code allows the user to correct the automatic updates.

Add a modular level Boolean variable like LNfix (last name fix) and use this code.

Private Sub LaseName_AfterUpdate() 
    If LNfix = False Then
        LastName = StrConv(LastName, vbProperCase)
        LNfix = True
    End If    
End Sub

If you enjoyed this you will like the work of Bev Doolittle. Her primary subject matter is of American Indians and woodland nature scenes. She

So much has changed that; nothing that was easy in VB6 or VBA is easy in .net

Sorry I about the delayed response. I attached the code and an explanation.

That was a tricky one. Try this:

Leave the field in the page footer and set the visible property to false. In the Page Footer OnFormat event, enter this code where Text1 is the name of your field. The intelisense does not work, you will have to type in the ‘.visible’

If Me.Page = Me.Pages Then
Text1.Visible = True
End If

Page is the current page number and Pages is the total. When they are equal you are on the last one.

When you say page total do you mean page footer? If not click View|Page Header/Footer, in design mode. The grouping bar will be above the Report Footer but will print below it on each page. To move a field higher on the page make the blank space below in larger. It will give you less detail area.

Hope this helps.

There are as many recipes for fruit pizza as there are cooks. Let you imagination be your guide. Basically it is as follows.

1. The crust (precooked and cooled) is usually some type of sugar cookie dough (vanilla or chocolate) or tart crust.
2. My favorite sauce is the fruit dip; my best friend mixes 8 oz of softened cream cheese with 2 cups powered sugar.
3. Top this with your favorite sliced fruits. You can mix it together like a regular pizza or artfully arrange it.

Another favorite in this area is vegetable pizza.
1. Press out canned croissants or any other flaky pastry for the crust, cook it and let it cool.
2. The sauce is any type of ranch, dill or other dip or salad dressing. It is usually a good idea to cut the pizza at this point because it is hard to cut through the
veggies.
3. Top with your favorite sliced raw vegetables.

Both are served chilled.

The marshmallow cream is put out by Kraft and is usually near the marshmallows or with the baking supplies. It is probably the same thing as the Fluff. Very sticky and tastes like marshmallows. The cream cheese and sour cream make it rich. Funny, I never heard of Fluff before last Saturday while comparing recipes with a friend, not from Texas. I am sure you can use what ever is available. The original recipe called for 8 oz of the Marshmallow/Fluff stuff. Kraft sells it in 7 oz jars.