User Profile

Collapse

Profile Sidebar

Collapse
rdemarco
rdemarco
Last Activity: Feb 20 '08, 10:32 AM
Joined: Feb 5 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rdemarco
    replied to FileDialog box and preventing browsing
    in Access
    Thanks very much, Scott and Delerna

    It works well, and for my purpose it will be acceptable to remind users not to stray away from the directory they are supposed to use.
    Unfortunately, the FileDialog closes when they OK the msgbox - I'll try to tweak your code to keep it open and as Delerna had suggested, navigate them back to the propper dir.

    Thanks again

    Rob...
    See more | Go to post

      Leave a comment:

    • rdemarco
      started a topic FileDialog box and preventing browsing
      in Access

      FileDialog box and preventing browsing

      Hi

      I specify the initial location of my Application.Fil eDialog(msoFile DialogFilePicke r) box by setting the initialFileName property to the location I want the user to pick a file from.

      So far so good, but is it possible to prevent users from being able to browse to another dir?
      I would like to be able to restrict them to the location I specify!

      Any thoughts?

      Thanks
      Rob
      See more | Go to post
      • rdemarco
        replied to Using Eval() function to treat string as VBA statement
        in Visual Basic
        Have not found a way to do it with the eval() function, but here is a workaround:

        Code:
         Screen.ActiveForm!AssetIDLookup.Text = AssetID
        It works, but I would still like to hear if anyone has a better idea :-)

        Thanks
        Rob
        See more | Go to post

          Leave a comment:

        • rdemarco
          started a topic Using Eval() function to treat string as VBA statement
          in Visual Basic

          Using Eval() function to treat string as VBA statement

          Hi guys

          I'm trying to use the eval() function to run code that I have previously compiled via string concatenation.

          Some of it works, for example, I can set the focus to a combo box called 'AssetIDLookup' , which is on the other form, with this code:

          Code:
          'First building the string using variables:
buildCommandString = "Forms!" & AppropriateFormName & "!AssetIDLookup.setfocus"
          ...
          See more | Go to post
          • rdemarco
            replied to Problems with A Hyperlink Control in a Form
            in Access
            HI Larry

            I had experienced the same problem and found that to get the hyperlink working all the time, I had to include the description part of the link. You simply do this by adding the name/description before the actual path/filename, and separate the two parts with a hash (#) symbol (no spaces). Eg:
            MyLinkName#C:\s ubfolder\myfile .pdf

            Hope this helps

            Regards
            Rob
            See more | Go to post

              Leave a comment:

            No activity results to display
            Show More
            Working...