User Profile

Collapse

Profile Sidebar

Collapse
ajetrumpet
ajetrumpet
Last Activity: Aug 25 '07, 02:47 PM
Joined: Jul 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ajetrumpet
    replied to trying to grab the max value from two diffrent fields
    in Access
    Brita,

    I think you're going to have to make a few queries to get this....try something like these...
    1)
    Code:
    SELECT [all fields except "days to complete method 2"], [days to complete method 1] AS MaximumCompletionTime
FROM (table)
WHERE [days to complete method 1] > [days to complete method 2];
    2) (Append Query)
    Code:
    INSERT INTO [query1]
SELECT [all fields from original table except "days to
    ...
    See more | Go to post

      Leave a comment:

    • ajetrumpet
      replied to New fields based on combo box selection
      in Access
      Ferguson,

      First of all, the code reads
      Code:
      .Visible = False
      If I were you, I would write nested "If, Then, Else" statements, like the ones already posted, for all four of your choices in the combo box. I would tie each one of those statements to reference the separate text boxes on your form and use the ".Visible = Condition" property in the nested statements to display the appropriate text box on the "AfterUpdat e"...
      See more | Go to post

        Leave a comment:

      • ajetrumpet
        replied to Export Excel files to Access db
        in Access
        When you do this too, you might want to be on the lookout for data type and formatting changes of cell values on import or link. This is a huge issue and is asked about frequently
        See more | Go to post

          Leave a comment:

        • ajetrumpet
          replied to Acess Query Help
          in Access
          This is what append queries are used for. See what you can get from the query design grid when you select append query. You can also set this up to run automatically if you have to append records to another table more than once.
          See more | Go to post

            Leave a comment:

          • ajetrumpet
            replied to Access Help
            in Access
            User specified criteria is usually entered into a control of somekind. Could you maybe run the report with a command button?? Sounds like your report is based on the query, so that would probably work...

            You could enter your control names in your code line....
            Between [source1] AND [source2]...
            See more | Go to post

              Leave a comment:

            • ajetrumpet
              replied to Refreshing results displayed on the subform
              in Access
              Maybe you could try "Me.[subformname].Requery" on one of the subform's property events??
              Or maybe "[Forms]![subformname].Requery" on the main form property events??
              See more | Go to post

                Leave a comment:

              • ajetrumpet
                replied to any ideas please?
                in Access
                It sounds like a cascading combo box issue. Do you have a list of questions already prepared and entered in a table??
                Are you wanting to filter certain questions based on the first question asked??
                See more | Go to post

                  Leave a comment:

                No activity results to display
                Show More
                Working...