Search results for query: *

Thanks for the Help I will have to try that i ended up making a query for the location of the image and then rerunning the query every time I change the image to be printed. A little more complicated probably but the best I could figure out. Thanks again Walt III SAElukewl@netscape.net

I have an Image in a report, and I want to change the image in the report from a form. I have a drop down list of locaions of images to choose from. based upon the users choice I want to change the report. i.e. the properties ("Picture") C:\image\image1 to C:\image\image2 Thanks Walt III...

In My experience it has always been easier to enter the full date and round to the begining of the month if the day is not important and then format the field to display the relevent data. for instance you want to wee MM/ YY I would enter MM/01/YY for the date each time. and then format it to...

check to make sure that your list box is returning only the letter that is selected and not more, and that there is no space between the quote and the asterisks. those are simple problems but Otherwise Golom's should work. Walt III SAElukewl@netscape.net

Thanks PH That was exactly what I was looking for. here is the syntax for the design veiw Column_Name: Year(table.Date) Walt III SAElukewl@netscape.net

I have a standard 8.5 X 11 page if I have three songs the first w/ 3 lines the second w/ 10 lines the third w/ 12 lines this forces the 3rd song onto a new page and leaves a lot of extra space at the bottom of the page. I want to take this space and divide it evenly between the top of the page...

I have a date field that I want to limit to the year. I format the field in the table. however when I access that table through a query the format reverts back to the typical month day and year format. I want to limit the data by years. Thanks Walt III Walt III SAElukewl@netscape.net

I have a database that is a listing of songs, I want to do a printout of the songs in a certain order, this causes the spacing to come out weird. I would like to take the extra space and divide it evenly between the page, instead of it all being at the bottom of the page. Walt III...

You could try making a copy of the database and then try converting the copy over. Maybe even take all of the security off of the copy and see if that will work. Walt III SAElukewl@netscape.net

when I try to declare the database variable DB to work inside a sub for a button I can not get a "database" variable it tells me: "User-defined type not defined" this is the line that I have -dim DB as Database- I have used the line before without any problems. Thanks for the help in...

Thanks Bob That worked perfectly I was even able to combine that with another field and eliminate some more redundant fields in a printout. =[field1] & " " & [field1] & IIf(Not IsNull([Field1]) And Not IsNull([field2])," & ","") & [field2] Walt III SAElukewl@netscape.net

I have a textbox in a report that currently has two fields from a query as the control source =[field1] & " and " & [field2] this works well except that sometimes field1 is empty and sometimes field2 is empty. How can I fix this report so that if both field's are populated then it adds the and...

So your saying that in order to make a variable "textarea" I would have to have it as a label. And that i have to do it from a form after I give the focus to the "textarea"/label in the report Walt III SAElukewl@netscape.net

I try the code that you gave with a few adjustments to fit my work. and I get the following error "Object Required" on this line TextBox.Text1 = "La La La" Walt III SAElukewl@netscape.net

Because I am the administrator of the table I know how it is setup. so I do usually handle errors, in this I am using the primary key to the table so if there were an error the data would have to be corrupted. Thanks Walt III SAElukewl@netscape.net

Escellent Code. the bookmark was exactly the help I was looking for. Nice signiture by the way. Thanks Walt III SAElukewl@netscape.net

I want to go to a specific, chosen by user, in one form from another. and I don't want to put a filter on the form and eliminate the other records from view. I would also like to do this without writing a small loop with if statements. basically I am looking for a "GoTo" command that allows...

I do not believe that it is possible to add a button to a report because it is a printout. Usually actions that are done with buttons are done from forms that then connect to a report. What are you trying to accomplish? there might be another way to do it. Walt III SAElukewl@netscape.net

If I understand your dilema correctly. In the report I would go to the sorting and grouping tab and set the first sorting/grouping to be wether it is a left-over or not then sort by date. and go from there. Walt III SAElukewl@netscape.net

I have a report that links to a report preview. I want to change one of the text labels in the report based upon a selected choice in the Form. Walt III SAElukewl@netscape.net