Search results

Have you looked into ACC: How to Detect User Idle Time or Inactivity? That could be modified a little bit to achieve what you need.

Hello Stev, Welcome to AWF :) I just came across this : https://stackoverflow.com/questions/29119359/microsoft-access-2010-visual-basic I would just like to point out to you that, although it is OK to cross post, it would be a good practice to let others know you have similar question asked...

Just Googled this, and got a hit on this link http://www.eraserve.com/tutorials/MS_ACCESS_VBA_Get_Indexed_Fields.asp

Your question might need a little bit more details.

Could have made the Form Read Only.

Hello VaYooper, Welcome to AWF :) Well to be honest, there is not much info on why you get the info. The problem being you have not showed what you have the combo box, the rowsource of the setup. Regarding your second query. So you want a Combo Box to have three options, within year...

SQL Please. :)

Could you post your actual SQL Query please?

You could use an IIF, something like, NewField : IIF([OldFieldName] < 0, 0, [OldFieldName])

Please for the love of Pete, Please use Code Tags when posting VBA Code

Okay, how about taking one step back and calmly explaining what is that you want to achieve in simple English, without any technical jargon?

Try the Val Function. ? Val("7pol2try36") 7 ? Val("12cet9fre55") 12 ? Val("10yea3gtr77") 10

Something like this is what you need, WHERE (([Survey Schedule].[Field done] = True) Or (([Survey Schedule].[Color Code] = "o") AND ([Survey Schedule].[Field done] = False)))

What is the problem with using the one you just got?

You can, is the straight forward answer. Although how you want to achieve it is a different question. Normally, you would have to use a Form, with several Text Boxes for each name, however, this could be overcome by using VBA - but you need to do some looping and coding.

Here is how you send email from Access VBA using CDO (Collaboration Data Objects) : http://www.blueclaw-db.com/access_email_gmail.htm I would not go for Third party myself. Here is some info. http://www.outlook-apps.com/disable-outlook-security-warning/

Define "Cancel an Appointment". What happens to the record in the table when an appointment is marked to be cancelled?

Well this is a well known problem, this feature was added in Outlook 2007 and up, if I am correct. You can use Third Part software or use CDO.

Somethign like, SELECT PARTID, Avg(Price) As avgPrice, Min([Date]) As MinDate FROM productTable GROUP BY PARTID

How is Average of 5 and 6 = 6?