Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KingAndy

    Appication.Quit - but Access stays open ???

    Hey people When I joined the company i'm working for now - this problem was a common occurance, it took me a long time to trawl through all the Forms and code to fix the problem, but I persevered and Access closes correctly each time now! There are 2 known causes, for this problem that...
  2. KingAndy

    Clear Listbox Selection

    Thanks Thats worked a treat! - and what a speedy response! Thanks again Andy
  3. KingAndy

    Clear Listbox Selection

    Hello - Hope someone can help. I have a Listbox on a form with multiple select set to Simple. How can I clear/unselect the selected lines of the listbox when a button is clicked? Ive tried setting the .ItemsSelected to null or nothing, but Access wont let you do this. Can anyone help Thanks Andy
  4. KingAndy

    get rid of message box?

    xq If your running code behind the button add the following lines before and after your existing code. DoCmd.SetWarnings False ***** YOur Code here ******* DoCmd.SetWarnings True If you are using a Macro use the SetWarnings Command. Andy
  5. KingAndy

    Projecting future dates

    Sentra Behind the fields AfterUpdate command try this code (adapted to your form) Private Sub InitialDate_AfterUpdate() SixMonthDate = DateSerial(DatePart("yyyy",InitialDate), DatePart("m", InitialDate) + 6, DatePart("d", InitialDate)) OneYearDate =...

Part and Inventory Search

Back
Top