Hello from Belgium,
i want to highlight the date-part in red in my form between the birthday and
14 day before thate date,
this code(here under) only lights up one day(birthday day) at the time, i

I have a date control that when the form loads displays the current date.
What code/process do I need to do so when the user hits the + or - key the
date changes?
Thanks

I have an annoying problem with Access 2003 using its form_current
procedure.  Within the procedure I am calling a function which updates a
listbox (see code below).  However, when I open the form it appears to be
continually 'refreshing' the whole form for 5-6 seconds before ...

I have a query that I am using to create a list of customers details that I
would like to display on a form without using CBF.  I would like to write a
select query that list the field names as in:
SELECT [AllFieldNames] FROM qryCustDetails;

I have a main form with a subform that contains child  records.
I can open a popup form and create a new child record on the fly. I then
close the popup form and requery the subform with:
   Me!mySubForm.Form.Requery

newbie with this.
I have a form and I want to store the path to the file along with the file
name.
I then want to have a button that takes the file/path and launches the

We  have an annoying feature on 1 form in a database. The form has a tab
control, with 6 pages, and when we click on a command button to go to next
record on a form we do so but the current tab page goes to Page 5.
Any advice or suggestions as to how, when we go to the next record ...

I have created a custom form that collects parameters that are passed to a
query thats the record source of a report. I want to add an asterick as the
default choose so that all records are returned unless another choose is made.

I have a text box on a form as well as an option group within a frame
containing two option buttons. I have written code to display a message box
if the user does not enter any data in the text box. I have a setfocus
statement following the closing of the msgbox but the focus ...

Is there a utility available that will count the
lines of code within a project? I.e., the code
sheets of forms, reports and modules?
Thanks,

G'day ppl,
I am looking for a code that will lookup a string value before it updates
the field eg.
= DLookup("txtMyTitles", "tblMyTitles", "Criteria = '" &

I need to pull a query up from SQL through access --- WITHOUT --- using the
form rowsouce property.  What am I doing wrong?
Private Sub cboCompany_Click()
 Set db = DBEngine.Workspaces(0).Databases(0)

Is there a way to use spellcheck with my app with runtime?

I have a form with many images controls.
Now when users are not allowed to click on an image (imgA), I want to change
the image (picture, bitmap) of this control to disabled image as a
commandbutton in disabled status.

Al thanks for all your help.  New issue.  The search is not working.  
Originally I had the button tied to a macro that would open the form that
contained the record information.  When I enter the Id and click the button
it says there is no field name in the current record.  How ...