Who can help me with this?
May 21, 2010 10:25 AM Subscribe
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?
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?
+1 Stack Overflow.
posted by MesoFilter at 10:49 AM on May 21, 2010
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
posted by Vorteks at 10:50 AM on May 21, 2010
Response by poster: 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
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
posted by gregglind at 9:40 AM on May 27, 2010
Response by poster: 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
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
« Older Historical sources for the Passion narrative of... | Can the cool kids park in the back? Newer »
This thread is closed to new comments.
http://stackoverflow.com/about
posted by stungeye at 10:37 AM on May 21, 2010 [2 favorites]