Search results

  1. C

    Delete from more than one table pls

    9 megs is small, and databases compress very well. Email it to me at jeremy atttttt lordco dotttttttt com (format the email properly tho, I did that to stop spam).
  2. C

    Change an Insert query into an Update query

    make an update query in access then view the SQL script to see how its made. THen see how you can create the one you want.
  3. C

    Delete from more than one table pls

    Set up cascade delete properly. Honestly that is the best way. Figure out whats wrong with that. Perhaps zip and upload or send me your database?
  4. C

    Delete from more than one table pls

    Make a delete query that compares the date. first pull out the year InvYear = Year(InvDate) then for the criteria <(Year(date())-3) I think thats right.. Anyone wanna verify that? I will in a sec. Ill test it.
  5. C

    pick up the phone and see the callers details

    http://www.yes-tele.com/access.html
  6. C

    Syntax Error

    Err, are you sure the # isnt causing a problem? also, I think Releasedate should have #
  7. C

    Syntax Error

    Where does it error?
  8. C

    Delete from more than one table pls

    I think its incase he makes a mistake on one..
  9. C

    Delete from more than one table pls

    Cascade delete is the best way.
  10. C

    Using Access for daily data entry

    There is a report wizard you can use, or you can do them manually. Should be able to find a report tutorial on the web somewhere.
  11. C

    Another email question. Now this should be simple

    Post your code that you are using.
  12. C

    Crazy!

    Sounds like you already have a good idea whats going on. Without being there we have no way to test your network. Perhaps you should reboot your servers if you havent done so in a while.
  13. C

    Another email question. Now this should be simple

    So you email it to yourself and then forward it to other people?
  14. C

    Using Access for daily data entry

    Yea you can.
  15. C

    Import error "Active X Component can't create object"

    Its ok =) We all do it. I've asked some really stupid questions before on here.
  16. C

    Another email question. Now this should be simple

    ?? Mark send? You mean you have to manually send it and you want it to just send without you having to press anything?
  17. C

    Pb With On Action Ussing Parameter

    Thats an old post... I don't think he will be checking on it anytime soon...
  18. C

    Import error "Active X Component can't create object"

    http://support.microsoft.com/default.aspx?scid=kb;en-us;319844
  19. C

    Text Mask Error? ****=****

    No problem.
  20. C

    Text Mask Error? ****=****

    Just have if if text1="something" then do something else do another thing end if That should work. Thats what I used.
Back
Top Bottom