I have a form with dropdown boxes. If the data is not in the list I have a
button to go to the client table to add the new client and then return to the
original form. When I click the dropdown box the client that was added is not
in the list. If I advance to a new record and ...

I have a subfrm that is continous, it contains 4 fields:
comp_num (links to main frm)
date
REG

I have a field on my form that has a Control Source is Product. When I
attempt
to use Product as the Name Access 2003 tells me the name is already in use.
I have several other forms the Control Source and the Name are the same but

Hi, there is a way to build a SELECT where I can get the next or previous 10
or 15 records, no mather what is the record.
Thanks.

I have a form that will have several forms in (12). I have them hidden and
then recall the form to be displayed on the screen with a command. My
problem is that I get the calculating execution on at all times. My screen
flickers and never stops because it keeps calculating within ...

Hi, I use to have Access 2001, 1 month ago I installed Access 2003 but my
forms (text box, command buttons) look like 2001 pretty square, It doesn't
have Those round borders on the commands buttoms and in general look updated.
If someone may show me how to change this set up, I ...

I have two option buttons (named 'op_denY' and 'op_denN') inside an option
group.  On selecting 'op_denN' a pair of text boxes (intended for numbers
labelled 'min value' and 'max value') become disabled.  I would like this to
be the "default" state for when form loads, i.e. with ...

I have an interesting problem that I can't find a solution to.  Once a form
has focus for a few seconds, some of the text becomes blurry and slightly
bold.  There is no code on the form that would cause this to happen.  I was
wondering if anyone has seen a bug like this before.  ...

I've built my first subform, but they add records independently. If A is the
master and B is the subform, there wil be one record where the A cell will
have a value and the B cell will have a 0 and there is another record with 0
in the A cell and a value in the B cell.

I have about 40 Queries by Year.   I don't want to write it down one
by one to make a command button.
   DoCmd.OpenQuery "2007", acViewNormal, acEdit
   DoCmd.OpenQuery "20071", acViewNormal, acEdit

HI,  I am using Windows Vista with Ms Office Pro 2007.  I am quite used to Ms
Office 2003.  When creating Form in previous versions of Ms Access I could
resize each control i.e. Text box, Combo box, Label etc etc individually to
suite my needs,  unfortunately I am unable to ...

Hi, I have a table (Departments) and 2 fields DeptCode (Key) and DeptName, I
have these fields in a Form and I also have a text box Text95, what I want to
do is  to type the department code in the text95 and display the description,
later on I will display more information but ...

I want to force the user(s) to enter a value in the following numeric
(double) format:
#.###
Example: 2.358

I have created a form (Orders Form) to enter some data regarding orders.
This form saves the typed data into the table (Orders Table) including the
customer's ID and Order ID.
All nice and saved into the Orders Table, except from the Total field.

I am new to Access programming and would consider my skills intermediate.
Here's my problem:
I have a form with three dropdown boxes that display data from different
tables, a text box and a button. The form is going to be used to display some