Search results for query: *

I have a table with a field that has Data type Text that looks like this; ShaNumber MPM-8 PPM-23 5137 15045 46005 etc. The first two entries are the only ones with text. The rest are numbers. I created a combobox called shacombo with rowsource of: Select [SHANumber] From...

One of my students pointed this out to me and I just tested it. In Access 2000 and 2002, if you set up a date/time field in table design, switch to datasheet view and enter a date such as 4/23/993, it accepts it as is. If you enter 4/23/003 it changes it to 4/23/2003. Any "year" 991...

If you find that you often make the same set of changes to a type of control, such as text box or command button, you may want to change the default style for that control type. For example, you could change the defaults for font, border, and margin properties for the text box control type, so...

If you're like me, I do alot of copy and paste of code in designing forms. Well, when you copy an SQL statement referring to a form, it usually is written using the Form! object. The trouble is the form's name is specific to a certain form and thus has to be changed when this code is copied to...

Let's say you have a form in restore mode. You don't want the user to move their mouse outside your form's boundary. You can use the following code to constrain the mouse movement to only the form: ( to test it, create two command buttons and paste the appropriate code from below)( Also, when...

You're keeping track of when certain events that are happening during the day and, let's say, you want to count how many times the event occurs in 2 hour increments. So using a 24 hour clock, you want to know how many between 0 -2, 2-4, etc., 20-22, 22-24. What I did was this: First I found the...

Sirs or Madams: I have a table with two fields - partno, desc. Desc can span more than one record, eg. partno desc abcd this is one desc abcd this is two desc xyz another desc...

I have a form with a List box on it. I would like to use the Office Assistant as an Option Group to fill in the list. Everything works except one thing. After a user selects an option, the Assistant disappears. I would like it to stay on the screen so the user can select another option if he...

In Mr. John Walkenbach's book "Excel 2002 Formulas, in chapter 25, he has the code to Randomize a Range. Code works great. However, how do you change the code to include the following conditions: The resulting list when placed next to the original will NOT have matches? And when randomized...

Let's say you want to create your own autoincrementing primary key. And it's in the form of abc#### - abc001, abc002, etc. What do you all think of this? Create a table with a field say Increment. This will be set to automatically increment. Then create a field for your primary key, eg...

Let's say you want to create your own autoincrementing primary key. And it's in the form of abc#### - abc001, abc002, etc. What do you all think of this? Create a table with a field say Increment. This will be set to automatically increment. Then create a field for your primary key, eg...

PowerPoint lets you set a minimum of 1 second between object displays. I want to duplicate a visual effect called "Behnam's Top". I need to have the timing between displays set at .25 or .16 of a second. Is there anyway I can create such a timing? Thanks for your time. Neil...