Search results for query: *

Sorry for the multiple postings -- I keep having second thoughts, like Columbo. My hope is that someone knows how to edit this simple query to NOT truncate the results without having to write it to a table as described in my previous post. Here is the simple query I am running that truncated...

I am having the same problem with any of my queries (and even importing from Excel, which I had to do using VBA). Access evaluates all queries of "memo" fields as "text", which is really stupid since Access knows that it is "memo". I found a solution that is not the simple one I wanted, but...

That worked! Now that I am doing my real project using this, I come across another problem involving quotes. Perhaps you have an idea about this: Some of my data are descriptions that include the single quote as part of the text, such as "Ann's prior will". When I do my SQL string, it doesn't...

I am following a simple example to learn to do a simple thing, to add a table to an Access database and add records to that table using SQL: Here is the tutorial site http://www.fontstuff.com/access/acctut16.htm The add table works fine for me, but the adding values example gives me the...

More than an idea -- that did the trick! Thank you!

When looking at a webpage that contains tables of data, simply saving the webpage as a .txt file will save it pretty much as it appears on the web without all of that html code. That is what I would like to do using VB6. I would like to accomplish this similar to the discussion on forum...

Well, it works SOMETIMES. I think there is a timing problem. Not all images download. I'm trying this on a directory of 34 images. The program is going right down a comma delimited list and getting the image off the web and saving it onto my harddrive. However, it always downloads the same...

johnwm, Thank you so much for recognizing just how basic my knowledge is. It works perfectly! Harleyquinn, Thank you for your post to Reuel or I'd never have gotten on the right track at all. Thank you, Thank you! Actually, this seems an appropriate time to shout: THANK YOU! YES!

I tried the simpler version as outlined at: http://support.microsoft.com/kb/q244757/ Private Declare Function URLDownloadToFile Lib "urlmon" Alias _ "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal _ szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long)...

Reuel, Harleyquinn, thanks to you both. This is exactly what I want to be able to do. But I am still having troubles. I am using VB6.0. Although I followed Harleyquinn's advise, I am not able to make it work. I get the error message: "Compile Error, User-defined type not defined". In...