I want to call a stored procedure which is written in SQL Server from
an ms-access query. It is having some parameters also and the stored
procedure will return some records.
Is there any way to do this?

Is it possible that when having a user using Filter By Form in a form
that no matter what the user enters in for a value that "LIKE *Value*"
gets automatically replaced?  Would I have to do something in the On
Filter or On Apply Filter event?

I have 3 unbound combo boxes in my form which basically helps me to filter
for values. I need to update a text box which will be stored with the value
I receive after filtering with the combo boxes. I know of the column(n)
method (derived from the third combo). However if the user ...

Anyone have experience with either of these datbase compare tools?
ComparWiz2003 - $49 license
http://www.softwareaddins.com/CompareWiz.htm
Klik ComparLib v1.2 $199 license

I am trying to import a dbf file created using visual fox pro and it says
'External table is not in the expected format' What might be the reason for
not able to import. Is it something to do with field size or name.
What is the best way to get these .dbf file to import into my ...

I'm fairly new to this group as this is only my second posting but
nonetheless, I appreciate all the help I've received so far.
Anyway my original post was about how to use FindFirst to go to a
corresponding record that had two primary keys (ID, VISIT).  And upon

Problem Statement:  Mary wants to share a distribution list of
approximately 1000-2000 people with 3 other people.
Sorfar I found three forms of address books that we can use for this.
1.  The Outlook contacts.  The distribution list can only contain

How do you execute an existing SQL DTS package from a command button on an
Access form.  I am not going to use Access data pages, just a standard form.
Thanks.
Matthew Wells

Ok, so I'm creating a form on the fly.  I can create the option group,
I can create the checkboxes, but I can't figure out how to bind them to
the option group I'm creating them within.  I was hoping the fact that
creating them inside the option group would cause it to automatically

This is not a big problem, but I was hoping someone a bit more
knowlegable than I could explain something to me.
I have a simple function behind a form which writes changed values to
a table for tracking purposes :

I have an Access database on a shared drive. It is used by 8-10 people
at any given time. I have a form set up to be opened in either "add" or
"edit" mode. The problem I am having is the "data-entry" option on the
form is changing to "YES" by itself. This doesn't allow users to view

Hello to all,
                Here is what my report looks like in the Grouping by Dept but
I want to get the total for in the same report
======================================

I'm doing some computations in order to do capacity planning.  Instead
of using some function from an Access book to do the weekday
calculation, I decided to come up with an alternate method since a
typical capacity report will look only at hours quoted for the next

I have developed a form, commencing with the form wizard showing in Design View. Having
developed the form partially, I wanted to put a page header on it which would contain the
controls. I set up the header in Design view, but when I switch to Form view the header
does not show. Is ...

Today I put together a form for a calendar pop up for picking dates that
I'm going to make available for other developers in my organization.
It's appearance is based on a calendar pop up that is displayed in a
major maintenance program I use, though I haven't a clue what the