Hi.. I have a problem.. I have a form where i created a button to click when
i want the form data to be inputed on the respective table.. I don't want to
use the macro button for that because i want to add some routines to it,
before the "next record" part. As you can see:

We are currently using Microsoft Access 2003  free "issues database."  This
works GREAT with what we need from a database. It was perfect when the "issue
id" matched the "record" number because we could quickly put the number in
the record field at the bottom of the form and goto ...

    Is there a code that detects if a form is open or not?
I've a button on a form,i need to know,on click event of this button if the
form SW is open or not to build other codes...
how can i do this ?

How could I set a primary key where it is based first on month and year user
enters and second on an autonumber that numbers specific to the month and
year?
I want to enter the Month (Jan, Feb, Mar, etc) the year (08, 09, etc) and

I'm filtering records on a form with a button that invokes a query.  Is
there any way I can show on the form what the records are being filtered
on??
For example, I have a field called "Active" - if it's a 1 it's active, and 2

I was sent a small XLS file (28K), comprising 19 columns,78 rows. The
problem reported was that the last field (column) would not import - it is a
general (number, 2 digits only).
So I tried the same simple task: create a new blank MDB, import the XLS

  I've a form called "assist",this form opens in a new record,so that users
cannot get the previous records under any circumstances,when users finish the
record they are inputting,they click on the button "New record" so that they
may add a new record...

Hi.. I would like to know how i can program an event procedure in VBA to one
button to work exactly as the built in "next record" button does.. or to make
it simple i will explain..
I have a form with some input fields.. after fulfilling them i want to press

On my form I have 3 currency text boxes that have the same table
[tblBalance]
[tb1[, [tb2], [tb3]
What I want is in theAfterUpdate of [tb1] I want to show the balance in

I never have mush time to search the forums so I am hoping someone could
help me out. I am wondering why the microsoft compatability pack for the 07
system did not include access. Also, does anyone know of a program out there
that will allow me to open a office 07 access database ...

Hello! not sure what is going on but i want to resize a form in access 2007
like i used to in 2003 but i cant ! when i resize the back ground as (i did
in 2003) it just opens the same full screen! i have two buttons on form so it
looks poor! i have checked the autoresize button ...

Im trying to filter a single entry out of a multiple entry field.  In the
properties section we have abreviations for the different investment
properties we manage.
Ex: Six, Stone, Mnt, TPL, Cyp, Wood, Vin, Vic, Ect. Im trying to run a

I am searching for quite a while for a possibility to do this (which I used
to do in FileMaker all the time...):
I do have a contact form and reports like "address label" etc.
I would like to let our users to select a group of people (by using "Filter

Access 2007
I have heard that there is some built in integration that allows for forms
to be built in outlook  2007 and then the resulting data input is then
importable into Access 2007.

I would like to create a form that I can type in  IP address and send a
automated ping  and see the reply . I am try to set up a simple montoring
database to where I can input some IP address and the database will display
IP "A" is ok , IP "B" is offline and so forth ....can ...