I have a listbox, based on a query, with a list of treatments. Is it possible
to have at the end of this list a "*" or "Add New Record" option to select?
If one was to select it and then click the button that accompanies the
listbox, a form would be opened in the add mode instead ...

I am trying to make an auto number start with zero.  The number is a warrant
number, which is the year, then a five digit number.  I already have an
expression set up to automatically update the number by one and place the new
number in a form when a box is clicked.  This number ...

I'm trying to modify an existing form. In setting up "Control Source"
property of a combo box, the field or table that I want to choose is not in
original list (by clicking down down arrow) of fields or table.
How do I add fields or table to the list ? Thanks

My VB Editor mysteriously stopped working a few months ago and I'm tired of
not being able to use it.  I had previously been using the VB Editor on my
machine for several years without any problem.
The problem first occurred when I attempted to launch the VB Editor from

Is anybody can tell me, if MS Access can accept fraction number like Excel?.
I had a project before, the user had to enter with fraction number. I still
can't figure it out untul now.
KF

I use the code below to CREATE reminders in MSO - is there a way to
programmatically DELETE or remove reminders ?  MSO is not very user-friend in
removing appointments/reminders from your calender - you have to click on it
with your mouse, then go up and click the "X" icon, or right ...

How can I get a command to execute when the enter key is pressed after
entering data?

I have a Company form and a Client subform. Some of my clients work for one
or more of the companies. So some clients show up on multiple subforms. Is
there a way to link those subforms so that if I update a phone number for one
client it will automatically that clients' phone ...

I have a form with several fields.  Once it has been printed (a printed
yes/no box is updated to yes) I'd like the locked feature of the record to be
turned on.  Is there a way to do that?
Thanks in advance.  Ian.

Have a form with a combo box field named "dist_code" where the user can
select a district code; in the field next to the combo box in the form there
is a text field named "district".  I would like for the long description of
the district code to auto populate the text field ...

Hi, is there a way to copy the same conditional formatting to othercontrols
on a form without having to change the control name in the conditional
formatting expression of each one after I copy it? I would like to copy the
equivalent of:

After I create a form using the Wizard, how do I move the controls around?
I am not allowed to do so.

Would like a little help with counting records that match a string if a
check box field is true or checked.
I am building a form to display record counts but only for records that are
active (checked) In other words if field a=music and field b=true then count

My table has two fields, one for Date (Short) and one for Time (Medium)  When
I creat a new record in the table the date and time changes correctly.  Yet
when I create a new record using a button control in the form, the date and
time do not change?  

How can I use a split form as a subform? I can't find anyway to make
my split form show up in split mode when I use it as a subform. I can
show the form view or the datasheet view, but not both. Why not?