I have a listbox which can display all records or provide a limited
list based on a filter derived from an optiongroup.  The code works
except in the one situation where the listbox filter is changed.  The
problem

{Background setting}
I have what I think is a simple question that evades me since I just
started using Access.  I have a table that has 10 fields that
distribute utility costs to 10 departments (Depart A through Dept J)

I need to figure out how to create a user interface to search a query,
but here's the bad part...I need to account for criteria on at least 7
of the fields.  Here's what I'm thinking I need to do:
Create an unbound form with unbound fields for all 7 of the fields in

I am having trouble with the where clause in an openreport statement in an
Access Data Project.
I am using MS-Access 2003 with SQL Svr 2000.
The line I am using is:

I've just started having some problems with my coded queries. They had
been working fine but all of a sudden they seem to have started needing
US style dates eg mm/dd/yyyy.
When i build a query using the designer i can enter UK dates and it

I have a table looks like this in Access
Product        Sale Date
A                 date
A                 date

I have set up a db at work, I work in a flying school.  All students and
other pilots are included in this db, along with particulars such as Medical
Certificate expiry date.  I need to have the db 'flag' those people whos
medical certificates will expire in say, 4 weeks time.  ...

I would like to have a url in my access database, that when the user
clicked it i could pass the login and password to to the url.  I think
its possible from the other posts i have read.  Here is the URL:
http://www.mivalue.com/AVM/

A2000, DAO 3.6 ref set, 2 Parameters in query from an unbound form.
   Dim db As DAO.Database
   Dim rst As DAO.Recordset
   Dim qryDef As DAO.QueryDef

Goodevening all.
I am making a project in which i need to open:-
1)Table
2)Query

hi, anyone know how I can do the same as code "Application.CutCopyMode
= False" when I am in Access rather than excel but working on an excel
spreadsheet  (ie I want to empty the clip board.). help much
appreciated

I have a recipe database that I've been building but I haven't yet put any
of the ingredients in because of a little problem of normalization.  If I
build a table of ingredients, all the recipes will have one or more
ingredient(s), but no set number of ingredients, so that ...

I am using the following code to paint a normal form and it works.
   PaintDesktop Me.hdc
In the standard module i have the declaration for PaintDesktop
Public Declare Function PaintDesktop Lib "user32" (ByVal hdc As Long) As

I made a simple database of our products.  I created a form..."Part
Number", "Description" and a link to the thumbnail of the product.
I would like not to have to click on the link to view the thumbnail.  I
would like the thumbnail to show automatically in the form as one

I have just completed the development of a turn-key Access2k
application. I am using MS Access 2000k application, not the RunTime.
I have compiled it, split it (FE & BE), set all the StartUp Options to
Off, and created the FE MDE.  My problem is that the MS Access