Re: Can you do this with a macro

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Robert Gillard (bob_at_mystical.demon.co.uk)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 08:39:28 GMT

Ken,
Regretablely I do not have any experience in this area. Is this a good place
to start ?

Bob

"Ken Snell [MVP]" <kthsneisllis9@ncoomcastt.renaetl> wrote in message
news:ebZ41QryEHA.3708@TK2MSFTNGP14.phx.gbl...
> You cannot do this just with a macro. You'd also need to use a VBA
function
> that identifies if the table exists, and then have the macro call that
> function and test the result from it. Have you worked with VBA procedures
> before?
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Robert Gillard" <bob@mystical.demon.co.uk> wrote in message
> news:c3Rld.14933$up1.9498@text.news.blueyonder.co.uk...
> > I want to run a macro that (in plain English says) if tableA exists then
> > open formA, if it does not then open formB.
> > I thought this would be a conditional macro using Iif, but I do not know
> how
> > to say "if the table exists".
> > Can any body help with this please
> >
> > Bob
> >
> >
>
>

Relevant Pages

  • Re: Can you do this with a macro
    ... >> You cannot do this just with a macro. ... You'd also need to use a VBA ... >>> open formA, if it does not then open formB. ... >>> Bob ...
    (microsoft.public.access.gettingstarted)
  • Re: Cannot delete document in Word 2007
    ... Bob the first one sounds to me like I would delete all the documents and I ... Unfortuntately the deletion cursor used in prior versions that could take off entries didn't work right in Word 2007 and was ... or do the above with a Word macro. ... decide you don't need a doument anymore you can delete it. ...
    (microsoft.public.word.newusers)
  • Re: Unhiding columns
    ... Many thanks to Tom and Bob. ... "Tom Ogilvy" wrote in message ... OnTime is ... The columns are hidden in the preview, but if the macro ...
    (microsoft.public.excel.programming)
  • Re: "Send to" via macro
    ... Hey Bob, Could you send me a markup of what you need the output to look ... A proud member of the Microsoft PPT MVP Team ... I would still have to run my macro to ... I've gone through the VBA Object ...
    (microsoft.public.powerpoint)
  • Re: Highlighting
    ... Cool Bob,, ... I'd like to have this macro available to apply to numerous ... > 'This is worksheet event code, which means that it needs to be ... > 'placed in the appropriate worksheet code module, ...
    (microsoft.public.excel.misc)