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!

Register Log in
  • Congratulations Rhinorhino 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: tezzyr
  • Content: Threads
  • Order by date
  1. tezzyr

    Uint to Longword

    hi, apologies if this is in the wrong forum. I have a timestamp which is stored as as a 32bit integer in a database. I need to convert this integer value back into an understandable format (datetime or string showing 12/12/2007 14:32:01 etc)At the moment is is a nine digit integer 769590025)the...
  2. tezzyr

    time events

    Hi, I have an application which uses crIX on an sql express database. The application deals with time and attendance data for employees of a company and basically stores the time they clock in of a morning, the time they clock in and out for breaks/dinner etc during the day and the time they...
  3. tezzyr

    Estimating database size

    Hi everyone, I'm creating an application which uses an sqlexpress database to store details on company employees. My database has 14 tables but only 3 of them will ever have any more records added to them (the other 11 tables will never be written to once they have been initially populated) I...
  4. tezzyr

    time&attendance

    Hi guys, I'm writing an application using crIX and a ms access database. I'm new to CR so please bear with me and forgive any obvious mistakes :) The report I am writing will show how long a person has been in work, ie total number of hours, minutes seconds between them logging in at the start...
  5. tezzyr

    running a stored procedure from a button

    Hi, I need to create a backup of a database whenever a user clicks on a button. As I'm using sqlexpress, I'll need to run a stored procedure which contains code that tells the database to backup to a file (I've got examples of how to do this). My problem is that I've never really had to run a...
  6. tezzyr

    sql express - backup and restore

    hi, I'm creating an application in c++ which uses an sqlexpress database to store data. I want to be able to add functionality to my application that allows a backup to be made of this database as well as allows the database to be restored from the previous backup. I understand sqlexpress does...
  7. tezzyr

    report showing date 1 month less than current date

    hi, probably a really easy one for you guys, but im a newbie so please forgive my ignorance! I'm trying to setup a record selection filter so that when my report is run, the only values shown on the report are ones that contain a date which is 1 month less than the date the report is viewed, i.e...
  8. tezzyr

    parameters drop down list

    I have a report created in crXI which runs off an sql server db. the report contains a parameter to gather user input which is generated dynamically from the db. when running the report on my machine I see a nicely formatted window which populates a drop down list containing all the companies in...
  9. tezzyr

    string parameter to int

    Im using cr IX on an sql server db which I cannot modify in any way ie change datatypes, add fields etc as an existing application uses the database as it stands at the moment. I have 2 db fields, USER and COMPANY set up as follows USER:- field type userid int username text...
  10. tezzyr

    find what table a value comes from

    I have a value (11832) which relates to an accountnumber in an sql server db. is there any way i can find out from which table this value comes from? eg select * from * where *=11832? i need to add a field to a report but ive no clue where the field comes from and there are 400 tables in the db...
  11. tezzyr

    how to sum fields but ignore suppressed fields

    I have suppression on my details section so that certain records are not displayed on the report. how can i exclude these values from being included whenever I run a summary as they appear to be added along with the values i require to be summed, even though they are not appearing on the report...
  12. tezzyr

    group sum for seconds

    I have a formula which returns a number eg(26,2345.00) ) and displays this value for each record in a group (grpname) I'm trying to add all of these values and display this sum in the group footer. I've created an initialize, evaluate and display formula eg @init whileprintingrecords; numbervar...

Part and Inventory Search

Back
Top