Who can help me with this?

May 21, 2010 10:25 AM

Where is the best place to look for help with Access? I like and trust the answers I get on AskMetafilter but they are expensive (1 per week etc.) I have a programming question that I need help thinking through.

Here is my issue:
I have a custom function that hinges on grabbing data out of a specific query. It opens Outlook, creates a new email and populates the fields with specific addresses and data taken from the query ("AppsEmail").
Now I want to make a different query ("RequestEmail") and have it populate the email with that data. So all I have to do is change this line:
Set MailList = db.OpenRecordset("AppsEmail")

and that's where I get stumped.

So I guess this a multi-part question:
1. Where is the best place to go for help thinking through things like this? What I would really love is a "mentor" kind of person that I could just hit up on IM, but that seems like too much to ask. Instead I would settle for a good responsive forum.
2. Does anyone have any guidance on my specific problem?

posted by amethysts to computers & internet (6 answers total)

You should try your luck at StackOverflow. It’s free a programming Q&A website. Here's a link to their about page:

http://stackoverflow.com/about
posted by stungeye at 10:37 AM on May 21, 2010 [2 favorites]

+1 Stack Overflow.
posted by MesoFilter at 10:49 AM on May 21, 2010

Nthing StackOverflow, and maybe SuperUser (an affiliated site), depending on how programming-related your Access question is.
posted by Vorteks at 10:50 AM on May 21, 2010

I've posted the question on stackoverflow but who knows if I'll get a response - it's already buried pretty deep.
posted by amethysts at 12:18 PM on May 21, 2010

Amethysts, did you get an answer? Did you tag it Access? Questions get buried deep, but most people look at certain tags. I don't ever read the front page, but mostly track Python, R, and some others (Access *not* among them, sorry!).
posted by gregglind at 9:40 AM on May 27, 2010

I did get an answer, thank you, probably thanks to my tags of access-vba, ms-access, and vba.

The answer was to make the query that I wanted an argument in the function's definition like so:

Function CustomEmail(NameOfQuery As String)

CurrentDB.Openrecordset(NameOfQuery)

End Function


and then when I call the function it looks like CustomEmail("QueryThatIWant")
posted by amethysts at 10:41 AM on May 27, 2010