Microsoft Office Access 2003 (077-02871) for PC Logo
Posted on Jan 19, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Problem with macro and On Open procedure

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

1 Answer

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Scholar:

An expert who has written 20 answers of more than 400 characters.

  • Expert 108 Answers
  • Posted on Jan 24, 2008
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Scholar:

An expert who has written 20 answers of more than 400 characters.

Joined: Jan 24, 2008
Answers
108
Questions
1
Helped
56592
Points
141

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.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

55 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3269 Answers

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3869 Answers

Brad Brown

Level 3 Expert

19190 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...