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: *

  • Users: Shazza
  • Content: Threads
  • Order by date
  1. Shazza

    Parameters and Stored Queries

    I am new to ServiceCentre and am using 6.0.2.0. What I would like to do is create a stored query that a user can be prompted for a date which in turn would become part of the query, and display the results. ie. All calls closed on <enter date> Can anybody point me in the right direction on...
  2. Shazza

    Document disappear when using alt+tab

    I have a document with a toolbar which brings up a dialog box in which you enter information. When this dialog box is open, and I want to alt+tab to another document that I have open - there is only one document shown. If I then close down the dialog box and alt+tab, I can see all my open...
  3. Shazza

    Difference between Parameter Query and Find Record

    I am accessing an access database via a vb script using ADO. I was wondering what was better 1. A predefined query in Access and then pass the parameters through the command object? 2. Return the entire table and then use rst.find? Thanks
  4. Shazza

    Writing XML Attributes

    I am new to writing XML, and I am trying to write an XML document using XmlTextWriter. I am trying to achieve the following: <app summary="addfsdf" sample="asdasdf">value of element</app> When I use the WriteAttributeString method I get the attributes added correctly, but I am unable to get...
  5. Shazza

    Functions available in AssetCenter v3.6

    I am trying to create a couple of wizards and would love to use the DaExecuteActionfromName function which according to documentation that I have is available in Version 1.0. When I use this, I get an error message telling me that the function is not defined. Can I use this function, or is...
  6. Shazza

    Formatting Strings in AssetCenter 3.6

    I have the following calculation which returns 567.9099393 Set [FV_ClientBuy] = cDbl([Product.mPrice]/(1-0.7)) I would like to know if there is a function that will allow me to round this number to 2 decimal places. I am trying to populate a string field, and it needs to be a string for other...
  7. Shazza

    Server has not yet been opened

    I have a report written in CR 8.5 and I am running this via Visual Basic 6.0 using the RDC. When I run the following code I get 'Server has not yet been opened' error message oCrystal.LogOnServer &quot;pdssql.dll&quot;, settings.Server, settings.Database, settings.Login, settings.Password The...
  8. Shazza

    Import script from Action script

    Is there anyway of running a .scr file from within a action script? or wizard? I have AssetCentre 3.6.
  9. Shazza

    Group on non database field

    I would like to have a subreport display for every month of the year. I don't have a field in my database that will display a group for every month. Can I set up a formula that will allow me to use this to group.
  10. Shazza

    Compare two databases

    I have two databases, with identical tables in them. One with older data. I need to update some of the tables in the older database with the changes from the new database.
  11. Shazza

    Compare two databases

    I have two databases, with identical tables in them. One with older data. I need to update some of the tables in the older database with the changes from the new database.
  12. Shazza

    Restore page that is minimised

    I am currently opening a page with the following code, function ShowDetails(value) { var filename window.parent.open( &quot;ProSoftFileDetails.asp?id=&quot; + value, filename) } This successfully achieves my goal of not creating a new window each time the function is called however if...
  13. Shazza

    Database schema

    I have been asked to write some Crystal reports from our Action Request System. Problem is, the database tables are called T155, T155C536870922 etc, and the field names are just as bad ... Does anybody have a database schema that I can look at, or give me any help. Thanks
  14. Shazza

    Coverting from Lotus Notes to Microsoft Exchange

    I am after information on migrating Lotus Notes .nsf files to Mircosoft .pst files. Can anybody help.
  15. Shazza

    Converting to MS Exchange from Lotus Notes

    I am after information on migrating Lotus Notes .nsf files to Mircosoft .pst files. Can anybody help.
  16. Shazza

    Help with Peregrine AssetCenter API's

    I am trying to use the AssetCenter API's and can't seem to get them working ...
  17. Shazza

    Evaluation Version Crystal Reports v8.5???

    Hi - does anyone know if its possible to download v8.5 for evaluation. We are looking at upgrading to try and fix reporting problems.
  18. Shazza

    Exporting to RTF via MAPI

    Has anyone seen this? When we export a report to RTF using MAPI the fields duplicate or overlay each other so it looks like the text is all 'squashed up' when whats happened is it seems to have duplicated the field and overlayed it onto the original? Thanks
  19. Shazza

    Saving as lower version

    I need to be able to save my crystal 5.0 report as crystal 4.6. When I run my VB program, only those reports created in 4.6 work.
  20. Shazza

    Subreport not printing on first page

    When I run my report, my subreport is over a page long, therefore the subreport is starting on the second page, instead of under my page heading on the first page. Is there any way of fixing this? Thanks

Part and Inventory Search

Back
Top