Search results

You are the man! I was beating my head against a wall until I read this... If Me.txtField.Value = "" Then The above apparently doesn't work correctly. Huh. Thanks!

I have a form that's recourdsource lists all available classes and has a button that opens a "pop-up" modal form. When a new class is added in the modal pop-up form, they click a "Save Button". I want that button to essentially run the following command on the original form but I'm not sure...

Nope, just wanting to close several forms. I guess I've always had a hard time writing in code that executes without condition. Knowing that Access will just process w/o error means I'll just add that in there now. I guess I was over analyzing this one. But that's why all you nice folks are...

I'm using the following piece of code air code. How would I change this to loop through and close certain forms if they are open. I would you an If ElseIf, but I need each statement to be evaluated so that if multiple forms are open, each one that I specify will be closed. Select Case...

Got it. I have AutoNumber Id's for all tables, so having multiple entries with the joins should still show correctly. I'll do some testing however to ensure. Thanks!

Actually I think I figured it out. Change the Do and DoNot Graduate queries to non-totals queries or just select queries seemed to fix the problem. Was there a reason behind using the Totals queries? Thanks.

Well at first glance it appears that I've found the Property "VotingOptions" and "VotingResponse" for use with the Outlook.MailItem There's a good start. I'll just edit this thread as I go with more info for others/help for me.

You bet. Let me see about zipping up all necessary files (using vPPC and it requires an Access Control DB, Back-End Security DB) in addition to the Front-End/Back-End of my Database. Give me a few hours to strip it down. Thanks a ton!

Thank you both for your input. I'm going to start attempting to wrap my head around all of this and see what I can't start working out. If only this was the sole feature on my plate I was trying to knock out (Haha, but isn't that always the complaint ... always more to do). I'll see about...

Alrighty. Here is the SQL for my queries: qryDoNotGraduate SELECT tblFormEight.EnrollmentID, tblFormEight.MailedDate, tblFormEight.ReceivedDate FROM tblFormEight GROUP BY tblFormEight.EnrollmentID, tblFormEight.MailedDate, tblFormEight.ReceivedDate HAVING (((tblFormEight.MailedDate) Is Not...

Does anyone know how or where I could start to perform the following action: 1. When a particular field has content entered in it and the record is updated, have an email automatically sent through Outlook with the Voting "Yes" or "No" buttons in the email. 2. Then when that email is...

I am going to give this a shot. I can see the logic in my head now, just wasn't able to come up with it on my own. I'll give it a shot and let you know how it turned out. Thanks for taking the time to type that all up for me!

The problem is that I can't specify an EnrollmentID on a form control as I want this query to be run everytime the database is opened and check ALL EnrollmentID's to see if ALL Form 8's were marked as received for EACH EnrollmentID. Does that make sense?

I've got this article here, but I'm really lost on how to implement. Could you possibly help point me in the right direction. I've got the following code sorted out. I know it's not in the proper order, it's just what I've gotten copied over so far. Private Sub Outlook() Dim appOutlook As...

So I have tried using the Import Wizard to import/link Outlook Tasks into Access, and it works great except for the fact that it doesn't include the Subject or Message of the task making it completely useless. Does anyone know of a way to read/import/link Outlook 2007 Tasks from within an...

That's what I thought as well. But when I view the results of thequery I get an #Error in that field and the error: "Data type mismatch in criteria expression" I'm really lost on this one. I can't join those two fields because I get the error : "The SQL statement could not be excuted...

Can anyone decipher what I'm doing wrong with the following syntax: SELECT tblEnrollment.EnrollmentID, tblEvalTypes.Abbreviation, tblOptionsBF.Abbreviation, tblEvalResults.EvalDate, tblEvalResults.FlightExaminer, DLookUp("[LastName]","tblMembers","[tblMembers].[MemberID]='" &...

I could use a little more guidance. Don't think I've ever used a deselect portion of an SQL statement.

Yes. You want each criteria to be on the same line. If you have combo box's I feel as if you may need to include some IIF statements that take into account the possibility of a null value. Same with a Radio button or check box.

If you can attached your db up here and I'll see about taking a look at it.