I have two pass-through queries in my database application.  This
application is used only by my department.  In order to make the queries
function, I went to each user's pc and set up the two ODBC Connections.
We now want to enable users outside our department to use the ...

Driving me nuts. I filter records on several of my forms by selecting a
value
in a combo box that is based on a record type tables. For instance, I select
"Drama" from a cbo to view only drama in my movie library. What's happening

As a first attempt at Excel, I'm trying to set up a check register(simply
deduct payment or add deposit to create a new balance).  I have the correct
formula, but I don't know how to make it automatically extend to the rest of
the balance column.

I have an application that includes installation properties
from which public variables are loaded when the application
starts. They include such things as file paths, and a variety of
names that are peculiar to the installation. Like "YOUR

Dear friends and pros,
I'm trying to call the name of the day based on the specific date entered in
form, when Monday is th first day of the week.
What can I do?

The database I am working on has an employee information form on which there
is a subform which lists education.  The subform is linked using the
employee ID and used tblEducation as its source.  In this configuration, the
subform would always show a blank record in which the user ...

I recently saw steve leban's A2KLoadJpegGifVer33GDiPlus (
http://www.lebans.com/loadjpeggif.htm )and
liked it's way of doing things, but I could use some help. I am looking for
a way to import an image

I have received a database from another consultant which has been edited in
more than one version of MS Access.  It seems that the forms are corrupt as
they keep trying to call VBA code or macros that are in the database but not
called at the time.  I have tried to fix the ...

Just as there is code to establish and refresh table links, I would at time
like to break or delete these links.  I would like to know how that is done
in code.  I have been able to follow the code samples for refreshing and
linking tables, I am requesting information on how to ...

I have inherited a DB with dates, in the form 13/9/1999 (ie European format),
stored as nvarchar 50!! It's a funny old world..... Is there a function to
convert such things to datetime datatype (the time bit doesn't matter
historically so in the data conversion all would be set ...

I am using Access 2000 and I am working through an access visual basic book
that is for Access version 7. In the book is a lesson with code that allows
the user to choose if they want to entering the zip code or not. The book
uses certain objects that I think may not be in Access ...

Is it possible to format the 5 first rows in a list box differently than the
rest? In example. The 5 first rows are Arial 8pt bold, while the rest is
just Arial 8pt?
Any hints appreciated!

I would like to disable the caps lock in data input form to prevent someone
who enable the caps lock all the time during data entry.  Can someone advise
me how to accomplish it.
Thanks,

I was wondering if there is a way to make Access a standalone. I know
about making an MDE but I don't think this is the same.
I would like to have it run from a CD rom so I can send it as a demo.
I have taken special precautions to ensure that nothing is being written

I have a Mainform with subforms on it.  The main form is "read Only" for
browsing purposes.  When the User reaches a record to edit, there is a
"edit button" to edit the record.
I've tried the following code but it doesn't work.  It only makes the main