Is there any way of checking if a file exists on a website?
I have an autoupdate routine that runs from a clients server, but it would
be useful if it could run over the internet.  I'm sure I saw an article/post
on it a while back, but I can't find it anywhere.

I have an MS-Access 2003 (ADP) project that uses SQL2000.
I have a form that displays all "OPEN" items associated with a
particular user.  While viewing this form the user can click a search
button that will let them review "CLOSED" or "SUBMITTED" items using

I have the Microsoft Excel 11.0 Object Library installed as Reference
in my Access database.  However, I cannot get the YearFrac function to
work.
Does anyone know how to make use of the YearFrac function in Access?

Hi There;
This is a silly question but I have to ask this.
I want to create a query (SQL statement would be good!) that will do
the following:

I'm running Access 2000, using DAO.
According to the Object Browser, each member of the Relations collection has
a property, Attributes.  This value appears to be a bitmask, formed by
ANDing various constants which denote the properties of that relation:

I have a custom menu bar that I seem to be having trouble deploying with the
database.  This type of custom object is kept in the System.mdw correct?  I
have a target machine that won't let go of the original custom menubar that
I created.  Even when I remove the existing system ...

Dear friends
I would like to find the first and the last element of a record in a table.
Is there any possibility especially if yoy have not promary key?
Christos

Here is the scenario. I have a list of people, what building they work
in, and on what days.
Is there a way in access to pull up this database and have it make a
list based only on the days, like select monday and everyone who works

I have a continuous form.
For each record I have a field 'HeldDate' (Text Field from a table)
Against each record I have a button which sets the visibility of this
text box to 'True' and does various other actions.

How do I make a form open from the top and not from the bottom.  I have
to scroll up to the top of the form every time I open the form.  How do
I program it to open initially from the top?

I could use a little help from a good code writer out there. I found
some code and modified it a bit for my needs but, I need a little help
to finish it up. What I am trying to due is to get a number to fill out
a text box on my form. I want it to look at the form and get the

I was curious in regards to Access 12; specifically more fluent report
formatting.
I'm an average user, but from my end, I find more and more need for
cleaner reports....and do not always want to merge with Word.  Although

Hi, It's easy, visit http://www.ccsoftcn.com and download Access
Password Recover 1.62  to help you.
Can receive the correct password within 1 second.
Can change or clear password for the Access Database file.

I've found something in access I can't explain.....
I have two tables:
CLIENTS_COMPANY_A:
CodA    Int.

One of our clients recently upgraded their Office version to 2003. When
they tried to run our program (written in Access 2000), they ended up
with the wrong data. My coworker and I have tested this problem and
found that it ONLY occurs on Windows XP machines running Office 2003.