Restrict a table to a single record

========= QUESTION --------- I use a table called Parms in my database to store application specific parameters.If a user accidentally added a record to this table, instead of simply editing the single record containing the appropriate values, it would cause major issues for the application. Is there a way to restrict a table to contain [...]

By | 2017-12-01T23:47:35+00:00 October 28th, 2011|Access, Computers, Documentation, Microsoft|0 Comments

Can I backup my VBA code?

========= QUESTION --------- I have been having a lot of trouble lately with my Microsoft Access database files being corrupted and losing all of my code. (a sometimes fix for this: http://www.anysitesupport.com/error-microsoft-access-has-stopped-working/) The scary thing is even when I attempt to open the backups, they may work, but the code still disappears! Is there a [...]

By | 2017-12-01T23:47:35+00:00 October 26th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments

VBA: String Manipulation

========= QUESTION --------- What are some ways I can manipulate strings within VBA?   ========= ANSWER --------- see EXAMPLES   ========= EXAMPLES --------- Title field has values like: Company Manager, Company Assoc, Company Director, etc...Remove Company: =IIf([Title] is null,"",Replace([Title],"Company ",""))   ========= APPLIES TO / KEY WORDS --------- Microsoft Access String Manipulation Strings VBA   [...]

By | 2011-10-25T10:23:53+00:00 October 25th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments

View Available Wireless Networks is missing

========= QUESTION --------- I want to use Windows to configure my wireless network connections, but my computer or network hardware manufacturer's software has disabled this feature. How do I re-enable it?   ========= ANSWER --------- Windows XP The issue is the Wireless Zero Configuration service has been disabled or stopped. Open the Services applet from [...]

Error: Microsoft Access has stopped working

========= QUESTION --------- When opening a Microsoft Access database file, Access crashes with a pop up message stating: -------------------------------------------------------------------- Microsoft Access -------------------------------------------------------------------- Microsoft Access has stopped working  Windows is checking for a solution to the problem...  [Cancel] --------------------------------------------------------------------   Finally resulting in the following message: ---------------------------------------------------------------------------------------Microsoft Access ---------------------------------------------------------------------------------------Microsoft Access has stopped working A problem caused the [...]

By | 2017-12-01T23:47:36+00:00 October 19th, 2011|Access, Computers, Documentation, Microsoft|0 Comments

Disk Space Analysis

========= QUESTION --------- How can I get a good view of how much disk space is being used by each folder in my hierarchy?   ========= ANSWER --------- Microsoft Windows http://www.jam-software.com/treesize_free/ http://windirstat.info/ http://www.freecommander.com/ --------- Mac OS http://grandperspectiv.sourceforge.net/   ========= EXAMPLES ---------see ANSWER   ========= APPLIES TO / KEY WORDS --------- Disk Space Hard Disk Disk [...]

By | 2011-10-17T15:32:30+00:00 October 17th, 2011|Apple, Computers, Documentation, Microsoft, Windows|0 Comments

Access Database Server from Remote Host

========= QUESTION --------- Our web site is hosted on anySiteHosting.com's web servers, and we need to access the MySQL or MSSQL database server from our local machines.   ========= ANSWER --------- LINUX HOSTING PLAN Login to the Hosting Control Panel http://www.anysitesupport.com/how-do-i-logon-to-the-hosting-control-panel/ Scroll down and click the Remote MySQL icon in the Databases section Enter the your [...]