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!
-
Run time Error 1004
Hi, It says: RUN TIME ERROR 1004 UNABLE TO SET THE ORIENTATION PROPERTY OF THE PIVOT FIELD CLASS and then crashes. Thanx Ammai- Ammai
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run time Error 1004
I'll try this out.Any other suggestions? Thanks Ammai- Ammai
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
menu item checkbox
Rob, I believe that you can't add a check box ,but you can make menu item checked during runtime,by adding the enabling the property in the click event code: menutitem.checked = true. Hope this helps. Cheers Ammai- Ammai
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
upper case ?
sarah, Use the function Ucase (in the change event of the control)it will convert text entered in the text box or datagrid into capital letters example: Ucase(text1.text) Cheers- Ammai
- Post #3
- Forum: Visual Basic (Classic)
-
upper case ?
sarah, Use the function Ucase it will convert text entere in the text box or datagrid into capital letters example: Ucase(text1.text) Cheers- Ammai
- Post #2
- Forum: Visual Basic (Classic)
-
Run time Error 1004
My Excel Macro queries a DB2 database and populates the results(report) in excel sheet.The macro works fine for majority of report requests, but for some reports it gives the error no : 1004 and crashes without proceeding.It also says unable to set orientation property to the pivot field class.I...- Ammai
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
