Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'fDesign' error (Access 97 SR-2)

    My copy of access has started acting strangely. Each time, when working on a query, when I go into SQL view and then try to back to Design View I got the following error.

    Access can run the macro or callback function 'fDesign'.

    I have tested the problem in multiple access database and the same problem occurs. It is sort of a pain, since I then cannot get back to the Design view.

    Any ideas?

    Sean

  2. #2
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'fDesign' error (Access 97 SR-2)

    I've never had this problem, and don't use Acc 97 anymore..but..things like this I've often found are to do with 'odd' or 'missing' references.

    In Access 97 open a module window (VBA) and select TOOLS --> REFERENCES

    What libraries do you have references to?

    Failing any other solution, some times it's faster to uninstall and re-install the app <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    I may be leading you up the garden path but it's my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'fDesign' error (Access 97 SR-2)

    Post the SQL for the query. If fDesign actually *is* a function or macro then the problem may very well be a broken reference. If it isn't, then there's something wrong with your SQL.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Aug 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'fDesign' error (Access 97 SR-2)

    Thanks for the thoughts folks. I actually figured it out...It turned out to be a corrupted button on the Query Design toolbar. Very strange. I just replaced it with a new instance of the button and it seemed to work fine. I guess the name of the macro that controls the Design View toolbar button is called 'fDesign'.

    So. I learned something new.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •