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 bkrike 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. ChrisCalvert

    Uninstall Office Component, via Command Line

    I need to know if there is a way to uninstall a component of Office using the command line. Normally I do something like: msiexec.exe /x ?????????? /qn But this, being a component and not a full product, has me stumped. Has anyone done this or know how to do it?
  2. ChrisCalvert

    Command Line Uninstall for Frontpage?

    Does anyone know the command line uninstall for Frontpage? I can't seem to find a way to uninstall (just) Frontpage from the command line.
  3. ChrisCalvert

    Prevent a particular file(name) from being created.

    Is there a way to forbid a particular filename from being created? I am running a program that drops a logfile on my desktop. I don't use this file, and the program doesn't provide a means to change the location, or to disable logging.
  4. ChrisCalvert

    Activate Excel add-in programmatically

    Hello: I am deploying an Excel add-in and though it installs properly, it does not 'activate'. That is, the user would still have to go Tools>Add-Ins and check the new add-in. Is there a way to do this for them via command line or a simple script/reg file?
  5. ChrisCalvert

    AIX system (or base) software

    Bit of a strange problem here. Let me say that I know almost nothing of AIX, I just need to identify what software on our AIX boxes is base or 'system' software. That is, what is installed with the OS. I have a list of software that I am getting from a Tivoli scan. What I need to know is if...
  6. ChrisCalvert

    Hyperlinks included in email regardless of option

    I am trying to send out a scheduled report as an attachment through the Management Console, however the email keeps including the viewer hyperlink. I don't have this option checked, and don't want this link included (the people getting the reports don't have accounts). Has anyone else seen this...
  7. ChrisCalvert

    Recordsets, Queries...how should I do this?

    I have two tables. Account with the (relevant) fields ACNTNO - Primary Key, the account number OPNDT - Date/Time, Date account opened EFFDT -Date/Time, (will explain) and Sales ACTNO- account number RPTDT - Date/Time, Timestamp for this Volume (I.e. 6/1/04 is June'04 sales for this account)...
  8. ChrisCalvert

    Copy files from dead system

    I have a friend who's XP install is getting stop error :UNMOUNTABLE_BOOT_VOLUME. I've read all about it and I none of the solutions with CHKDSK or the like work. I hooked it up to my own working system and I can see most files, but the ones she really wants are in her My Documents folder, and I...
  9. ChrisCalvert

    Access a server DSN for webform

    I am trying to use a webform that saves to a system DSN on the server (that is, the server to which I publish the web). When I go to the forms properties, (or the web settings) and try to add a connection, and choose a system DSN, it only shows system DSNs of my local PC. What I want is a DSN on...
  10. ChrisCalvert

    Query, average of all found for each value

    This is a complicated (to me at least) query that I need to get done. Here is what I have: {Table1} ID, Xavg, Yavg,Zavg {Table2} ID, A, B, C, Xn, Yn, Zn What I need is a query that looks at record where: Table1.ID = Table2.A OR Table2.B OR Table2.C It then averages the Xn, Yn, and Zn of...
  11. ChrisCalvert

    Refer to variable cell?

    Hello: I need a way to refer to a cell based on the contents of another cell. That is something like this = (OtherSheet!A|A1| ) This would refer to the cell in column A and row (Value of cell A1 in this sheet). Can Excel do this? Thanks in advance for any suggestions or answers. -Chris Calvert
  12. ChrisCalvert

    Export group totals to csv without detail lines.

    Hello: I have a report that shows the monthly averages of performance monitors for phone agents in our company. The only things that need to be in this report are the agents name and average. I have nothing in the details section and have the report grouped by agent with an average field that...
  13. ChrisCalvert

    A calendar control in a form sends value to field?

    Hello: This may be answered, but every search over one word seems to be returning no results today (or maybe I am just searching on odd words). What I want to do is , I think, not very complex, but I can't seem to get it. I just want an activeX calendar control to insert the date into a date...
  14. ChrisCalvert

    AutoExporting Report, automation, command line?

    Hello: I have a report that I need to run on a daily basis. However, this needs to be expoorted into a comma delimited file. Is there any way to add a macro or command line parameter (on a shortcut) so that you just click the report icon, and the file exports, instead of opening to view? I need...
  15. ChrisCalvert

    Show only groups with 6+ members

    I have a report and it has been requested that I have a companion report that just shows the Groups that have more than 6 members. I am hoping that someone could help with as suggestion on how to do this. I have added a count to the group footer, but I am not sure if this helps,and am a bit...
  16. ChrisCalvert

    Get date only from DateTime.

    Hello: I have what I thought would be a simple problem, but I cannot find an answer so far. I am trying to run a query on a table with a datetime field. I just want my resulting table to have the date (for purposes of counting). Does anyone know how this can be done. I thought...
  17. ChrisCalvert

    Running Count? Report Chart

    Hello. What I have are a list of customers that have signed up. I have a chart that shows how many signed up per day. However, what I also want is a chart that lists the total number of records each day. I can't really figure that second one out. Could someone assist? It would be much...
  18. ChrisCalvert

    Left function yeilds #Error

    I am trying to use a text box in my report that has the control source set to '=Left([MyField],4)'. And I get #error. This is in Access 2000. Can I just not use this function in areport, or is there something I am missing? The data type of MyField is Text.
  19. ChrisCalvert

    Print section every X pages.

    I have a report that is to be faxed. The company requires a fax sheet every 10 pages. I thought I would just make this the page header, with a new page after, and have it print only every 10 pages. Anyone done this before? I am having a hard time deciding how to approach it. Thanks in advance...
  20. ChrisCalvert

    Decimal Days to X Days, X Min, X, Secs.. already exists?

    I have two date time fields that I am subtracting to get a decimal value, which is days. I am only using this because I cannot average the DateDiff field that I get by using the UFL file that I downloaded from crystal's Website. What I need is the value like Xdays,Xmin,Xsec on each record, and...

Part and Inventory Search

Back
Top