Search results

Jack, Thanks for the response. I have a criteria in qbe of the record source of the second form coming from the text box of the first form. The first form does close so I guess I will have to pass the text over to the second form. I probably need help on openargs command please. Thanks...

I have a one field text form that has no record source that a user enters a case number. once the case number is entered the user presses enter and another form pops up for the user to enter personal info. If the case number is already in that table then existing info will already be there...

What I would do is create a form and on the form create several unbound text boxes, or how ever many criteria you want to enter. In the qbe of the field you want queried I would enter the related unbound text boxes as "or" expressions. This way you could enter several criteria at one time...

I have a image control on a form thats source points to the path of the folder where the picture is stored. This works fine. However I have a report that also needs to show that picture and I am unable to create an image control that will show that picture. Any help is greatly appreciated. BAC

I have a image control on a form thats source points to the path of the folder where the picture is stored. This works fine. However I have a report that also needs to show that picture and I am unable to create an image control that will show that picture. Any help is greatly appreciated. BAC

Ok I think I have most of it. I have a field that links the pictures to a path where the pics are stored. Problem now is I had the photos appear on a report now they obviously do not work. How would I get the photos linked from another folder on my report? I created an image file and in query...

Sonya, You can use the command button wizard. Create open form button then select "open forma nad display specific records". You need to like the related field (usually primary keys) on the left window to the window on the right. Then just click the command button and you will be at that...

I have an OLE field that holds a picture of a person. I have approx. 15,000 records and definitely do not want to put that many photos in an access table. Is there a away to refere the picture of a person to a separate folder on the hard drive? If so how would I relate the photo to the...

I believe you may need to put [Enter Start Date] and [Enter End Date]. They need to be exactly as the parameter is spelled out in the query. Just a thought. BAC [This message has been edited by bill crumpton (edited 10-01-2001).]

Figured it out. I have a command to capitalize after update and for some reason that was causing the problem with the spell check. I moved the command to capitalize to on exit and it works fine.

I have a memo field on a form and when I use the [F7] key to spell check I get the message that the spell check is complete but there are still mispelled words present. The spell check is not catching the mispelled words. Any help is greatly appreciated.

I think I understand but not fully. I am a little unclear on how to link the picture with the field. BAC

I have a database that stores pic of subjects. I would like to store the pics in a separate folder and not in Access. How do I tell Access to link to the picture that is stored on the same drive but different folder? I would like Access to automatically link to the picture that I would name...

Rich, How do you disable the "X" button on Microsoft Application window? BAC

Rich, How do you disable the "X" button on Microsoft Application window? BAC

I have 5 subreports that contain one field each that I need to total on the main report. I cannot get the control to calculate the five fields. Any help is greatly appreciated. BAC

Sorry Alan, the first response was correct. Thanks for your help. BAC

Thanks again Alan works great.

Alan, Thanks for response and this does capture the remainder, however it is rounding up. Any way to get just the first number after the decimal point without rounding up? Thanks.\\BAC

I am doing a long division in an unbound field and would like a certain unbound field to show only the remainder of the division not the whole number. For example, if unbound field [Text 2] is dividing 327 by 11 I want unbound field [Text 4] to show only the .8 remainder of that division...