Search results

  1. D

    Counting No Duplicates

    Help :-( Hi, Thanks for your help. Actually I'm not an expert of SQL, so I was wondering if there is an easy way to do that directly from the Query Table. Thanks again Dante
  2. D

    Counting No Duplicates

    Hi guys, I'm actually starting to use Access and I have a question about a query. Basically I have a table that says: ITEM ORDER CAT A 1200 01 A 1200 02 B 1200 01 B 1100 01 I'd like to count the number of Orders...
  3. D

    Changing backround color

    Hi everybody, I'm trying to make the backround color of a text box "prova" (short date value) changing according to the values of other two different text boxes "StartDate" and "EndDate" (both are short date values). I'd like the backround of prova to be blue if its value is between StartDate...
  4. D

    Format

    Hi Guys, I'm trying to use Conditional Formatting Options on a Text box called "Date". I'd like that this box become Red if its value is between value1 from Text box "Start Date" and value2 from Text box "End Date" or Green otherwise (in this way the color change dynamically every time I change...
  5. D

    Conditional Formatting

    Hi Guys, I've a question and I hope you can help me out....... I'm trying to use Conditional Formatting Options on a Text box called "Date". I'd like that this box become Red if its value is between value1 from Text box "Start Date" and value2 from Text box "End Date" or Green otherwise (in...
  6. D

    Create a report by field values

    Hi There, I have a problem........and I hope you can help me out!! I created an overall report that prints out all different information coming from a Table (Tasks), like: "Milestones", "Tasks", "Open Date", "Category", etc.. The field "Category" has different values changing between 6...
  7. D

    Hide Duplicates values in a Combo Box

    Hi Guys, I have a problem. I'm trying to import values to a Combo List from a table: Row Source = SELECT Tasks.Milestones FROM Tasks; where Task is a table and Milestones a field of that table. In this field (Milestones) there are repeated values, but I'd like to hide those duplicates when I...
  8. D

    Link more Tables to the same Form

    Hi there, I have a question: Is it possible to link more than one table to the same Form in order to keep previous data? Thanks a lot
  9. D

    Keep previous data

    Link more tables to the same Form Hi, First of all I'd like to thank you again for your help!!! I've another question: Is it possible to link more than one table to the same Form to keep previous data? Thanks a lot
  10. D

    Keep previous data

    Thanks a lot!!!!!! It was really helpful!! Ciao
  11. D

    Keep previous data

    Hi Guys, I'm pretty new in the access world and I'm trying to build my first Database! I've a question (I bet really simple): I'd like to know how it is possible to keep previous data that I've entered in a form when I open it a second time. Thanks a lot for you help
Back
Top Bottom