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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cblock1025

    MOM 2005 Onepoint DB on a separate Server

    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...
  2. cblock1025

    WMI Crash, DELL management pack

    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...
  3. cblock1025

    Wait for a process to finish, before going to another line

    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...
  4. cblock1025

    Wait for a process to finish, before going to another line

    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...
  5. cblock1025

    Wait for a process to finish, before going to another line

    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...
  6. cblock1025

    How to sort my Data in a Report

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

    How to sort my Data in a Report

    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...
  8. cblock1025

    How to sort my Data in a Report

    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...
  9. cblock1025

    Status bar.....ohhh it would be nice

    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...
  10. cblock1025

    Linking PageFooterSection Text Box with Header Text Box

    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...
  11. cblock1025

    Linking PageFooterSection Text Box with Header Text Box

    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...
  12. cblock1025

    Linking PageFooterSection Text Box with Header Text Box

    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...
  13. cblock1025

    Create a new database with only certain fields from a table

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

    Create a new database with only certain fields from a table

    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...
  15. cblock1025

    Create a new database with only certain fields from a table

    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.
  16. cblock1025

    Create a new database with only certain fields from a table

    Thanks for the fast reply. I will try to put it together and see if I can work something out. I will post as soon as I get something working. If anybody has any other ideas, feel free to post. Thanks. Christian
  17. cblock1025

    Create a new database with only certain fields from a table

    maybe just import certain fields to another database already created <-- Sorry about this. It is not import, but export. =)
  18. cblock1025

    Create a new database with only certain fields from a table

    Hey guys! Just wanted to know if it is possible to automate with vb code a creation of a new database and just inserting certain fields into it. Or, maybe just import certain fields to another database already created. I know it sounds stupid but, I have my reasons. So, I guess using a module...
  19. cblock1025

    Dlookup and update question about criteria.

    Finally I got it to work! =DLookUp("[peso_W_total]","piscina","[dias] =" & Forms!muestreo_semanal!dias-7 & "And [número_de_piscina] =" & Forms!muestreo_semanal!número_de_piscina) It works now. I finally figured how to mix them up with the quotations...
  20. cblock1025

    Dlookup and update question about criteria.

    Sorry, I forgot to mention. The field dias is actually just days it is not a date. Because the company gets data every tuesday the days increment in by 7 so last week was day 140 and this week 147.

Part and Inventory Search

Back
Top