Recent content by dpav29

Hi, I am attempting to write fields from a form and sub/sub forms to antoher table. I can make it work with numeric values, but not with text. I've tried various combinations like 'text' and "'text'", but can't get it to work. The way it is below, i get an "enter parameter value" popup on...

Thanks for all your help! I got it working by formatting the unbound fields as Text when using division (and using the proper operand /).

Well. . .that's news to me! I had it with \. At first try, it didn't change anything, but i've switch formats so many times, that might be the problem at this point. How would you say the formats should be set. Im calculating using an unbound field (which is populated useing a fomula from a...

Thanks for trying Aceman, but that didn't do it! I also tried removing all the "if" statements so it was just a simple calculation (A\B), but. . .same bizarre problem!

The fields in the table are formatted as double, but i've also tried decimal (i don't see float anywhere). The form fields, both bound and the unbound calculated fields are fomatted as standard, but i've also tried fixed and i have decimal places set at 4 everywhere. I've seen some posts the...

Yes. . .they are formatted the same way, but will not produce a result less than zero, and if greater than zero, it rounds to the whole number. . no decimals.

All, I've read what seems like 100 posts related to rounding problems. . .learned some things, but haven't found quite what I'm looking for. The table fields and associated form fields are formatted to accept the numbers I need (mostly decimals and many less than zero i.e. 0.1655) If I type...

This thread has been going for over a year. . .wow! I want to upgrade a profile 4. . .would the advice be any different?

And I started doing it that way using find/replace. Access will only replace around 8000 at a time, so . . .

Thanks! Golom's suggestion was the easiest! Sorry for not finding the threads myself. . I became frustrated while searching. For some reason, after reading a thread I can no longer click the back but to get back to the search results. I have to keep typing in the same search over and over...

I'm a little confused about what you're trying to do, but I think it is easily done in the query by design grid. If fueltype 1 is gasoline: New Update query add fields fuelword and fueltype criteria row of fueltype = 1 update to row of fuelword ="gasoline" Then run it again on the criteria...

I need some advice on how to get rid of a bunch of spaces in name field. There are 250,000 records and the name field is a mess. The format is FIRST MI LAST with no comma's. The problem is that there is almost always multiple spaces between the name parts. It looks like this: JOHN...

This Expression: Trim(Mid([TempName],InStr([TempName],",")+1,InStrRev([TempName],",")-InStr([TempName],",")-2)) in an update query works fine on my machine. However, when I give the entire database to another user, he gets a type conversion failure. Same access version (2003). What could be...

I am pasting table info from the web into excel. If I do a straight paste, the column formatting comes over clean. If I do paste/special/text, the formatting is messed up. The problem is that each time I paste, excel stops responding for up to 2 minutes before completing the paste. I'm...

I'm working on another list of names that I need to parse into 3 sections (first, Last, Degree. . .they are doctors). I'm having trouble with first name in some instances when there is a suffix (i.e. Jr. or III). The format is always Last Name, First Name, Degree I'm using the following to...