I am trying to learn a very simple thing, turn ForeColor to Red, Green, Blue.
I can do this with a simple Command button.
Private Sub cmdRedNine_Click()
Me.txtInfo.ForeColor = vbRed

I have two tables tblAddress and tblCity both tables have store a CityID
I have a form based on tblAddress, this form has an unbounded control that
need to lookup the cityID in tblCity and display the corresponding name this
is what I have done:

suddenly my access files start to show an error message when i use pictures
with the extension JPG, But before a while they view pictures trully i
reinstall The access but the same problem appears (access XP) so can any one
help me

I have a sample database and I want to be able to limit the number of new
records that can be created.  The database is a demo that will allow the user
to see that everything works.  Is there a way to only allow 3 records to be
created, then have a popup say the maximum number of ...

Greetings all,
I am in need of some assistance with coding a function that checks bound
required fields on a form before saving a new record. It works fine, but the
problem that I am having is that when all the fields are complete, I would

I have a combo box in a subform of another subform.  The linking field is
called IRB Number.  The combo box row source is as follows:
SELECT [tbl Budget].[IRB Number], [tbl Budget].[Budget ID Item Number], [tbl
Budget].[Line Item Name] FROM [tbl Budget] WHERE ((([tbl Budget].[IRB

Private Sub Form_AfterUpdate()
   DoCmd.GoToControl Forms![frmPKProjects]![sfrmProjectsTasks]!
[sfrmProjectsTasksResponsibles].Form![cbResponsible]
   DoCmd.GoToRecord , , acNewRec

Morning All,
I have a database that tracks reports.  Since these are military reports,
the dates of the reports are listed like this.  250930 Jul 08 (DayTime Month
Yrs).  My form is a continues form that displayed the reports that were read

I realise that I can set a form or report to close after a predefined time
using the forms timer function, but how can I set a time to close a form or
record after a time of say 20 minutes.
I want to avoid a user sitting in a record (and therefore keeping it

Using Access 2003:  Below is my code for a list box called Unit.  I am trying
to get the listed Units to show up in blue after update.  The problem is all
units are showing up blue.  Would someone tell me what is wrong.  Thanks!
Private Sub Unit_AfterUpdate()

I was wondering if there is a way to automatically get the windows user name
to pop in a field. i have a field called reps and i need it to pull in the
currently logged on windows user name into that field.  im using Access 2003.
Any help would be great

I seen many suggestions on this, but could someone see what might be wrong
with this.  I can't seem to make the file go to the right location.  
DoCmd.OutputTo acQuery, stDocName, acFormatXLS, stDocName & ".xls", "c:\
Savings\qrySavings.xls", True

I have a table in which there is a field called ContactID.  It is a text
field and started with 0001.  Whenever I added a contact I used the formula:
ContactID = CStr(CInt(DMax("str_ContactID", "dbo_tbl_Contacts")) + 1)
to get the "next" ContactID number.  Unfortunately, we have ...

G'day everyone
Some time ago, someone provided a code that allowed me to import file names
from a specific folder.
This code only copied the names of the files including the .ext directly

I would like automatically to calculate the age of people on a specific date
(21st September 2008, as it happens) by typing in their date of birth.
I have tried the DateDiff function but this just appears to take the years
and people whose birthdays are after 21st September are ...