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!

Register Log in
  • Congratulations Westi 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. MrAccess

    How to JUST get nonsystem the windows' hwnd?

    API GetWindow get all the windows hwnd. But I don't want to get the system's window, I just want to get the window's title which saw in ALT + TAB ,How ? Also the hidden nonsystem windows' hwnd(s) and titles ?
  2. MrAccess

    How to send key "+" or "++" and so on?

    Dim strTest As String strTest="+" ' Or "+++" and so on Sendkeys strTest, True An error occurs when the codes run. How can I use Sendkeys to send character "+"?
  3. MrAccess

    How to set the toolbar's Height ?

    Thought I use code to set the toolbar's height but it dosen't seem to work.(I Want to keep it at a fixed height no matter how many buttons added) Set width is OK. Can anyone help me ?
  4. MrAccess

    How can I move the command button ?

    I want to move a command button from the form's page footer to the page header, How Can I do thia with VBA code ?
  5. MrAccess

    Changing the default-value in a form

    It will not work in Mde File
  6. MrAccess

    HELP with expression

    METHOD #1 Continue with the same technique you used from my previous post. Field 1: Description =IIF((nz([Old ESUP]-([Old ESUP]*[Old DKLPCT])-[Old MPA])<>nz([ESUP]-([ESUP]*[DKLPCT])-[Current MPA])),[Description],'') Field 2: Item Number =IIF((nz([Old ESUP]-([Old ESUP]*[Old DKLPCT])-[Old...
  7. MrAccess

    Expressions

    Assuming that your &quot;form letter&quot; is an Access Report, Either in the query for your form letter or in the textbox control on the form letter If using a query create a column DearName: =IIF(LEN([FirstName])>1,[FirstName],&quot;Mr. &quot; & [LastName]) and reference [DearName] in your...
  8. MrAccess

    Expressions

    dsk525, One solution is... Include the test (nz(Field1 expression)<>nz(Field2 expression)) in the iif of each field EXAMPLE Field 1: OLD PRICE =IIf([Old ESUP]>0 AND (nz([Old ESUP]-([Old ESUP]*[Old DKLPCT])-[Old MPA])<>nz([ESUP]-([ESUP]*[DKLPCT])-[Current MPA])),[Old ESUP]-([Old ESUP]*[Old...

Part and Inventory Search

Back
Top