Recent content by Rickster57

report Here is your database with the correction. Just change the image's data to a picture on your computer in design view

object me.myimage refers to the name of the control you placed in the report. Right click on that image object you inserted in the report. Go to properties>Other. That is the name you must use.

report Incorrect. Remove the code you have in the On Print. Click on the 3 dots to the right. Then paste that code in there.

report In that report in design view drop an image control into the detail section of your report next to your textbox called photo. In the On Print event of your detail section try this code: If Not IsNull(Me.MyImage) Then Me.MyImage.Picture = Me.photo

reports Make sure that in the properties of that report in design mode that the Auto Rezise is set to no and auto center is set to yes.

option the option value = -1 for true and zero for false. OOPs, I'm thinking of a checkbox. Sorry about that.

date Use the DateDiff function

page up See if this helps. I've used this code and it works just fine. See this link. http://support.microsoft.com/kb/132031

irritating Unbound labels in 2003 do this (irritant). The only way I found around this is for any unbound label I had to make a textbox and set it's data to "Mylabel" or whatever. I assume you have 2003 as 2000 did not do this.

email Check this link out. Hope this helps you. http://www.thescripts.com/forum/thread189759.html

forms In design view of that form click in the After Update property of the [myfieldname] textbox. You will then see a down arrow to the far right. Click on that and click on Event Procedure. You will see a button to the far right with dots on it. Click on that and then paste CEH's code in there.

no window If you close out of Access completely, come back in and open another database (mdb)does the same thing happen?

new form If those "empty fields" on your form have it's data control source set to one of the corresponding fields of that form's data record source (such as a table or query)there should not be an issue. If that is not clear you may want to post your db, if that is possible.

Words of wisdom Moniker, Very well put. To be honest I don't respond to too many of these posts because a very LARGE percentage of the topics have been answered time and time again. A simple search of this forum, a little leg work, and time would allow many of these questions to be solved by...

product name Did you try changing your textbox in that report to a combo box and use the appropriate source? I'm guessing you have the id and name in the table.Use that table as it's source using and column count of 2, column width of 0;2.