=========ERROR / MESSAGE---------The database has been placed in a state by <user> on <machine> that prevents it from being opened or locked. =========SCENARIO---------You are pasting a table, query, form, etc from Access Database file to another, and this error pops up stopping you from pasting. =========NOTES---------Standard answer:This error occurs when the new passive shutdown/connection control [...]
=========EXAMPLES---------Phone Number:If numbers stored as text:Format([field],"@-@@@-@@@-@@@@") If numbers stored as numbers:Format(2127851212,"(000)000-0000") ---------Format([Store],"0000") Input Mask for Table Field:!(999)000-0000 --------- ZIP: IIf(Len([ZipCode])<6, Format([ZipCode],"@@@@@"),Format([ZipCode],"@@@@@-@@@@")) ---http://www.anysitesupport.com/access-format-fields/
We get a lot of questions from our clients trying to figure out the pros and cons of purchasing a netbook versus a full power laptop. What is a netbook? Think iPad with a keyboard. Why? Well, it is quite obvious if you think about it - What does the world run on again? Oh [...]
=========EXAMPLE---------=Today()-1 =DATE(2011,4,15)-1 =========REF---------http://www.excelforum.com/excel-worksheet-functions/570878-today-minus-1-day.html http://www.cpearson.com/excel/datearith.htm ---http://www.anysitesupport.com/excel-date-minus-1/
=========REF---------http://www.computing.net/answers/programming/batch-script-for-setting-up/12506.html http://www.msfn.org/board/topic/37472-username-in-batch-file/ =========EXAMPLES---------Test the following by typingECHO %username%, etc at the command prompt %username% %computername% %systemroot% =========APPLIES TO / KEYWORDS---------Microsoft DOSMS-DOSBatchCommandsVariables ---http://www.anysitesupport.com/variables-in-batch-files-and-commands/
=========QUESTION---------I have TABLE-A with 19000 records in it.Each record contains REGION, DISTRICT, STORE, NAME, and that person’s SALESHow do I find the top sales per Region, or per District, or per Store, etc... =========ANSWER---------OPTION 1 All it takes is three simple MAKE TABLE* queries: In this example, we will find the top SALES per [...]
=========QUESTION---------In Microsoft Access 2007, using VBA, how can you check to see if a table exists? =========EXAMPLES---------On Error Resume Next --------- Public Function dbsTableDelete(DBName) Count = 0 tblNotFound = False Do Until tblNotFound If DBName = dbs2020.TableDefs(Count).Name Then dbs2020.TableDefs.Delete (DBName) Exit function End If Count = Count + 1 'Determine if we are at the [...]
=========QUESTION---------You have a spreadsheet where you want the data you have entered as rows to now be in columns and the data you have entered as columns to now be in rows. =========ANSWER---------Select your data, copy.Select where you would like to paste the newly transposed dataSelect the the dropdown arrow under Paste in the toolbar, [...]
=========QUESTION / DESCRIPTION---------Keyboard shortcuts for Microsoft Excel =========EXAMPLES---------F2Puts the current cell into edit mode, just as if you clicked the Formula Bar ---------. =========REFERENCE---------http://www.mvps.org/dmcritchie/excel/shortx2k.htm =========APPLIES TO / KEYWORDS---------Microsoft Excel ---http://www.anysitesupport.com/keyboard-shortcuts-for-microsoft-excel/
=========REF: http://www.nsftools.com/tips/MSFTP.htm http://rotterdam.ics.uci.edu/info/DosFtp.htm =========ANSWER: Open a command prompt on your PC:Click the Start button, select RunType: COMMANDClick [OK] At the command prompt: ("text" to be entered at the command prompt is in quotes ; <keystrokes> to be typed are in carats)"FTP"<enter>"open anysitehosting.com"<enter> Enter your username and hit <enter>Enter your password and hit <enter> =========EXAMPLES ---------"cd [...]