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!
-
Error registering servers in Analysis Services
Can anyone help? I keep getting an error message registering my server. On connection I get the error "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" I have installed SQL2K Sp2 and Analysis service SP2 but to no avail. Any...- sebkerr
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Macro to run automatically in a specific date
The best way is to schedule the database to open and the macro to run using a scheduler prorgam, such as Scheduled Tasks. The commandline is something like this: Path of the database to open /x Name of the macro to run e.g. "c:\test.mdb" /x "mcrTest" Sometime you have...- sebkerr
- Post #2
- Forum: Microsoft: Access Other topics
-
Printing Reports
There are a copule of ways to do this. You could either have the report running from a parameterized query, so when the user opens the report it then pops up a dialog box, such as "|Enter Month?" Another way is to setup a form with a combo box, where the rows are the months to...- sebkerr
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Get Age from BirthDate field in a Query
Try this. It seesm to work fine, regardless of if it is your birthday or not. Right$(Year(Date()+1-[birth_date]),2) Hope this helps Sebkerr- sebkerr
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
