Many records need almost exactly same data. I would like to enter manually
first record of continous form and have next automatically fill with most of
first record's  fields.
Tried setting default  of each control to current control ((by Event

I have a continuse form. When I hit down arrow key, it highlight moves
across to the right instead of same field next record. Is it possible to
move down when pressing down arrow and move up when pressing up arrow?

I have an Access database that was created in MS Access 2000.  
The database is now being opened using Access 2003 and there is a problem
with one of the forms.
Everytime the mouse is moved the screen/form flickers or Jumps.  This is

Can someone help me generate some VB code to do the following...
I have a text box that displays a projects status, but the status is
displayed as a number and the number means something like " Completed" or "In
Development".

I have a form with information about patients.
I have a textbox for date of birth.
I have a textbox for date of admission.
I would like to fill an other textbox with the person's age at the time of

I have a database with contact information.  My main form has several buttons
(next record, new record, search, etc.).  Is there any way I can create a
keyboard shortcut for, say, the search button so all I have to do is ctrl+s
or something like that?

I've been trying to figure out how to requery a subform after I have added a
record to the main form.  
I have a combo box in the form header that looks up a record in the main
form and gives the related info in the subform.  I have also added code to

I have a table with 6 yes/no fields that I set up to be 0 or -1 to prevent
against null responses in. However, now I want to use a multi-column listbox
to show these, and my listbox isn't very user-friendly with all those 0's and
-1's. Is there any way to format these as text in ...

Hi. How can i limite datasheet view to insert only 2 records. I want to
insert only two records in one datasheet.
Regards,
Marco.

I have a form that has a field called "report name" and has a auto number
that is tied to it. To print a single report I use the following code:
[Forms]![1 Report Analysis 1]![Report_ID]
This allows me to print only the "report" I am viewing instead of all of the

Here is what I think will be an easy question, but im not sure...
Lets say I have a databasee, which i do.  Lets say that on my main
form, I have a text box called "company".  On the same form, I have
command buttons that link to other forms that have to do with this

I now have Access 2007, and cannot scroll fast through records in a form
like I could in Access 2000. Is there a way to turn something on, so I don't
go one record at a time? I have to scan one record at a time to get from
record 1 say to 350. DB has over 500 records. Why did ...

Hello again,
I have an interesting situation. I basically inherited an older
database that is used to enter dates, usage and charges for accounts.
The situation is that we are attempting to do averages filtered by

Here is the code I compiled from the various posts:
'Private Sub Project_Summary_AfterUpdate()
'   With Me.Project_Summary
'      .SetFocus

The standard Combo box allow user to type or select from list.
I would like to not allow the user "type" on the combo box. Which property
should I set? or I need to code?
Thanks