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!

Search results for query: *

  • Users: bkrampe
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. bkrampe

    Criteria Forumla in Query

    I am having a problem getting the code i need in the criteria section of a query. The query is looking at a table that has 2 columns the second one being a partID (1,2,3,etc.) The PartID combo box is looking at the query and when a Specie is selected i only want certain ones to show up. For...
  9. bkrampe

    Updating information in two tables from one form

    I was wondering if someone could help me with a formula. I have a number field in one table that is linked to a form. I want when that field is updated i want it to change the information that is stored in another table. The form is linked to Table1 and i want it to update the number field in...
  10. bkrampe

    Security Tab

    I am having an issue with the security tab dissapearing on my SBS 2003 SP2. I have looked in the GPE and made sure that the option to hide it is not enabled. But it still is not there. I am logged in as administrator. I was curious if there was another spot that could make this tab disappear.
  11. bkrampe

    Monitoring Configuration Wizard errors

    Whenever i try and run the Set Up Monitoring Reports and Alerts I get to where it should be doing the setting up and then it gives me errors for all the steps: Configuring Data Store, Configuring Data Collection, Configuring Alert Thresholds, Configuring Reports. The MSQL$Monitoring service is...
  12. bkrampe

    Need to pull in picture

    Is there any way to use a filename of a picture to get that picture to appear in a report?
  13. bkrampe

    Not allowing Blank records

    I have a form that adds records and a form that is supposed to delete records in the same table. But when i try and delete the record, it only deletes the information and leaves the blank record in the table. Any help on how i can get rid of the blank records? Thanks in advance.
  14. bkrampe

    Find Record to Delete

    We have a database that when you scan three barcodes, one for the Material Code field one for the width field and one for the length field it fills them in accordingly. Then when u press add, it adds that record into a database. What I am wanting to do is, create a separate form that when you...
  15. bkrampe

    LAST EDIT BY

    Is there any way to report on a form when and who made the last edit? Even if i could just get a computer name as who, that would be good enough. Is it possible?
  16. bkrampe

    Decimal to Fraction

    I was wondering if it was possible for CR XI to convert a decimal # to a fraction on its own.
  17. bkrampe

    Delete the three right letters in a string

    I was wondering if there was any code to delete the 3 right letters in a string automatically when it was inputed into a report?
  18. bkrampe

    Creating a loop

    I have an option that i choose how many times i would like something to show up and I am trying to create a loop that will work. I put in a quantity in a database and then when i run CR i would like it if i were to type in 3 it would return the information like this. Data Data Data The problem...
  19. bkrampe

    Automatic Exporting of Report

    What I am trying to do is have CR XI export to a pdf, and have a macro automatically update the report every hour. I am not familiar with creating macros and was wondering if this is the way i should be going about doing this. And if so, how would I go about creating this macro. Thanks in advance.
  20. bkrampe

    Slow reading reports

    The problem we are having is that CRXI is reading the records very slow and it was goin incredibly fast. It was a short time between the changes. There were two things that happened between the differences: 1.Someone opened the database while it was being edited, they didnt change anything, just...

Part and Inventory Search

Back
Top