User Profile

Collapse

Profile Sidebar

Collapse
devecibasi
devecibasi
Last Activity: May 22 '07, 09:23 PM
Joined: May 17 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Shellexecute path problem even with double quote

    Hi,

    I am trying to use ShellExecute function to invoke the ax program.

    The code below works perfect:
    ShellExecute(0& , "open", "ax.exe", "C:\2runtemp2.r un", "C:\axfolde r", 5)

    The code below does NOT work:
    ShellExecute(0& , "open", "ax.exe", "C:\Documen ts and Settings\jon\De sktop\requiredf iles\2runtemp2. run", "C:\axfolde r",...
    See more | Go to post

  • devecibasi
    replied to Disable screen update in Access?
    Thank you all with your help.

    I use the following Macro Options:
    Action: OpenQuery
    View: Datasheet
    Data Mode: Edit

    I would like to have each query saved with a different query name, so that I can modify them easily. So, I prefer OpenQuery action rather than RunSQL action.

    Regards,
    jon...
    See more | Go to post

    Leave a comment:


  • devecibasi
    replied to Disable screen update in Access?
    Unfortunately, using application.scr eenupdating=fal se command in vba causes an error :"Method or data member not found" .I am using Access2003 by the way.

    thanks,
    jon...
    See more | Go to post

    Leave a comment:


  • devecibasi
    started a topic Disable screen update in Access?

    Disable screen update in Access?

    Hi all,

    I have a macro that executes ~200 queries which modify the data, create some tables etc. The macro runs when the user clicks a button on a form. I would like the queries to be invisible while they are running, but currently the user sees 50+ query windows open/close which is ugly.

    Is there a way to automatically minimize/hide query windows or disable screen update? I know this is possible in Excel by setting...
    See more | Go to post
No activity results to display
Show More
Working...