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 Mike Lewis 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. 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?
  16. bkrampe

    Changing Hard Drives in Server

    We are currently running out of space on our server and we require bigger hard drives. I was just wanting to make sure that if i used the backup utility that comes on SBS 2003, that i would be able to reload it back onto larger hard drives and not incounter problems. Any thoughts? Thanks in...
  17. bkrampe

    Parameter is incorrect

    Not sure if you have subreports in your report, but this is the way i solved mine. I looked at how the subreport was linked then saved the subreport separate("Save subreport as" To desktop or anywhere) then deleted the subreport off the main report. Then i went back and readded the subreport...
  18. bkrampe

    Parameter is incorrect

    When i try and open a report with CR XI on a computer it does not let me it gives me a "Parameter is incorrect" error and does not open the report. But if i try and open it on a different computer it works perfectly fine. Can someone please help me with this. When i tried to search this error i...
  19. bkrampe

    Criteria Forumla in Query

    After your previous message i went and searched for dependant combo box and found it. I didnt know what they would be called. Thanks for all your help Remou. Sorry if i inconvienced you.
  20. bkrampe

    Criteria Forumla in Query

    I am trying to make it to where if i select Maple in a Species combo box that then it changes the criteria in the PartID combo box to display only the ones that have to do with Maple. All Maple entries have a MaterialID of 1 and all Cherry entries have a MaterialID of 2. So when you change the...

Part and Inventory Search

Back
Top