I would like to return only the YEAR in a Text Box on a form.
I tried adding this to the Text Box but it still returns the mm/dd/yyyy
Private Sub TR_CLOSEDATE_BeforeUpdate(Cancel As Integer)
Dim LYear As Integer

What code would I use to determine if "MyForm" is open?

Hi, is it possible to add components (like textboxes) to a form using VBA code.
I thougt it is possible with a form in design view, but I don't know how.
regards
Rob

I have a form which shows select field from a table (showing all rows of
data), and have 2 buttons , one to edit, one to add.
The edit button works perfectly
DoCmd.OpenForm "frm_TRA_EditRoute", , , "[anRouteID]=" & Me.Text62.Value,

On May 18 I tried to enter thee following question in Access.setupconfig but
no answer.  So I'll try here.  Sorry about the double posting.
I am running Access 2000 in Windows XP Home.  Every once in a while I lose
the help files.  When

I have a combo box that is doing a search by renterlastname. Problem is that
there could be multiple times a renter's last name appears. The combo box is
based on
qryRentalAgreement and I have it references the RentalAgreementID. And it

i am trying to change the format for one of the columns in my query.
basically, i would like:
"1/6/1900  4:46:25 PM" to read as "160:46:25"
"1/2/1900 3:43:31 AM" to read as "51:43:31"

       This is probably a dead simple thing, but I'm stuck on it.
       My main form's record set is dependent on the selection of a record
from one of its subforms.  When the user selects a different record, I need
to requery the main form to update all the other stuff on it that ...

I have a form that contains contains over 100 controls (divided into tabs).
The locked default is "Yes". Is there some way I can flag certain controls so
that I can cycle through them with an "Edit" button and unlock them? There
are about 50 that will need to be unlocked and I'd ...

Hello to everybody.
In a textbox I shoult type the value from 1 to 9 in the following way: 01,
02, 03, 04, 05, etc
However may times I type only one digit: 1, 2, 4, 5, etc.

I am trying to use ShellExecute function to invoke the ax program.
The code below works perfect:
ShellExecute(0&, "open", "ax.exe", "C:\2runtemp2.run", "C:\axfolder",
5)

I have a table that lists shifts(shiftdetails) including their date/time.  I
have a listbox that is a query of those and shows the last 10 shifts.  
I would like the user to select one shift from the listbox, and hit a button
to generate a report using shiftid as a variable.  

       I have a subform (continuous forms) with a number of records in it.  
Each record includes a "SortOrder" field used, as you might guess, to sort
the records.  When a new record is added, I want to assign (Maximum Current
SortOrder + 1) to the SortOrder of the new record.

I think this is my problem.
I add a client not in my client combo list, then open a new form for that
client to enter extended information.  This works fine.
However, I want to return to the client I have just added on my main form

I'm using the fOSUserName module to give an unbound text box a default
value of the user's network User Name.  I'm trying to filter a form
using this text box value (Text24), as this value corresponds to a
bound field (Anumber) in the form's driving query.  I cannot seem to