User Profile

Collapse

Profile Sidebar

Collapse
redcali55
redcali55
Last Activity: Oct 18 '08, 04:26 AM
Joined: May 14 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • redcali55
    replied to Open Another Database in a New Window
    in Access
    For anyone else who came across this looking for a quick answer...I just set it up as a hyperlink using VBA:
    Code:
    Private Sub Command25_Click()

    Dim strInput As String

    strInput = FilePathCommonOth1 'This references a text box on my form that has a file path
    
   Application.FollowHyperlink strInput, , True 'Setting this to True opens the database in another window

End Sub
    See more | Go to post
    Last edited by NeoPa; Sep 8 '08, 10:42 PM. Reason: Please use the [CODE] tags provided

      Leave a comment:

    • redcali55
      started a topic Open Another Database in a New Window
      in Access

      Open Another Database in a New Window

      Hello,
      I'm trying to create a form that works as a Switchboard to open a number of databases from one place. I want users to be able to click a button and open an existing database in a new window. I tried the following code and the database flashes open and then disappears (fyi - I'm using Access 2007). Any ideas?
      Code:
      Private Sub Command0_Click()

    Dim appAccess As Access.Application
    Dim strDB As String
      ...
      See more | Go to post
      Last edited by NeoPa; Sep 6 '08, 03:44 PM. Reason: Please use the [CODE] tags provided
      • redcali55
        started a topic Export Table Design to Excel
        in Access

        Export Table Design to Excel

        Hi,

        Is it possible to export the design of a table to Excel (e.g. Field Names, Data Types, Descriptions)?

        Thanks,
        Laura
        See more | Go to post
        • redcali55
          replied to Exporting A Subset of Data From a Table w/o a Query
          in Access
          can't link it, the database I'm exporting into needs to be sent to someone else, i.e. it needs to 'stand alone'......
          See more | Go to post

            Leave a comment:

          • redcali55
            started a topic Exporting A Subset of Data From a Table w/o a Query
            in Access

            Exporting A Subset of Data From a Table w/o a Query

            Hi,

            Is there a way to export a subset of data from a table into another Access database without using a query? Preferably some VBA code so the process can easily be repeated. The OutputTo and TransferDatabas e methods don't seem to have the option of a Where condition.

            The reason I don't want to use a query is because once I define the criteria (i.e. where COUNTRY = "Mozambique ") I can no longer use the *. Some...
            See more | Go to post
            • redcali55
              replied to using two multiselect boxes to filter a report
              in Access
              Fabulous!

              I just had to add "OpenArgs:=strD escrip & "And" & strDescrip2" as well and it worked great!

              THANKS!!...
              See more | Go to post

                Leave a comment:

              • redcali55
                started a topic using two multiselect boxes to filter a report
                in Access

                using two multiselect boxes to filter a report

                Hello,

                Does anyone know what to alter this VBA code (below) so that a report can be filtered using criteria from TWO multiselect boxes? e.g. allowing the user to view products from multiple categories and multiple prices within those categories.

                http://allenbrowne.com/ser-50.html




                Thanks,
                Laura
                See more | Go to post
                No activity results to display
                Show More
                Working...