Search results for query: *

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

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.

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?

Yes.

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

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

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

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

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

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!

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 =...

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

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