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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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 ?- MrAccess
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
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 "+"?- MrAccess
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
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 ?- MrAccess
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
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 ?- MrAccess
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Changing the default-value in a form
It will not work in Mde File- MrAccess
- Post #7
- Forum: Microsoft: Access Forms
-
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...- MrAccess
- Post #3
- Forum: Microsoft: Access Other topics
-
Expressions
Assuming that your "form letter" 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],"Mr. " & [LastName]) and reference [DearName] in your...- MrAccess
- Post #4
- Forum: Microsoft: Access Other topics
-
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...- MrAccess
- Post #2
- Forum: Microsoft: Access Other topics
