I'm using Access XP, and would like to be able to modify a field's Format and
InputMask properties using VBA.  I see there is a CreateField method, but is
there a way to modify an already existing field?  Thanks..

I have a field on a form for the user to enter the date they completed that
item.  I want to have them click a button next to the field and launch a
calendar control, be able to select a date and then have the field update
with that date.  I know how to insert the calendar, but I ...

I know I can use VBA to see whether a particular file exists.  However, can I
use VBA to see whether a folder contains one or more files (name or names
unknown)?  Secondly, can I use VBA to get the filename of the first file in
the folder?  If yes, could you please point me in ...

I am interested in the answer to Jerry's question on November 11, 2004:
"Is it possible to code a command button (on click event) such that it will  
replicate what happens when you click the sort icon in the toolbar (that >
A-->Z icon)?"

We use custom excel workbooks and post them on our intranet with minimal
functionality.  Is it possible to use VB.net as the front-end to an Access
database?  I'd like to post the VB.net form to our intranet.
Any thoughts / solutions would be appreciated.

I have a button on a form (Access 2002).  When clicked, the logic opens a
second form upon which is a tab control.  It does a find on a record, and
once found, goes to the Subform that is on the second page of the tab
control.  I use the master/child link to determine which ...

I made a database for travel expenses. Each trip had a field for "meals" and
one for "lodging". Now the people using the database have decided they want
both to be combined in a single field called "subsistance".
I would assume that I need to add lodging to meals, and set meals ...

Hi I have a Combo box on my form IncidentData which is linked to a qryEmployerPolicy
I have entered the following in the query criteria Policy Number field
[Forms]![IncidentData]![PolicyNo]  ( I hope that makes sense so far)
When you click on the Combo box a input box appears if ...

I am working on a purchase order database.  I am trying to get a subtotal for
an order.  The code I am using for the control source for the subtotal is:
=sum([LineTotal])
It gives me an #Error.  Any ideas?

I am trying to open a second form from a the first one
when I click on a button and the second form is supposed
to show the information for the field Application Name
which needs to be pulled from the first form.

Ok, I have this form that has three subforms, on the main form when I
change a judges name assigned to a case I want the subform to reflect the
change.  I have tried using the requery and it refreshes but goes back to
the first record and not the one I am working on.  Is there ...

Hello again - I am still messing around with this poker player database and
came across something that would make life easier but cannot figure out how
to do it.  When someone wins a poker round (let's say they came in 4th place)
I am manually going to the text box that shows how ...

I'm looking for the different techniques to open a bound form faster.
First, When I call a form, I use the where condition, so only one record is
loaded.
Second, to do not go to the Form_Load event, I leave the form loaded but

Is there any way I can count the charaters in a memo field including spaces.
I currently use the following procedure.
On Error GoTo Err_Form_BeforeUpdate
 If Len(Me![Notes]) > 1560 Then

Can someone provide me with a brief tutorial on relative addressing?  My
database now has the front end and back end in the same folder on a network
drive.  We have, of course, run into error messages using this message, so I
will be moving the front end to each user's pc.