Search results for query: *

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

Hey Golom, that looks awsome! I really appreciate your help. Unfortunately, I'm pretty green on VB. In trying to introduce the function into an update query, I"m pretty clueless. Could you point me in the right direction?

Hi, I'm dealing with address fields which I normally don't have trouble with. . .I'll typically use Left, Mid, Right to pull out the component of the address (i.e. 123 main st, baltimore, MD 20122). Now I've got one that is inconsistent that I don't know what to do with. I need to parse it...

I found a simple (albiet crazy) way to do it: I redirected to a new page that included one simply query. . descending list of ID's from the table returning only one record (i.e. my new record). It's a confirmation page that then links to my intended page and takes with it the newly created ID...

I use MS Frontpage for publishing, so this is from that perspective. . . 1. Create a new page and go to HTML view. 2. Delete ALL code, even the <html> tags. 3. Paste this code on the page. This should be the ONLY code on the page: <% Dim DSN, RS, SQL, Conn 'This next line is your...

I've use a nice little open source app called table Editor. Worked great for me because my backend was an Access database that I didn't want to take offline while it was in production. It's beta, but it worked great for me. http://www.2enetworx.com/dev/projects/tableeditor.asp Dave