I need my form input text box (for ease) to be a number string e.g. 091805
that will convert to mm/dd/yy.
Any pointers? I searched thru 25 pages here.
TIA

I would like a message to appear on the click of a command button if the
associated record does not have a hyperlink associated with it. How would I
go about this?
Cheers

I have a form with the combo box Name. This is linked to a table that
contains all customers details. When the name from the combo box is selected
I want the other fields of the table to appear in text boxes. All the options
I've tried come up #Error or #Name.

Hi I am trying to update a date field, so when I click on a check box todays
date appears.
Private Sub chkSendToCollections_Click()
   Me.chkSendToCollections = -1

I have created a union query that returns data with "critical" and
"concurrent" delays.
I now want to place them in different columns of a report as so:
Date    Description         Concurrent    Critical

How can I hide a subform until a text box has some value inputed in to it.
If the text box is null subform visible = no
Else if text box isn't null subform visible = yes
Thanx guys!

I have a BE I am converting to SQL Server.  One of my routines links to an
Excel file and then takes the data from the excel file and inserts it into
one of my BE tables.  The table I am inserting into has about 50 fields, most
of which are lookups to other tables.  The Excel ...

I have a form with a filter on it that works fine: DoCmd.ApplyFilter et
cetera. However, when I put the form as a subform on another form and try to
run the filter I receive the error: The action or method is invalid because
the form or report isn't bound to a table or query.

Hi & Thanks
I am creating 3 buttons on my form
1.      Save n' Close
2.      Undo

I created a database on the network.  The users started using it this morning.
Well, someone accidentally deleted the Access Database.  Luckily, I made a
backup version, but the two records that were entered are now lost.
Is there a way to prevent anyone from deleting a database ...

I am using the datediff("d",[EndDate],[BeginDate]) to calculate the number of
days attended.   If I use [EndDate]=1/1/01 and [BeginDate]=1/1/01 I want 1 as
an answer not 0.  [EndDate]=1/10/01 and [BeginDate]=1/1/01, I want 10 as an
answer not 9.  Any Ideas.  Thanks

I've done this several times but am having a problem now...don't understand
why.
I have a control whose control source = qty * priceea.
I've added another control whose data source = sum(qty*priceea) and I get

I've changed the background color on some controls in code based on a
control's after update event.  I would like these color changes saved so
they would be there the next time the form is opened.
How do I do this?

   DoCmd.RunCommand acCmdSelectRecord
   DoCmd.RunCommand acCmdDeleteRecord
   DoCmd.ApplyFilter , "idxID= 114"
I start with 16 records: after the 2nd line I have 15 records: after the

Please help!
Employee form (data source is employee qry for active employees) has button
to call Note form (data source is table).
Code behind button OnClick: