Search results

  1. Y

    shortcut to use the 2007 access search text box?

    there's a new search function in 2007 in the buttom of a form. Is there a shortcut key that i can use to go directly their? (or perhaps make a shortcut) I'm always clicking on the search text box to use it which is a hassle for me Thanks~ ________ CHRYSLER HEMI ENGINE HISTORY
  2. Y

    Expression where it shows me what test hasn't been done?

    wow this is great Jal - now I only need to join it in a report somehow =D ________ Yamaha Yp400 Majesty
  3. Y

    Expression where it shows me what test hasn't been done?

    mm i don't think its working http://75.127.124.193/Database7.mdb - I have the union query in their but if you take a look at ID 2 where I put "Monitoring" - some of the other id 2's says need hormonal. T_T ________ Civic Si
  4. Y

    Expression where it shows me what test hasn't been done?

    OK i'll try this =D thanks alot I'll probably won't know how to render this to my report though =x ________ WINNING
  5. Y

    Expression where it shows me what test hasn't been done?

    HI Jal maybe i'm not explaining this too welll. Here is the concept database I made. http://75.127.124.193/Database7.mdb if you go into the demographic report you will see that "Daniel Li" has done "Hormonal", "Prog", "Blood" Tests. But he has not yet done (lets just say) "HIV/AIDS"...
  6. Y

    Expression where it shows me what test hasn't been done?

    Hi Jal Thanks for replying - I'm not that familar with union alls - I need this printed in my report is that possible? ________ Lamborghini cheetah history
  7. Y

    Expression where it shows me what test hasn't been done?

    I have a Tests Field Combo Box having data: Bloodwork, Hormonal Levels, Screening, Monitoring lets say for a patient, she only did bloodwork and hormonal. Is it possible to make an expression where it tells me hormonal levels and monitoring not done in a form or report? ________ EASY VAPE...
  8. Y

    Opening up a form where it puts the ID in automatically?

    Hi HiTechCoach, thanks for helping me again This is what I have so far Private Sub Command22_Click() On Error GoTo Err_Command22_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "history Query" stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm...
  9. Y

    Opening up a form where it puts the ID in automatically?

    I have a form that is only a screenshot. I want to have a form button where once you click on it, we add a new record in that matches the ID to ID, and puts in the ID for you here what I have so far. Private Sub Command22_Click() On Error GoTo Err_Command22_Click Dim stDocName As...
  10. Y

    Using Access Database on Web

    php or asp... gotta learn one =) ________ FORD BOSS ENGINE
  11. Y

    search function from access 2007 just like access 2003

    In access 2007, if you haven't noticed, there is a search function below the tables/forms. However, this function is not available in 2003. Is there any way possible to have a search text box just like access 2007? Thanks ________ Og Kush
  12. Y

    how to input info in "form view"

    how to input info in "form view" I know Navicat has this function but I can't customize, move the form to my liking I'm wondering is there any other tool that lets you customize the form and is as fast as Navicat ________ MAZDA CAPELLA PICTURE
  13. Y

    help changed id to number by mistake how to change back to autonumber

    Yes, everything seems fine. XD ________ Bong pictures
  14. Y

    help changed id to number by mistake how to change back to autonumber

    All I used was an append query - it converted the id back to autonumber Cheers =D ________ Buy Aromed Vaporizer
  15. Y

    help changed id to number by mistake how to change back to autonumber

    Thanks so much MSAccessRookie - really learned alot from you. Great help as always =D Cheers~ -Danielle ________ Medical dispensaries
  16. Y

    help changed id to number by mistake how to change back to autonumber

    help i have tables that are relational to this id ________ New jersey dispensary
  17. Y

    Places to learn visual basic online?

    Any recommendations? I really like w3schools.com but they only have vbscript ________ Weedmaps
  18. Y

    Query too long how can I shorten this?

    Thank you guys and happy holidays =) ________ Toyota Fj40 Specifications
  19. Y

    Query too long how can I shorten this?

    ahh okay, I'll try to do it So Ill make a table with ID SortOrderID Test ________ CHRYSLER VALIANT CHARGER HISTORY
  20. Y

    Query too long how can I shorten this?

    hi pblady, i don't want that many tables/relationships - join queries confuses me =( I just need to shorten this by a bit =) ________ Honda Stepwgn specifications
Back
Top Bottom