I have an application using an old version of access that i developed
over 5 years ago, anyway I need to resurect it.
It has wrkgrp passwrod protection. It appears the app and the data are
split. Reason was that the data resided on a server and the app would

I have a drop down combo box that gives the user to enter an item not in
the list by adding it to the list.  The list is a table.
It works fine on Access2003 but fails on Access2002/XP.  ON XP, it seems
to work, shows the message that the entry has been added, then I get an

Let me explain.  I have been given a file that I need to bring into an
Access table.
Here is a snippet of the file.
100833983

Access 2000 running on CC3 network. Usually not more than 20 users.
Crashes seem to occur randomly. Is it possible that a laptop going onto
standby or hibernating with db open would cause a crash? Is there a way
of avoiding this? When I say crash - the db becomes completely corrupt,

I have a database of staff details. I'm using a query on these details
to sort by reason for absence. I want to be able to add the number of
days absent together for each reason.
Eg Flu = 1 + 2

I used to be able to create PDFs, automatically save them to a file,
and mail them out to people.  This was on Access 97 with Windows NT.
We've changed to Windows XP and Access 2003.  Doesn't work anymore.
Part of the problem is that the users have no access to the registry

I have a table called tbl_employers. One of the fields is start_date.
I'm trying to make a query that will show all entries where todays date
is 275 days and 305 days after the start date.
Any help would be appreciated

I am developing some Data Access Pages (DAP) using Microsoft Access
2003 on Microsoft Windows XP.
When I try to open these pages (located on my C: drive), the display of
the data access page is blocked and I receive the following error

I have a problem where one text box has a paragraph of text in it and
for some reason when the report is ran the first sentence in that box
stays on page 1 and the rest goes to page 2 leave a huge chunk of
whitespace on page1 unused.

Using A2K3.  I have two forms open.  I would like to run a procedure
located in form #1 from form #2 before leaving the 2nd form.
I think I've seen this in one of the Access books but can't remember
where.  Is this possible and how do I do it?

The documenter function in MDBs doesn't appear in Access 2000 ADP's. Is
there way to do this short of exporting all of my forms, reports and
modules to an MDB and then running the documenter (which is what I have
been doing now for a couple of years!)

Hi there i have a little problem with my invoice.
Here it is:
i have a main menu with buttons, one of my button is "Create new
invoice", when  click on it a form pop up so i can enter my information

What are the ToDo's / Gotchas to convert an MDB Access 2K2 database to
an Access Project (i.e. ADP) file for the front end using Microsoft
SQL Server 2000 Desktop Engine (MSDE 2000) for the back end?
Now for the background. I have a prototype MDB file that was built in

I know how to create a hyperlink to a file, Is it possible to create a
hyperlink to a folder on the server using Microsoft Access 97?

I'm having some difficulty and I can't for the life of me figure
out why.  I have a main report, rptMain, that contains a report
header (displays the AppTitle), 3 group headers (one is a
header for the "report version" and is being used for a cover