User Profile

Collapse

Profile Sidebar

Collapse
Jerry911
Jerry911
Last Activity: Jan 27 '12, 04:04 PM
Joined: Nov 3 '07
Location: Alabama
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jerry911
    replied to Using an EXISTS function to determine if a column exists in a table query
    in Access
    Thanks Jim!

    That fixed my issue and will actually help in several other reports I run regularly. Thanks a million!

    Simple solutions are my favorite kind.

    -Jerry
    See more | Go to post

      Leave a comment:

    • Jerry911
      replied to Using an EXISTS function to determine if a column exists in a table query
      in Access
      Even if there is no associated time stamp for that value? I will have to explore that.

      Thanks.
      See more | Go to post
      Last edited by NeoPa; Sep 27 '11, 10:24 PM. Reason: Removed quote - Please don't use without good reason - it just wastes time and resources

        Leave a comment:

      • Jerry911
        started a topic Using an EXISTS function to determine if a column exists in a table query
        in Access

        Using an EXISTS function to determine if a column exists in a table query

        I have found multiple examples of VBA functions to test for the existance of a column in a table and getting a message return. My need is a bit different so I better try and give the sequence of events that I need to try and capture.

        1. I use 1 query to pull a dataset with a EVENT_ID, UNIT_ID, a UNIT_STATUS and TIME stamp for that status for a given date/time range. Call it UnitHistory.

        2. I use a cross-tab query against...
        See more | Go to post
        • Jerry911
          replied to Using Forms to filter a query in Access 2007
          in Access
          You have given me some food for thought. I will play with it some this weekend and see how it works for me. One thing I really like in this new version of Access is the ability to filter items easily in the datsheet view, that may ultimately be what I end up doing.

          Thanks for your feedback!...
          See more | Go to post

            Leave a comment:

          • Jerry911
            replied to Using Forms to filter a query in Access 2007
            in Access
            Thanks for the fast response!

            I think I know what you are describing, just not sure it's what I am looking for. It would probably be easier if I were just building a report where I have more flexibility in applying criteria, unfortunately I need the raw query results to be able to export them to a spreadsheet.

            The 4 filter elements I need to use are a time range (pick list), a day range (pick List), a zone (list box)...
            See more | Go to post

              Leave a comment:

            • Jerry911
              started a topic Using Forms to filter a query in Access 2007
              in Access

              Using Forms to filter a query in Access 2007

              Hi,

              I have a query that I use to export data to a spreadsheet. The query itself works fine and I can manually edit the query to supply filtered information. What I would like to do is use a form that has several filter options so I do not have to modify my query every time I run it. I have a form with a list box to define one of the filters and I can make it work with that specific filter using the DoCmd.ApplyFilt er function. I want/need...
              See more | Go to post
              • Jerry911
                replied to Hiding/Unhiding fields in a form using a pick list
                in Access
                Thanks for the response!

                I just had to make one adjustment to your code. You had: MakeVisible = DateSelector = "8" and it needed to be: MakeVisible = DateSelectorVal ue = "8" . Worked like a champ after that. Only took me an hour of fiddling with it...

                Thanks again!
                See more | Go to post

                  Leave a comment:

                • Jerry911
                  started a topic Hiding/Unhiding fields in a form using a pick list
                  in Access

                  Hiding/Unhiding fields in a form using a pick list

                  I have a form that uses a pick list to select a specified date/time range based on the case value. Case 1-7 have pre-defined date/time functions, but case 8 is for a custom date/time range. I only want to show the custom fields when the custom date range option is selected. When the form loads I have all the fields hidden.

                  [code=vb]Private Sub Form_Load()
                  Me!CustomDateBo x.Visible = False
                  Me!dtpStartDate .Value = Date
                  ...
                  See more | Go to post
                  Last edited by Stewart Ross; Mar 15 '08, 08:04 PM. Reason: added code tags around vb
                  • Jerry911
                    replied to turn a control on, then off, on a form
                    in Access
                    I have a very similiar situation with a form, is it appropriate to post it here or start a new thread? It involves hiding/unhiding fields based on the selection of a value (case) from a list box.
                    See more | Go to post

                      Leave a comment:

                    • Jerry911
                      replied to Conversion of seconds to hours and minutes
                      in Access
                      I know this thread has been dead for a long time, I just wanted to say thanks!You helped resolve an issue on a report I was developing and was beating my head against the keyboard over.
                      See more | Go to post

                        Leave a comment:

                      No activity results to display
                      Show More
                      Working...