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 strongm 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: *

  • Users: lblastick
  • Order by date
  1. lblastick

    i have disabled the use acess speci

    If you choose Tools, STartup, Advanced, disable 'Use Access special Keys' Hope this helps.
  2. lblastick

    Combo box, selecting by typing

    TO easily select the lookup items in a combobox I put a text box over the combobox on my form with the arrow showing. Choose format - send to back for the combobox. Data will be entered in the text but completed by the lookup using these events - Private Sub citieslkp_AfterUpdate()...
  3. lblastick

    Selecting records with no match in second table

    Or you could create a 'Find Unmatched' query. I find using the wizard makes it less confusing. Hope it helps :)
  4. lblastick

    Date Field

    if you change the table where the data is stored to format mm/yyyy it should work :)
  5. lblastick

    Form Update on Before Update event...I know it might sound weird

    I think you just might need to like the form duplicates to the data you want to review. Here's a revision of your code to try. Hope it helps :) Private Sub TheirClaimNumber_BeforeUpdate(Cancel As Integer) Dim stLinkCriteria As String stLinkCriteria =...
  6. lblastick

    Hav a standalone database app???

    Have you tried to make an MDE file. Choose tools - Database Utilities - Make MDE file
  7. lblastick

    Query to compare dates

    Try using the DateDiff function. Example - DaysElapsed: DateDiff("y", [OrderDate], [ShippedDate])
  8. lblastick

    Due Dates in (Work/Business Days)

    Is it office 2000? In access 2000 there is a NETWORKDAYS and a WORKDAY function that would seem to be a help. NETWORKDAYS returns the number of whole working days between a start and end date, excluding weekends and any identified holidays. If this function returns the #NAME? error value, you...
  9. lblastick

    Phantom Bookmarks When Running Query

    Then only thing I can think of is to do a search on the code for the entire database to see if the programmer sets a bookmark anywhere. Hope it helps!!
  10. lblastick

    Disable mouse wheel

    I had the same problem. Are you using Access 97 or 2000? Did you install the mousewheel.dll file on the computer you are using??
  11. lblastick

    Hiding Main Table/Query/Form Menu Bar with Popup

    You can change the way that the form is loaded by changing the startup properties off of tools on the menubar. Hope this helps you :)
  12. lblastick

    Syntax error on report button in form?

    Just a thought of something to check - on the form properties, under other - make sure the cycle is set to current record. Hope this helps :)
  13. lblastick

    Key Preview event on a Form!!!!

    You can use the KeyPreview property to specify whether the form-level keyboard event procedures are invoked before a control's keyboard event procedures (KeyDown, KeyUp, and KeyPress). You can set the KeyPreview property by using the form's property sheet, a macro, or Visual Basic. You can set...
  14. lblastick

    Newbie in need of some basic help.

    Create a blank Access database. Right click and choose Import. Change the file extension to .xls for excel. The Import wizard should appear and walk you through the rest of the way.
  15. lblastick

    Make custom menu appear on all PCs

    the easiest way to customize the menu for the single DB is to create a new menu within the database at the top of the page using icons or buttons and creating OnClick event procedures.The button is the easiest way since the wizard pops up once you draw the button and will walk you through the...
  16. lblastick

    Short Question- 100% Percent?

    In Access 2000 you can just use the round function on the result to make it the proper number of digits ROUND(number,num_digits)
  17. lblastick

    Dumb question - How do I remove the . . .

    On properties for the form Format Tab Dividing lines should be NO Hope that works

Part and Inventory Search

Back
Top