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

Recent content by bkrampe

  1. bkrampe

    Round Down to nearest 16th Inch

    This was the syntax that I ended up using to get my answer. I also discovered that in order for me to get consistent answers, I had to round my Metric # to 4 decimal places. floor([dimX]/1.5875) * 0.0625 as FinalValue Thanks everyone for their help!
  2. bkrampe

    Round Down to nearest 16th Inch

    Sorry I meant to say 415.131256 millimeters mm -> decimals is 16.34375in.~ currently I have... cast((round((itmdim.dimx/25.4)*16,0)/16) as decimal(10,4)) as [dimX (in)]
  3. bkrampe

    Round Down to nearest 16th Inch

    I am trying to take a metric number and convert it to a decimal, then round it to the nearest 16th of an inch. Example 415.131256m -> decimals is 16.34375in.~ Here is were I am running into problems. I cannot seem to find the correct code to round that answer down to 16.3125. Everything I try...
  4. bkrampe

    Problem w/ multiple values parameter in record selection

    Oh man. :O I'm sorry everyone i forgot to change the parameter to a number field. Changed that and everything worked wonderfully. Told you it was probably something simple. I am so thankful its Friday. Thanks everyone. Sorry again.
  5. bkrampe

    Problem w/ multiple values parameter in record selection

    What formula would you put into record selection to pull in the data. I have tried a couple. Seems like any formula i use either gives me a "A number range is required here" or just does not pull in any data.
  6. bkrampe

    Problem w/ multiple values parameter in record selection

    Hi everyone and thanks in advance. I am using CR XI and Access 2003. I have a database with information put in by job number(ex:227488, 227495, etc.) I am needing a report that allows the user to put in multiple numbers and it will only pull in those jobs. I am trying to use the Allow Multiple...
  7. bkrampe

    Crystal Reports accessing .dbf

    It is an oracle database. Where would i be able to locate drivers?
  8. bkrampe

    Crystal Reports accessing .dbf

    I am trying to open a .dbf file in CR XI and am having no luck. It gives me a "Failed to load database information" followed by "Unknown database connection error". The database is for our Time Clock system. Im not even 100% sure that CR can connect to one, but i believe it can. Could it be...
  9. bkrampe

    Disk boot failure

    Yea it was an issue with the disk. It was a bootable disk, i just didnt see the scratch on it. I got a different boot disk and it worked just fine. Thanks for all your help.
  10. bkrampe

    Disk boot failure

    I just bought a new hard drive for my HP s7613w computer and when I try and get it to boot to cd i get the "Disk boot failure, Insert system disk and press enter". It loads past the bios screen then goes to a black screen with flashin cursor then the error comes up. The disc drive is in higher...
  11. bkrampe

    VB Array

    I am trying to write an expression in access that after an item in a drop down is selected, if its ex: (1,2, or 3) then have a lbl say "Non-qualified" else "Qualified". I have looked through the whitpages but did not find anything, but im not totally sure what the name is that im searching for...
  12. bkrampe

    Changing Hard Drives in Server

    I have not been able to locate the .iso format. Link?
  13. bkrampe

    Changing Hard Drives in Server

    I dont have a ShadowProtect CD. I am only using the trial version. Know where i can get one the the bootable cd's?
  14. bkrampe

    Changing Hard Drives in Server

    I am trying to use StorageCraft but can not figure out how to boot to StorageCraft to replace the C: drive. I have read that you need a Recovery Environment CD but can not seem to locate one. Am i right in thinking this?
  15. bkrampe

    Changing Hard Drives in Server

    Ghost 2003, I have read is able to make a copy of the whole server and put it back on a bigger hard drive. Am i correct on what i read?

Part and Inventory Search

Back
Top