Microsoft Office Access 2003  for PC
Problem for Microsoft Office Access 2003 (077-02871) for PC

Problem with macro and On Open procedure




By wizeguide on Jan 19, 2008

" "
Hi there


I have cut and pasted a procedure to enable me to display pictures on a form and somehow got to be where I am right now with something that sort of works. Don’t ask me how I got this thing working because I have no clue. The fact that it works is truly a miracle of sorts.

There 3 issues which I cannot get sorted out with my extremely limited access knowledge

Firstly, when I start up my database – I get a “Security warning VBA Macro” which never happened before. I think this has to do with the picture procedure that I copied from the supplied site. As I know I should not have any macros in my system, there is probably one now embedded in there somewhere. If this is the correct line of thinking, can you please help me get rid of it.

The second and more irritating issue is when I load my default form: Frm_Contacts_Details_All_Full_Page I get the following error

Access cant find the field “Picture_Location” referred to in your expression.

I have figured out that this must be in an expression on the form properties somewhere, but I’ll be dammed if I can find it. Please help!

And lastly:
Why is it that I can only open Frm_Pictures in the default view whereas all the other created forms, I can open and then select the design view.?

If these problems can be solved by you, I will gladly send you the shell of teh database sa that you can see what I am actually talking about here.Thanks In advance

Rob

Solution #1

posted on Jan 24, 2008
Not Rated)

Tangoblue

Rank: Wiz 
Rating: 83%, 113 votes
Ignore the warning (it's there for your protection). Do a search for your default page and / or insert it into your expression, presumably a script of some sort from (who knows where and being a bit more specific would have helped....grrr). The last problem might be because you have them located in a different area (folder). Check and see. Search (or find) on the name of one that does show and one that does not appear.
Was this helpful?
Yes
No

Popular Solutions for Microsoft Office Access 2003


Questions and Unsolved Problems for Microsoft Office Access 2003


Do you recommend Microsoft Office Access 2003 (077-02871) for PC?
Answer

Answer
Hey everyone. Can anyone help me come up with a script that will allow me to import a text file... (More)

Answer
I am getting the message "Module not found" after deleting a form that I no longer use... (More)


Didn't find what you were looking for?

Describe your problem:

Select a Category:







Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Top Business and Productivity Experts



Top Computer & Laptop Repair
(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.

(877) 729-0812
We connect to your computer over the Internet to...
Remote Repair



       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select