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 derfloh 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. asbach

    vbIgnore and subform

    Hi Remou! I have an Access2003.database, and there a form, where is a subform. Sorry Remou, I stated misleadingly "report" in original post. I enter data to both forms: 1. Main form collects main data. 2. Subform collects data, which is linked to main. In reports I use same method. Now...
  2. asbach

    vbIgnore and subform

    Hi! I have a dilemma with Ignore-button (vbIgnore). It ignores values well in main report, but not in subreport. How would I get values in subreport to be ignored? Rgds Asbach
  3. asbach

    Access&VBA focusing problem

    Hello! I am truly just beginning to even think to make any forms&reports and I am totally stuck/lost in very simple issue. I am using MS Access 2007 and its VBA tools -no special VB-application at hand. There I have few tables, without any relationships. I have table A, where I have fields "x"...
  4. asbach

    Count bolded fields, which are strings

    Hi guys! I am using Crystal Reports 10 with SQL 7.0 and I am lost. I have a subreport and I have bolded a stringed field (Left({table.field1}, 1) & Left({table.field2, 2). Result is on detail section: VPU JRI MIL RHA If my condition matches, then the field is bolded. That is not a problem...
  5. asbach

    Converting a string to a number

    Thanks's Gary. There was one dot, which was then changed to comma. That helped, although all calcultations have to be cross-checked. -Asbach
  6. asbach

    Converting a string to a number

    Dear all, I have had a little bit time to investigate this problem. I have a simple test as 'ns130' suggested. That works well. I have learned that all values, which have fractions (like "130,44") are being converted to "0,00" but all values, which are not having decimal values (like...
  7. asbach

    Converting a string to a number

    Hi Naith. I have accomslihed some testin and at least it works... :) Asbach
  8. asbach

    Converting a string to a number

    Hi dgillz! As I explain, I had a field, where all numbers were form 'xx.yyyy'. Somehow in database the field was non-numeric string and therefore I had to convert it to numeric. By using "replace" I changed all dots to commas ('xx.yyyy' to 'xx,yyyy') and then used "ToNumber". If you meant that...
  9. asbach

    Converting a string to a number

    Thanks ns130 andd gillz! However, the final solution came using "replace"-function, where I replaced all "." to ",". By that I could just use "tonumber" in a simple way without if-else operator. Regards Asbach
  10. asbach

    Converting a string to a number

    Hi all! I have a problem: In my database there is a field, which is actually a value of money (like 20.00 or -245.9555 or 1340 etc). Somehow it is determined to be a 'string' evethough it should be 'number'. Now, I try to convert it to be a number using 'to number'-function. My Crystal Reports...

Part and Inventory Search

Back
Top