|
||||||
Access MVP (2010-2015) |
You want to use TEXT as the Control Source of a Control on your Form but you keep getting an error OR it doesn’t show as expected because your text contains an apostrophe or quotation mark(s). For help see chart below… Control Source Property Result Explanation =”This is literal text.” This is literal text. Literal […] ***10.14.2018 tlkpUnitConversions has new entries and now includes Categories and Temperature conversions! While I was working on my Grocery List to Recipe database (don’t ask, only been working on it for a year) I realized there was going to be a need for conversions and why not share? It’s pretty basic and does not include […] So, you checked Use as Form and Report Icon under Options > Current Database for your customized Icon to show on your Forms and Reports but when you opened your Form (or Report) there’s no icon… Well, here’s the thing, if you choose No in the Properties window for the Form (or Report) under […] Taking the Splash Screen up a notch… Sometimes you want to load some data before your database opens? You don’t want your Users wondering what’s happening, so here’s a way to keep them advised of the progress. (To download this example click here.) To use in your database, import the basProgressBar and frmSplash into […] There are many examples of how to handle new entries to Combo Boxes, a.k.a. Not_In_List events. However, the one that is not so easily found is how to handle entries that include more than just what’s in the Combo Box. For example, you’re entering an Order from a new Client and you need more than […] To create a Splash Screen using a Form… Create a new Form In the Properties Sheet set… Set the Border to None Set Auto Center to Yes Set Pop Up to Yes Set Moveable to No (optional) Set the Timer Interval to the amount of time (in milliseconds) you want the Splash Screen to […] Recently, I watched Free Tools for Microsoft Access recorded by Crystal Long and Adrian Bell (Microsoft Access MVP’s) on Channel 9. Upon looking at comments below it dawned on me there is no central location for all those great free tools! How is anyone to find them? After all, you may not know they […] 1. Create a new database naming it differently then the original. (No worries you can rename it later.) 2. Uncheck Track name AutoCorrect info under File > Options > Current Database, as well as, any other options you don’t want. 3. Go to the External Data tab and select Access under Import. 4. In the […] I sometimes use Combo Boxes as *labels*. This comes in especially handy in the communications section of the Contacts Form where any given Contact can have more than one eMail or more than one phone. To move the drop down to the left… while the Form is in Design Mode click on the Combo Box. […] Probably the hardest part of designing a database is constructing normalized tables. Get them wrong and everything else is down hill… you can’t get the Forms to do what you want and the Reports just don’t work. Let’s see if any of these can make your job easier… Clubs (or Associations) Complaints DVD’s Grocery List […] |
Have an Access... ential you want to share? Drop me a line!
Note, all tips are moderated before posting. |
||||
|
Copyright © 2024 Access… entials - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
