Search results

I am just wondering if there is a way to set a form's fields to automatically grow and shrink as needed for the information to be visible all at once, without using the shift F2 feature?

My code is below. It runs fine in VBA, I just can't get it to work as a macro, I would ideally like it to be a button on my form. Option Compare Database Private Function MyFunction() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sSubject As String Dim...

I am having the same problem, I changed it to a function, but when I try to put in the RunCode with argument converted macro title it tells me that the file isn't accessible? If i simply use the pull down menu to find the function it won't allow me to select it.

Thanks for the help, even though I'm kind of slow...talking it out made me figure out what I was missing. My boss just shouted yahoo! from the back of the office when he got his email from it!!!

There are actually 25 fields, including the '0' and 11 is the correct value for the column I need. Are the fields running from the database or the query?

Thanksfor that. Now it is telling me the line: If IsNull(.Fields(11)) = False Then Is not found in this collection

I tried both of these at the end of my code (with the corrected CurrentDB) I still get the same error message...was that the correct place to put them? Is there supossed to be something before the code?

Yes, that is how I got the error message "Invalid Outside Procedure"

What does that mean? I seriously never saw any of this stuff before a week ago, I'm flying totally blind

Yes it does

That should be CurrentDb() I pasted an old copy of my manipulations, either way it still comes up with the same error message when I fun it.

Hi, I have been searching through this and many forums to get an idea of what I need. I had literally never seen Access before this task got handed to me last week! I need to generate automatic email reminders for due dates. From what I can figure it is easiest if I make it all work on a...