Search results

  1. C

    Hi all!

    Hi Jamie, Welcome to the Forum. I'm sure you will improve your understanding here. Good luck.
  2. C

    Macro to delete table

    Tracy, Have you tried to create a Delete Table Query? In your Macro, you can then run this Query.
  3. C

    Marking threads as "being replied to"

    It's quite annoying when you take the time to write a reply to a thread to help someone, and when you're finally ready to send the reply, you realize that someone else has just posted a reply , which is often a copy of my reply. Is it possible to mark a new or unsolved thread as "being replied...
  4. C

    Duplicate records not showing on report

    To do what you suggested, If the primary key is called IDperson then you add to your query: Person: =[LastName]&"," &[IDperson] Then in your report you could add Person and group on Person instead.
  5. C

    Table Lookup

    Hi, Go to Video Tutorials, and check "How to create a relationship between 2 tables". Then check Video tutorial for "Queries". This will help for sure
  6. C

    Hello everyone

    Hi Duane. Welcome.
  7. C

    Hello Everyone

    Hi , Welcome.
  8. C

    Hello

    Hi Alan, Welcome. If you're a newcomer to Access, then the video tutorials is a great starting point. Good luck
  9. C

    Newbie

    Hi Camen. Welcome. To learn quickly: the Video tutorials is a good place to start.
  10. C

    I want my mommy.....

    Hi Riverstar5. On this site (top right side) go to "Video tutorials" , "Queries", and learn. Once you've done that and understand it, try to do what Sparks and jzwp informed you.
  11. C

    Eliminate duplicates in a Query

    Hi, Have you tried the Sigma sign (Totals) in the design of your query? Here you can group and or total on each field.
  12. C

    Combo box enable/disable

    yes I am saying exactly that. It also changes back to unabled if you reselect another value like diarized
  13. C

    Combo box enable/disable

    Hi Janeth, I downloaded your file. It works. The code provided by Sparks80 is correct. What is the issue?
  14. C

    Combo box enable/disable

    Hi, Do you know how to disable the refer combo box? Does " Refer to tl" in Combo box "Status" have a unique autonumber?
  15. C

    msg box on duplicate entry

    Hi, Do you know how to disable the refer combo box? Does " Refer to tl" in Combo box "Status" have a unique autonumber?
  16. C

    msg box on duplicate entry

    In the table design view select " Indexed" Yes (No Duplicates) for the relevant fields. Make sure that the table does not yet contain duplicates.
  17. C

    report with a field not in any table possible

    In the report add a calculated field. Inside the text field you type what you like, for example [Please enter the year and Quarter]. This must be Between square brackets! When the report opens, the user will be prompted, and he/she can enter text. It will be visible on the report.
  18. C

    Cant get this query figured out

    No. In the Totals Query, You GROUP BY Individual sizes and Total (or count) the sizes. It will give you a total or count per group/size
  19. C

    Cant get this query figured out

    If you want to keep the query you have, then make a copy, else use it to do this: In the criteria row of the date type this: Between [Please Enter date1] AND [Please Enter date2] Now run the query, enter date1 click OK, then enter date2 and click OK. You now have the results within 2 dates...
  20. C

    Happy Birthday Bob

    Hi Bob, Í see that I'm 1 day late on congratulating you. From Holland I send you a big "Gefeliciteerd". Hope you had a good one, and many many more to come.
Back
Top Bottom