Recent content by BrettStah

Apologies if this isn't a clear question. Let me give you an example. A customer wants a database that will allow him to store information about each project that he creates for each of his clients. So Client A hires him to paint 5 houses, and the customer creates a PaintProject for each...

The VB control arrays have some nice features - I miss them sometimes when working within Access forms. In VB, all controls within a control array share the same name and same event procedures, but each button as a different Index property. So if you have 10 command buttons in an array, they'd...

Print labels by using Excel data in a Word mail merge

Have you tried using Microsoft Word, with the mail merge feature? That way you don't need to learn Access for this time-sensitive project. (I assume that you or someone there is probably more familiar with Word than you are with Access).

Not possible.

Try the help system in Access...

Oh yeah, make sure that you create separate index files, or your performance will suffer!

I suggest going for the top score... here's how: First, forget about using Access - no way to get a perfect score if you use that. Instead, get QBasic, and write yourself a relational database application. It shouldn't be too hard, given that you have 4 days until your project is due. To save...

You can verify it for yourself by using a network monitoring tool to "sniff" what's going to/from your computer's network card, by the way (or ask one of your network gurus if you have one).

I don't think that is correct. Think about it this way... if the backend MDB file is sitting on a file server, what process on that server would be able to filter out the unneeded records, and then only return the requested records? The answer is that there is nothing - no "Microsoft Access...

A search of this forum produces some results. Here's one of them: http://www.access-programmers.co.uk/forums/showthread.php?t=36038

That's close, but it's not unlocking the other control that shouldn't be locked. So unless the form's On Current event specifically unlocked the controls, you may have unexpected results.

Yes it is. :) Hint - each control should have a Locked property. So when your combo box changes, test its value, then lock and unlock the other controls as needed.

That is just one of the common places it is used. It is by no means limited to HTML pages, as you've discovered. :)

Here's an example of using the Format property to do it for a U.S. phone number: @@@-@@-@@@@ You would use an input mask to restrict the type of characters that could be inputted (to prevent the use of letters, for example).