Search results

Paul - I'm sorry but I think I am just being dense about this... I've tried the better part of the afternoon to figure out how set up a public function for the criteria and I'm getting no where. I'm really not even sure this is what you meant for me to do... This is what I have so far...

I'm having a little trouble getting started with my Do Until loop. I think I understand the structure I need to use except that I'm not really sure how to get the loop to execute my query using the values from the control list as variables. Basically, I want the loop to execute the query and...

I seem to recall getting a similar error when setting up my e-mail function and it had to do with referencing the correct library. Try the steps below and see if it helps... Extracted from http://www.jephens.com/2007/05/13/how-to-send-e-mail-from-ms-access-using-outlook 1. In the module...

First look - you should not have functions in your group by clause of any SQL statement (at least to my knowledge). Try taking them out and see how it runs...

When you do the export, does it have to be a date format? Why not just export it as text? If you are sending it out via FTP, I'd venture that it doesn't read as a date during transmission, regardless...

Well, I'm no expert but I would replace sql = "Update USERLIST set password='" & txt_pwd.Text & "' where userid='" & userid & "'" With this: sql = "Update USERLIST set password='" & txt_pwd.Text & '" where userid="' & userid & "'"

Well, Here's the deal... The Column [People Group] actually had a space after the "p" so it is actually [People Group ]. The field [Person Type] is, infact [Person Types] (why it is plural in this case, I'll never know...). In any case, with those corrected, the code now runs perfectly.... I...

I've done that (several times, actually) and everything looks correct (spelling, format, spacing, etc...). The table MyEmailAddresses is actually a UNION Query. Would that have an impact?

This solved my problem with simply eliminating decimals when I call the value into a text file! Thanks Galaxiom!!

Well, its a new week and we have new mysteries. For me, the mystery is why my code below keeps giving me the error "Run-time error '3265': Item not found in the collection." Please note that the debug shows me that the error occurs on the specific lines are where I'm replacing [[Grp]] and...

Okay, this is just one of those really bone-headded mistakes.... I Googled the original error received and came up with this article (http://support.microsoft.com/kb/312851)... What it says in a nutshell is that you can't have a function that has the same name as any other function or module...

David - I'm afraid I must further display my ignorance... I don't know how to do a "debug.print" or where to find the results if I did.... Can you please point me toward a primer on using that function?

It's in the newPath!path (stored value in a table)... The code works without the "\" if I hard-code the file name and such. Would it still be required here?

Once again, I can't quite figure out how to get what I need... I am working with a user defined function that accepts 3 values. I am using TransferText to load files into specific tables in my database. If I code each one individually, my code works great (thanks to the help I get from you...

Okay... now I got it! I had tried moving the replace sataements but I was not moving the MyNewBodyText = MyBodyText line with them. Once I moved all three inside the loop, it appears to work! Thanks yet again guys!!!

At the risk of sounding a little too dense, where would you suggest placing the replace statements? I've moved them around several places and still can't get it right. It seems like I just keep guessing wrong....

Okay gang... I hate to drop a big one on you like this but I'm stumped as to why this doesn't do what I expect it to. I am using a nifty little piece of code I found at http://www.jephens.com/2007/05/13/how-to-send-e-mail-from-ms-access-using-outlook which uses MS Outlook to send e-mail...

Excellent! Thanks Ray... I don't think I would have thought to use the Dir function!

Hey gang.... Next topic - Error Handling! In the code below I'm trying to evaluate the value of strPath to determine if the file specified exists or not. If it doesn't, I want a message box to come up and the function to exit. Obviously, I'm not doing it right but I really have no clue how...

That is the part I want to pass as a variable. When this runs there are at least 9 files that get loaded. I can repeat this code 9 times and get everything but I'm thinking in terms of simplification thus the idea of passing to file name as a variable. I really don't want the user to select...