I have an Adp form (Acc2000) connected to a SQL Server 2000 database.
When I filter the form on area code, the resultset is for example 10 records
out of 100 records. After that I change the area code (part of the filter)
to a new value. Then the form looses its filter, 100 ...

I have a table with 2 fields: Zipcode and Dollar. I want to create a new
field "Relativity" that equals to Dollar/Dollar(when Zipcode=44444).
how do I write it in SQL?
Select ZipCode, Dollar, Relativity as Dollar/(Dollar When Zipcode=44444)

I am developing an adp report that loads a different picture for each record.
I am using image object, setting the .picture to the external file path of
jpg file in the group header for each record.  Besides the load of each
picture being slow,  I also was getting this message ...

I have 10 records with 10 vehicles.
For example: Ford Explore        
                   Honda Accord
                   .............

I have a form that is based on a stored parameter query ( this is an adp
project ).
It works fine when I first open the form from a main menu. I am prompted for
a client number.  However, when I want to look up another client number, I

Using Access XP with MSDE (2000) backend.
I am opening a form and naavigating to a specific record (based on the
openargs, not conditions as when I use conditions an activex control
displays in the wrong place - but thats another story).

Hello....
Not sure if this is the right newsgroup for this or not.
I'm trying to learn to migrate to using classes and oop.
Instead of referencing a form like

I have a small sale database in Access 2002 with SQL 2000 back end. The
database works fine except that the manager want a POP up notice about any
product that is less than 5 in stock. Does anyone recommend possible
solution here?

I've been fumbling around with this for entirely too long, and I need some
assistance.
What I'm trying to do is to set up a form where the user can select from a
particular set of fields (which obviously exist in one of my tables).  

Hi. I am trying to open a hyperlink through code to a redirected asp
page but it is not working.  Here is a portion of my (revised) code:
Dim strsql as string
strsql = "http://dev.companyname.com/submitpayment/Redirect.asp"

Hi.  I have an Access 2002 ADP project connecting to a SQL 2000
database.  I have a form "Main" using a stored proc as a record source.
I have a continuous subform "Sub" using a Select statement as a record
source.

I have a big MSSQL2000-Database. I want to query the data. I have no
SQL-Server yet. Is it a good Idea to install SQLExpress, attach the Datafile
and connect to Access 2003? Who has experiences?

Access 2003
I do not have a Stored Procedures object group on my database list. Instead
all of the Stored Procedures are listed in the Queries Objects list.
A couple of books I have read store a separate Object for Stored

I have an MS Access project with SQL Server on the back end.
How do you suggest I develop access/security in this scenario? I have an
application with two types of Users.   Those can Insert, Update or Select
from any table but thye may may not delete (Group A).    Or those who can ...

I've got this SP:
CREATE PROCEDURE
EWF_spCustom_AddProfiles_CompanyYear
@prmSchoolYear char(11)