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 Chriss Miller 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. precious5

    Exporting a Report to MS Word in Document Format instead of RTF

    I would love to get a copy of this sample if someone could email it to me also, please. Thanks in advance, lorii@ccs.k12.nc.us
  2. precious5

    Error 3759 Scaling of decimal value resuled in data truncation

    Norris68, Thanks for your help yesterday. Once I changed the data type in the database it worked. I still don't understand why the decimal data type would not work and the double did. But thank you.
  3. precious5

    Error 3759 Scaling of decimal value resuled in data truncation

    I think I know why its failing. The previous records have .00. For some reason it doesn't like anything after the decimal point. Any ideas why?
  4. precious5

    Error 3759 Scaling of decimal value resuled in data truncation

    Yes.
  5. precious5

    Error 3759 Scaling of decimal value resuled in data truncation

    Using the decimal it does strip out the leading zeros in the previous reads
  6. precious5

    Error 3759 Scaling of decimal value resuled in data truncation

    The fields are ALWAYS the same length. The program crashes on that statement, so I can't see what is in the field. I have to look at the fields previously moved. I haven't tried the double. I have it as a decimal, which should be large enough to hold the values. I don't understand what you...
  7. precious5

    Error 3759 Scaling of decimal value resuled in data truncation

    I'm putting it into a number field. The value changes depending on the record. After putting it in debug, I'm reading the first 3 records fine then it crashes on this record. The value it's reading is 000000075.60 but like I said this value changes with each record. If I remove the record...
  8. precious5

    Error 3759 Scaling of decimal value resuled in data truncation

    Has anyone ran across this error when tring to import data from a text file to an Access 2000 database?? I've doubled checked my length of the field to make sure I'm getting the correct amount of characters and also the starting position. RunTime Error 3759: Scaling of decimal value resuled in...
  9. precious5

    Importing Flat Ascii Text File

    Can you give me a little more infomation on the DoCommand, please.
  10. precious5

    Importing Flat Ascii Text File

    Hi, I'm new to VB. I need to take a flat text file and append it to my Access 2000 database. I have not been able to find any help with importing a flat text file. I'm not really sure where to even begin with my code. Any help or pointers would be greatly appreciated. Thanks!
  11. precious5

    No current record

    datUser is an DAO. I'm not using an array. UserId is the primary key. The only time the code fails, so to say, is when the user does NOT exist. It works fine when the user is in the table. Here is all of my code: Private Sub Form_Load() Width = Screen.Width * 0.5 Height =...
  12. precious5

    No current record

    When I try this code, I get a compile error.
  13. precious5

    No current record

    When I enter an invalid user id, I get the message "No current record". When I run the program in debug, the error message appears on the Seek line. It does not check for the NoMatch at this point. Once I click on the OK button for the error message, then my msgbox with error...

Part and Inventory Search

Back
Top