=========REF:---------http://www.access-programmers.co.uk/forums/showthread.php?t=200804 =========EXAMPLES:---------Me.StatusBox.SetFocusMe.StatusBox.SelStart = Len(Me.StatusBox.Value) ---http://www.anysitesupport.com/vba-automatically-scroll-to-bottom-of-text-box/
=========REF: http://www.pcreview.co.uk/forums/vba-table-record-count-t1104006.html�http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26940281.html�http://classicasp.aspfaq.com/general/why-does-recordcount-return-as-1.html =========NOTES---------Be careful with the use of CurrentDb.TableDefs("TABLENAME").RecordCount option. It's only available to the system when it is using a certain cursorType in your calls to the database. The default cursorType is Forward-Only and will not show the RecordCount. The best option is to open a record set: Set rst = CurrentDb.OpenRecordset ("6050c__DrawingWinners")Then check [...]
=========QUESTION: How do I add date and/or time values to Access queries, VBA, etc...? =========EXAMPLES:---------Day of the week of a given Date:Day: Weekday([TransDate])Day: IIf(Weekday([TransDate])=1,"Sun", IIf(Weekday([TransDate])=2,"Mon", IIf(Weekday([TransDate])=3,"Tue", IIf(Weekday([TransDate])=4,"Wed", IIf(Weekday([TransDate])=5,"Thu", IIf(Weekday([TransDate])=6,"Fri", IIf(Weekday([TransDate])=7,"Sat","nada"))))))) ---------The current month:DateSerial(Year(Date()), Month(Date()), 1) The next month:DateSerial(Year(Date()), Month(Date()) + 1, 1) The last day of the current month:DateSerial(Year(Date()), Month(Date()) + 1, 0) The [...]
=========Error Message(s):---------Error message when you run a query in Access: "Cannot group on fields selected with '*'" ---------All fields showing in query results even though you only stipulated a few =========REF:---------http://www.pcreview.co.uk/forums/asterisk-automatically-added-end-query-sql-vie-t3283725.html ---------http://support.microsoft.com/kb/835414 =========ANSWER(S): ---------To resolve this problem, set the Output All Fields property of the query to No, and then run the Access query that [...]
=========REF:http://www.mrexcel.com/forum/showthread.php?t=355482 =========It appears the SetWarnings Action is missing when building a new Macro.Go to the Design Tab, click Show All Actions ---http://www.anysitesupport.com/access-2007-macros-setwarnings/