Search results

Thanks Shane, I did something similar and that worked. If MsgBox("Message", vbOKCancel + vbQuestion, "Confirm") = vbOK Then I got the idea from a previous post. Thanks though. Mixup

I have a "Browse" button on a form that works fine. I would like to add a Message Box that warns the user that if they click "ok" on the message box they will start browsing, and if they dont want to do that click "cancel" in the message box. ( I know its obvious, bu thats what my friend...

Thanks for the response. It is one of thse little things that I completely overlooked.

Is there a way to allow edits to the properties of objects/controls only in Design view and not in the Form View?

Here's the problem: I am working on a database (I am not a programmer, I am just doing it for learning, and this is for a non-profit), where each record would have a PhotoLog sub form. The PhotoLog subform would have information on several photos (that are linked and not embedded) for each of...

RG: The second time you have helped me out! I really like your simple solutions. Thanks a lot.

RG: I tried it. In my main database, when I move to form view it says "#Name?" Then I tried a simple database with a similar browse control that I have, and tried it again. Still doesn't work. I am attaching that. Can you figure out, what am I doing wrong here? Thanks.

You might not want to embed the picture. It increases the database size quickly. Instead store the file path in a table connected to the form. Check out these articles: the first one covers how to create the table and the forms. The second one covers the browser button. I have used both and they...

If I have a file path name on a text box (say Text1) how can I get just the file name (with extension) in another text box (say Text2) without using any complicated functions... probably an expression in the control source.

Ghudson: I was actually using a code from the Microsoft Knowledge Base for the Browse function. But you are right this (your code) actually combines two steps in to one. I am learning more about access from this forum than any book. Thanks to all of you.

Rural Guy: Thanks for your help. I dont know however what I was doing wrong before. As I was trying it one last time before sending you a part of the database, it worked! And it worked without the "Me" referenceThank you so much for the help.

I tried both of those options. The first one, without "me" gives me an "Error" message in the text box. While the second one with the "me" reference does not work either, with a "Name#?" message in the text box when I go back to the form view from the design view. Is there something that I am...

Does this go to the Control Source of the text box? Rural Guy: Thanks for your reply. I need a little clarification. I have one txt box field (Say, Text1)that contains the full path: C:\documents and settings\owner\photos\owl.jpg If I want it in a different text box (Say, Text2), do I put...

After some help from one of the threads here I managed to install a Browse button in a form that inserts a file path to a text box. What I need is the folder path from that file path in another text box. For example if the file path is C:\Documents and Settings\mixup\Sketches\owl.jpg I would...