Recent content by Darrick

The PagesServer or ReportJobServer cannot locate the MS Access DB. It sounds like you have it on a mapped drive. Change the logon properties of the Page or ReportJob Server to log on using a Domain level account instead of the System default logon. Make sure that you Domain account haves...

Ahh... Yeah that would be it. God loves stupid mistakes also! Thanks again, Darrick

What is wrong with my code below? It continues to throw the following error: Server: Msg 207, Level 16, State 3, Procedure InsertProbationStopDate, Line 8 Invalid column name 'Emp_Probation'. -- Trigger valid for multirow and single row inserts -- and optimal for single row inserts. CREATE...

Thanks, but that was the first place I looked. The help really didn't provide much help on what I can do. More or less stated how to put an index on a table and said that it could be applyed to a view as well. However, I haven't had any luck with that method. Darrick

Hello all, I am having some trouble with a few of my views. They are timing out, and I would like to optimize them by adding indexes. I am not sure how to actually do this. Any help would be appreciated. I am using SQL 2000 Standard. Thanks again, Darrick

I have a report that runs on demand and rarely returns any data. I want to put a formula in the report to display if the query doesn't yield any data. I have seen this done numerous tims however, when the query doesn't return anything none of my sections display, not allowing me to put a...

Bump. Still looking for someone to assist with this problem...

I have searched the web high and low for a snippet of code to popup a menu with the standard Cut Copy and Paste commands based on the coordinates of the mouses location. I can do this in other VBA applications, however I cannot get it to to work in MS Access for anything! Does anyone know how...

We are having a problem with supervisors and others deleting agent logins after they have left the company or department. This causes our stats. to be skewed as it deletes all of the history associated with that logon. Is their a way to restrict who can delete agent logins? Thanks for your...

I've been reading and trying to comprehend Data Mining so I can apply it to several lines of businesses within my company (Mainly a call center environment.). However, I'm just not getting the hang of it. I am using MS Analysis for Data Mining, and have found that I need some sort of...

I'm trying to connect to a database using the Simba Client. I have created an ODBC DSN to connect to the necassary server. I can use this driver to connect to the DB using Excel, Crystal 8. My problem is that my company uses Curystal 9, and no matter what I do, I can't get it to work. It...

SuperNN, Can I also get a copy of that guide? Having a hard time with Symposium and validating all of its information. I'm use to the Avaya Definity G3, big difference. Any advice? Thanks, Darrick darrick AT pscufs.com

Thanks, I figured out the connection string... .Application.LogOnServer "ODBC", "PSCU FirstTrack Reports", "FTPS_DS", "FTRK", "FTRK"

PLEASE HELP!!! This is what I have so far, but I can't get the "LogONServer" string to work! What's wrong with it??? Thanks again, Darrick Sub OpenReport() Set Report = crxApplication.OpenReport("G:\Statistics\Crystal Reports\Daily Closed Report.rpt", 1) With Report...

Please help! I've been racking my brain and reading posts trying to figure out how to open a CR v9 report that requires a UserID and Password. I'm able to open and manipulate a report just fine. However when dealing with a database that requires a "Logon", I can't get VBA to pass...