User Profile

Collapse

Profile Sidebar

Collapse
JPG4
JPG4
Last Activity: Aug 16 '07, 03:14 AM
Joined: Aug 15 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JPG4
    replied to Check boxes excludes needed information
    in Access
    Hi Scott,

    I have decided to try to take a new approach (unless you can help me with the above issue). I have posted a new discussion under the title "Linking a Text Box in a Form to the Criteria in a Query using "Like" "

    Since you have an idea of what I am looking for, any help or suggestions would be wonderful! :-)

    Thanks!
    See more | Go to post

      Leave a comment:

    • JPG4
      started a topic Linking a Text Box in a Form to the Criteria in a Query using "Like"
      in Access

      Linking a Text Box in a Form to the Criteria in a Query using "Like"

      I have tried just about everything that I can think of, so now I turn to you all for help!

      I have created a form (titled "OAG") with an unbound textbox titled "DOW". I also have a Query that I have set up to return results using the abbreviations for the day of the week, and periods when that day is not present. For example, if the pattern is Monday, Wednesday, Friday, the query shows it as "Mon.Wed.Fr i.."...
      See more | Go to post
      • JPG4
        replied to Check boxes excludes needed information
        in Access
        Scott,

        I like your idea, however, I am not quite sure how to implement it. See, the days of the week (frequency) come from a table that is downloaded from a website into Excel and the uploaded into Access. The way the table comes is in numbers, where 1=Mon, 2=Tues, etc. The table comes with the frequencies all listed in one column in this format: 1..4.67 (Mon, Thurs, Sat, Sun), or 1...... (Only Monday), etc... So, what I did was...
        See more | Go to post

          Leave a comment:

        • JPG4
          replied to Check boxes excludes needed information
          in Access
          Hi Scott!

          Thank you for a quick reply! I have copied and pasted the code below as you requested. (By the way, thank you for explaining how to do that... I would have been lost!) I have 4 queries total, but this it the final one (the one that relates back to the check boxes on the form). Let me know if you need anything else and again, thank you for your help!

          [CODE=sql]SELECT [FREQ YesNo].MONTH, [FREQ YesNo].CXR,...
          See more | Go to post

            Leave a comment:

          • JPG4
            started a topic Check boxes excludes needed information
            in Access

            Check boxes excludes needed information

            Hello,

            I am creating a form in Access that uses the days of the week (I am looking at flight patterns for an airline). I have created a check box for each day; therefore I have 7 total. The checkboxes relate back to a query (that are in the yes "-1" and no "0" format) so that when I check the box for Monday, the query comes back with flights that ONLY operate on Monday ("yes").

            This is...
            See more | Go to post
            No activity results to display
            Show More
            Working...