User Profile

Collapse

Profile Sidebar

Collapse
Gail Williams
Gail Williams
Last Activity: Sep 26 '12, 09:57 AM
Joined: Feb 6 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Gail Williams
    replied to Changing a subform on a main from, from the original subform
    in Access
    Hi

    Thanks to TheSmileyCoder, I have followed his advise and now got it working. The code ended up as:
    Code:
    Private Sub Command8_Click()

Dim strSourceSubForm As String
strSourceSubForm = "frmUpdate"

With Forms("frmUIMain").Child20
  .SourceObject = strSourceSubForm
End With
  
End Sub
    Thanks again for the assistance.
    See more | Go to post
    Last edited by NeoPa; Apr 27 '12, 12:39 AM. Reason: Added mandatory [CODE] tags for you.

      Leave a comment:

    • Gail Williams
      replied to Changing a subform on a main from, from the original subform
      in Access
      Thanks for the response, I'll give these suggestions a go and post if it works.

      Only one point I have to raise, TheSmileyCoder said:

      "How can you expect ME to work, when you have closed the object? "

      I expected it to work because after the close I had in fact opened the main form with:
      Code:
          DoCmd.OpenForm "frmUIMain"
      As I said, I'll give it a go and let you know.
      ...
      See more | Go to post
      Last edited by NeoPa; Apr 27 '12, 12:39 AM. Reason: Added mandatory [CODE] tags for you.

        Leave a comment:

      • Gail Williams
        started a topic Changing a subform on a main from, from the original subform
        in Access

        Changing a subform on a main from, from the original subform

        Hi

        I have created a database that uses a menu form which selects difference subforms depending on the button click. That's no problem.

        I've now been asked to update an existing database to be in the same format. This database has about 45 different forms so I can’t fit them all on a single menu besides which in many it's a cascade, you have to go from one form to the next which in the original database I achieve...
        See more | Go to post
        • Gail Williams
          replied to Access Front End Changes
          in Access
          Hi NeoPa

          As far as I can tell there is no difference in front ends used locally and remote, as I said, I simply copy them between folders and my IT support say that they access rights are the same.

          Thanks for posting an answer though.

          Cheers
          G
          See more | Go to post

            Leave a comment:

          • Gail Williams
            started a topic Access Front End Changes
            in Access

            Access Front End Changes

            Hi All

            I've created a split database and given each user their own front end. The front end databases are in named subfolders within on main folder. Generally speaking, I make changes on the front end in my named folder, then copy the whole file to everyone else.

            We are working on a terminal services server, and one of my colleagues work remotely, the others are all working in the same office, but still all of us,...
            See more | Go to post
            • Gail Williams
              replied to Continuous Password Requests
              in Access
              Good advise, will take it.

              Thanks
              See more | Go to post

                Leave a comment:

              • Gail Williams
                replied to Continuous Password Requests
                in Access
                Hi Mihail

                Thanks for the response, you've confirmed my own thoughts on this one. I had already tried the first two points with no improvement before posting, but not the second two as the company I work for runs terminal services so reinstalling is unlikely to be approved by the IT Manager. However, I did find a copy of the database from a couple of weeks ago that is still working, so I guess my best option is to copy that and migrate...
                See more | Go to post

                  Leave a comment:

                • Gail Williams
                  started a topic Continuous Password Requests
                  in Access

                  Continuous Password Requests

                  Hi

                  I have written an asset management program in Access 2007 that's been in use for over two years. Access is restricted only by a password. This is a multi-user database that up to seven people use, usually about 3 in at any one time.

                  Today, instead of being asked for the password only on entry, users are being asked for the password on exit and when taking actions such as allowing macros to run.

                  ...
                  See more | Go to post
                  • Gail Williams
                    replied to How to work with individual records in detail section of report
                    in Access
                    What you might want to think about is a two step approach. I have similar project reporting which I've had to write, and I achieve this by doing a single line calculation for each expression per line at the lower level in our case, work order (see advise given by Mihail).

                    When reporting at the higher project level, because I need to add up multiple lower level work order lines, I use the original query with the calculations in and...
                    See more | Go to post

                      Leave a comment:

                    • Gail Williams
                      started a topic UI-Builder from OpenGate Software
                      in PHP

                      UI-Builder from OpenGate Software

                      Hi All

                      I have been asked to use UI_Builder-Starter4 from OpenGate Software to create the front end of my access database. Has anyone got any experience with this and can you give me any feedback on how user friendly / useful you found the programme?

                      Thanks
                      See more | Go to post
                      • Gail Williams
                        replied to Changing Subforms Within a Mainform
                        in Access
                        This worked for me. Thanks both for your help.

                        @NeoPa - I'll try and figure out what the first account was and see if I can log in that way in future.

                        Thanks again
                        See more | Go to post

                          Leave a comment:

                        • Gail Williams
                          replied to Changing Subforms Within a Mainform
                          in Access
                          @NeoPa - yes, that is exactly what I'm trying to do.

                          @ADezii - will give that a go when I get to work in the morning.

                          Thanks both
                          See more | Go to post

                            Leave a comment:

                          No activity results to display
                          Show More
                          Working...