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?

Very good point with the "Not In" statement. I have actually never used that one before. This is helpful, but still does not solve the problem. I'm not sure the issue is in the SQL statement so much that is in a setting on that particular computer. There is nothing really complex...

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

This is definitely a windows setting of some sort. We are getting it narrowed down. We use a data grid not part of VB in this application. We are 90% confident this is causing the problem. Still no fix. It is from VB accellerator and it is called S-Grid. Don't let memory size fool you...

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

Don't feel left out Keeno. I am having the exact same problem here. I don't have problems accessing tables on my local machine. It only happens across the network. And it is neither database nor table specific and is quite random. This is both a networking problem as well as an Access...

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