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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel app.visible property in IE
I have several Excel VBA documents that are sometimes automated and sometimes not, so they check the app.visible property to determine whether to display a message box. this works fine, except these documents will often be opened in internet explorer where the excelapp.visible property is always...- Rodiggy
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
SQL too complicated for MS Query
Hi all, In Excel 2000, I want to be able to return the results of an SQL stored procedure that requires parameters which I will get from the user using 3 combo boxes which will get their data from some simple SQL queries. Now, I'm pretty sure I can do all of this except running the stored...- Rodiggy
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Hello all, I have a snowflake di
Hello all, I have a snowflake dimension, 4 levels 1. Region (table1) 2. Building (table2) 3. Group (table2) 4. Name (table2) Most records are unique but sometimes there are duplicates. What's happening is when there are dups the data is getting double counted in my cube. Basically I just want... -
show date even when no rows selected
Hello, I have a query that looks like this: select convert(varchar(12),querydatetime,101) as date, count(uniquefieldId) from CMquery where datepart(month,querydatetime)=datepart(month,getdate())-1 and (majorTrigger=45 or thisfield='aaaa') group by convert(varchar(12),querydatetime,101)...
