I have a form that is bound to a table. On the same form are unbound fields
in a related table (many:1 relationship).
I tried using bound fields but no arrangement allows me to add new records
to the related table.

I have a form on which I have set a timer event in order to display the
current date and time. The timer interval is set to 1000 and works as I want
it to. However, I also have a need to refresh a query on the form (actually
on a sub-form) at a regular interval; but not as often ...

I have read multiple threads regarding storing calculated values in tables.
I do acknowledge that it is generally a BAD IDEA to try to store calculated
values in tables.  I have also seen that sometimes it can be okay to do this
in certain circumstances.

Hi, there! I could use some help with a combo box. I'm trying to
populate it with another combo box and get the error: Undefined
Function. Here's the SQL for the combo box:
SELECT

I have a listbox on a form, whose recordsource is a field ([field1])
of tblSomeTable.  I want user to be able to choose one or more items
(usually only one, occasionally 2 or 3, but probably never more than
3), and use those selections for a query  which will be used for

I want to force input of U.S. phone numbers in 999-999-9999 format. I will
store the numbers and the dashes. How do I create an input mask to enforce
this? The existing mask forces (999) 999-9999 which I don't want.
Thanks.

I have a form that has two listboxes.  Both listboxes are on frmAccount.
LISTBOX 1: Show investments inside an account
This listbox shows data from tblPositions (a linked csv txt file)
In the SQL of the listbox, I set the criteria of AccountNumber field of the

Access 2000.  I would appreciate some help with this code.  I keep getting
an error of  "Type Mismatch" on "For New Cert. Num" just after "If Response
= vbYes Then"  I'm pretty much code illiterate.  This code worked previously
when the "CertBeg" and "CertEnd" was strictly a ...

For a database in the U.S. that sees a lot of analysis, I've
decided that a little reduncancy is a good thing.
Our field crews record DST when it is in effect, but our
analysts would usually like to use Standard Time.  So I've

I have a table called tblDetails and in this table there are 2 field
called strGateID (autonumber) and srtPN which is a default value of
PN. I have combined two field in a query called qrySearch and the new
field is called srtSearchNo.

I got the conditional formatting on a continuous form to work. My only
problem is getting the color of the text box (the one under the conditional
format) to change to match the 'default' color of the background.  From my
computer, it appears that the 'default' color is a shade ...

I have created a database so that mulpile users can add detailss to
the table -  tblDetails from the form frmDetails or amend details in
form frmAmend. I have a list box on the main page frmMain which has a
list box lstSearch which shows all the records in the database. When

I have a form and its recordset is an ADODB recordset (I call it through a
stored procedure in mySQL)
I am trying to put a combo box on my form to select a members name and go to
that particular record.

I have an ID for a database that is not an auto number; I'm manually
increasing the number by 1 for the next new record as below:
Me.HRID = DMax("[ID Template]", "Offer Letter
Information") + 1

As I continue to try to salvage an ADP project in Access 2007 (and the light
at the end of the tunnel has pretty much gone out due to Access 2007 bugs),
my latest probable dead end is..
I have a parameterized function called