Access Gurus,
 This script was used to view the reports on the web by choosing a
date on or before the current day.Recently it stopped working and i am
not able to figure where the problem is.

I've been asked to write a database in Access and I'm making my first
steps.
I've encountered some problems:
1. I've made forms using the wizard and for some reason the fields are

I use Access 2000. I have a linear plot in the database. What would be
the best way to find the change in the highest linear point to the
lowest linear point on the graph? Graph values come from a table. Each
point comes from a different column in the table. A single linear

I have a Main Form, then a subform.  There is a date field in the
Subform that I want to be able to click on it, and a VBCalendar popup
in the main form for me to choose a date (I don't want it on the
subform because there is not enough space).  After the date is chosen,

I have a number of tables which have Text fields. I need to change the
AllowZeroLength property value to True for all of them. Does anyone have
some code which will do this for me ? Thanks.
Laetitia

I am trying to conditionally format an unbound field in an access form
based on the value in another access field.  The unbound field is
actually the background to the form.  I want users to be aware of the
status of the case that they are working on.  For example, if the

I am hoping someone here has experience with this. I am using Access
97, but if someone has done this in another version I'd appreciate
input as well
I need to populate a table with subdirectory names.

Hopefully a no brainer here.
I have an Access 2003 application that was upsized automatically to an
SQL 2000 database using a wizard. Works fine.
Recently I've copied and pasted that SQL database and therefore

Help! I am having a very aggervating problem with Access. Call me
lazy, but I like to copy and paste addresses from Access into
microsoft work, like for sending letters where I only need about 3
envelopes. The problem is that some of my envelopes are coming back

I have a form which contains a multiple selection list box. How can I use
the list box so that all items selected are added to the record of it's
corresponding field in a table with each selected item seperated by a comma.
Example Listbox:

I have a MS Word Merge letter that is based on a query.  I set up a
macro to run the query and then open Word and the merge letter.  Word
open fine but it can't find the letter.  I used RunAPP and put the
following in the cammand line box.

I am trying to take the first initial of the last name of an employee
and add as the first character of their employee number.  Is there an
easy way to do this?
Thanks

How do you change what row is highlighted in a listbox (so that it
highlights the current record you are viewing in the form) when you
use the built-in navagation buttons (or any method other than the
listbox itself) to move between records in a form?

dear respected Gurus,
Sir, I created one table(say tblA has UserID/password) to verify, then
i Have another table(say TableB UserID/Allow(Yes/No), tableA has
1-many relations with tableB

I split a simple Access2K database ( shared on network )and placed
the files thusly :
x:\app\frontend.mdb
x:\app\back\backend.mdb