Hello all,
Newbie Here (please go easy, you cant make me fell more stupid than I
allready do)
I have a small, but complex data base, in Access 2000, that I am

I am trying to write a query in Access (or SQL) that works on a table
like this:
Location     Gridreference
Ben Nevis    NQ1234512345

Can anyone tell me what is wrong with the goto command. I noticed it is one
of those NEVER USE.
I can understand that it may lead to confusing code, but I often use it like
this:

I have a simple app that I created for our Real Estate office using Access 2000
and it is working fine except for on thing.  I need to keep the close button
hidden from the users.  No problem accomplishing this it in forms using the
forms properties.  However the close button for ...

I am a new user and am trying to create a query to show the renewals
that will come up within the next two months. I already have:
Now()And
I am not sure how to input "two months"

This is driving me crazy!! I'm using MSACCESS, and all I want to do is
create a macro/query/anything that will take the data in Column A and
copy it into Column B (same table)
"Insert into" ALMOST works ... unfortunately it adds the data at the

I fixed my data after the corruption 3197 - I ended up copying all the
information into a new database.  Everything seemed to be working
okay.  But now I have found an error of missing data.  The data is
still in the tables - but in one of the other tables you can search on

I have 2 command buttons on a form.  I want the first one to be enabled and
the second one to be disabled when the form is opened.  That works fine.
Then, after the user has pressed the first button, I want them reversed -
button #2 is enabled and #1 is disabled.

Is it possible to give conditional page breaks in access reports depending
on a field value?
Thanks
Regards

Is there a way to find the names of users in an Active Directory WWW group?

I have a form with several fields.  I want to add a control to click on to
send the contents of one field to the printer.
Can someone offer help with the code for this?
Thank you

I have searched Deja and the MS KB but there are so many threads and
articles related to printing, that I thought I'd save time by just
presenting my problem in this forum.
My problem is this: some users of an A97 app of mine are printing

I have a created a SQL Database with a table called Tbl_Customer which
includes lots of Rows of customer information.
The primary Key is CustID which is an Identity (Auto Number)
I want to be able to create a new table called Tbl_Address which has

HI everyone ...
I am interested in creating a date field on an ACCESS form that will
be used to update a DB/2 Table (Link Table). I am interested in
creating a DB/2 timestamp field in the following format

I've got a fairly large Access file with 4899 records. The ID field
runs sequentially but misses two rows: it skips 3727 and 3740.
Consequently, the dbase indicates that I have 4901 rows where in
reality I only have 4899. I've inherited this problem from someone