Recent content by noob23

I have an Access form and I want to display the Hyperlink from a certain field ON the form itelf instead of opening it in a new IE window. My Hyperlink field is actually Pictures. I am hyperlinking to pictures on a local drive. WHen a user clicks on the hyperlink in the field, it automatically...

I "need" to store the calculated field because it is information that is part of our database as a whole. I will also be using this database with a web interface I am building and the information from all the fields needs to be read from the DB to the web interface. I'd like to have the...

yes, indeed I need to store the calculated value. i need to store the data in the table after it is calculated. can i do that? why is it not recommended? i need to do it that way. how can i do it?

The form is already based on another query.

how do i run this from a form? in other words, when a user is in the form and enters the data into FieldA and FieldB, how does the user activate the query and then populate FieldC with the query's output? also, i'm not sure how to write the query itself. how should the SQL view look? thanks.

In an Access database, I need to write a query that will perform a formula in a form. When the form is open to a record, the query will take the date from FieldA and multiply it by the data in Field B and then put the total in FieldC. I have no idea how to do this. Can someone/anyone please...

Virgin, I'm trying to create Access queries for calculating formulas as well. I'm having trouble. Can I see your queries? They would probably help me a lot. Thanks!

Thanks guys! I'll try these out and let you know if they work. I sure hope so!!

Thank you, but I'm very new to this. I don't really understand how to do what you are saying. Can you offer any more detailed explanation? Step by step? I'm learning this as I go along. Thanks.

Yes, I know how to do it that way, but this has to be done dynamically. The user will simply insert the name of the image into a field, and then the picture will be displayed on the form corresponding to that name. Know what I mean? This has to be VERY easy for the users. Any suggestions?

Thanks, but I need to have the picture on the Form itself, not on a Report. It is a product database and each record/item has it's own picture. When the user navigates from record to record, each form should display the image that corresponds to the item/record. I hope I am being clear enough...

Is it possible to insert/view JPEG or GIF images in a form? Or do they have to be BMP images? I have tons of images that I need to put into an Access 2000 database, and then each image must be displayed on it's corresponding record's form. All of the images are either JPEG or GIF. Can I use...

ok, this is a little clearer. but what is an image control? do you mean create and image box from the toolbox? also, can i display JPEG of GIF images in the form? or only bitmapp images? thanks.

can you be a little more specific? what do i do after I create the column? how do I associate it with each records pic? please explain. i'm new to this stuff. thank you.

I have an Access 2000 database. Each record represents a product and has an associated picture. All of the pictures are located in one central folder. I need to be able to display each picture on each record's form display. How do I do this?