Recent content by cblock1025

Anybody have any articles showing how to install the Onepoint Database separate from the MOM 2005 Server. At our business we like to keep our databases on one box running sql 2000. I found some articles about moving the DB, but not on a new install. Microsofts Deployment guide says nothing about...

Faulting application wmiprvse.exe, version 5.2.3790.1830, faulting module msvcrt.dll, version 7.0.3790.1830, fault address 0x00027d70. Anybody have the same problem? It seems to be the Dell management pack causing it. All my servers use Windows 2003 SP1 and they all have the same problem. I...

Well I molded your code and got what i wanted. Thanks again!!!! Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run "c:\progra~1\citrix\icacli~1\pn.exe /APP desktop", 1, True Set WshShell = Nothing Wscript.Sleep 5000 set svc=getobject("winmgmts:root\cimv2") sQuery="select * from...

I tried out your code. However, it doesn't want to stay in the for loop. It finds the process so it prompts me with "Some process wfica32.exe is still running within the timeout period, and then just keeps going by exiting. I need to be able to keep this program open till a user clicks the x to...

I hope there is someone that can help out a bit. I am out of ideas here. This is the problem: I have a .exe application, and I need to know when it is finished in order to execute another command, which in my case is a reboot. However, here is the tricky part. My executable actually starts up...

Hey thanks so much!!!! It works great. I worked on it last night with all of you guys help. Thanks Christian

Awesome!!!!!!!!!!!!!!!!!!!! Works Great. However, I am totaling the both sub reports which works fine, but I need these two totals to be added at the end of the main report. = Report!ProgressReportPayment!Amount = Sum(Amount) + Report!ProgressReportService!Amount = Sum(Amount). However, I...

Ok, I have a table called transaction contains these fields: TransactionDate, Amount, type = either S(Service) or P(Payment). I wanto to sort these out like this in a report: All my Services on one side and all Payments on the other side: Date Type Amount Date type Amount...

Paul, the progress bar is not real time. However you can fool around with the loop and get it to go faster or slower. I like th frmSplash. Just import that form into your database. Modify it in design view with the colors you want and stuff. Then just call it on any button or procedure you want...

Hey, I already fixed my problem. I just used a Dlookup and got the fileds from my table. However, I find it very weird that you can't really link pieces of data within the same report. Because what happens if you want to show the total of something in the header fro some stupid reason .Anyhow, I...

Well actually all my data is stored in the table not using any sums. Now, maybe there is another way to acomplish this. I have a lot of records in my database catogorized by pool number, however at the end of each month they fill in some extra information(two fields), I attach them back to the...

This should be simple, and I have been trying everything from what is posted but I still get an error. All I want is to be able to link a textbox which is in the page footer section say [total_weight] and set its visible to no. Then in the header put an unbound textbox and read that value from...

Nevermind I got it. Just had to add in a library reference.

Ok, found this, but everytime I execute it I get an error on line 2. Function CreateNewDatabase () Dim DefaultWorkspace As WorkSpace Dim CurrentDatabase As Database, MyDatabase As Database Set DefaultWorkspace = DBEngine.Workspaces(0) 'Create new database specifying the correct...

Ok I was able to transfer the fields I wanted to an existing database. However, the code to create a database does not work. I am going to try to change it around and see what happens.