Search results for query: *

I want to take my picture fields in my database and change the extension of them. My picture field [IN_Pic] looks like this: umpic26923.jpg I wrote this statement: "th_" & Left([IN_Pic],Len([IN_Pic])+InStr([IN_Pic],".")) & ".gif" Now my picture looks like...

I have a field in my database that looks like these examples: W3939 -23433 X343 -12345 W3897 -13 Basically, I want to take everything to the right of the dash and put it in its own field. I'm guessing I'd have to build a custom function to do that. Little help?

I'm getting this error message while running a query: This expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables...

I want to find all products in a table that have both the same picture link & description. The picture link field is a text field (no problem finding duplicates there). The description field is a memo. Every method I try, I come up against a wall. Is there a way to search for duplicates for...

Program works fine. When we compile & install it on some machines, it will go along and we will get Runtime Error '0' followed by Runtime Error '440'. I believe the '0' causes the '440'. Of course, there is absoultely no information out there on error 0. This does not happen on all...

I can get a Crystal Report to pull up in Visual Basic, but the variables I set in Crystal Reports are not prompted for when using Visual Basic. How do I set up the user interface to have the client machines be prompted to put in the parameters I set? Or do have to resort to letting the Visual...