Is it possible to combine conditionals to call out data?
I have a list of records that include a date. I can call out all dates
after the date after tomorrow:
IIf(Date()+1)<[date],...,...

I use the above function in queries for a number of forms and reports.
The reports take approx 20 seconds to open.  There are only 100
product id's in tblProducts.  My concern is that the time will
increase as products are added.

What is the syntax to use in a VBA script to execute a pass-through?  Thanx

How do I do this.....
???
Thanks
Shikha

I have a client who would like to have several pictures associated
with one system.  I have read about storing only the pathname to save
OLE overhead and have set-up a form for my client to browse/add one
picture at a time to a system.  Now he would like to 'view' all of the

I am trying to insert a .gif. file into an  Access report - using
Insert Picture.
The original image is 8X11,  but access changes the size to 4X6.5.
When I change the size of the image in access is puts white border

I've a simple table containing member details.
I've written a SELECT to select all the members.  I've based the form
on this select, using the from wizard.  Once built I've disabled the
MemberID key field on the form.

I am in the process of 'figuring out' how to verify if I have a valid
connection to an ODBC data source (SQL Server 2000).  I've written code to
run a pass-through query against a table that is in the database.  If the
query fails, I want the function to return a 'FALSE'.  The code ...

I have office 2000 installed but in references I see office 10. The rest of
the office apps are still 9.0. The problem is that when I send the compiled
access app to clients who have office 9, the app breaks. How can I get back
office 9.0 reference?

Is there any way to skip lines programatically within a listbox as there
is in a textbox? I have a listbox on a form which gets populated with
the attachments I want to send with an e-mail but they are all mashed
together and ideally I would like to skip a line between each

Bonjour à tous,
Je développe une base traitant des candidatures pour des jobs. J'ai
créer des requetes me donnant des listings d'individus selon des
critères, et je désire pouvoir accéder directement aux informations

Can someone please provide me an easy and effective way to convert
MySql database (with data included) to new Postgree database?
Thanks,
Konrad

Today my first attempt at installing an application that was prepared using
the Access 2003 Package Wizard of the MS Developer Extensions failed.
How can I determine whether the runtime engine has been installed despite
the overall installation being unsuccessful?

I'm looking for some help.
I have 3 Access 2002 db's. Access1, Access2 & Access3.
I need to write some code in a module in Access1 which will:
Open my Access2 db and Import some tables into it which are in the

I have a table of mappings of various codes, tbl_Map with fields
mapID, code1 and code2
I need to write and Update command that for each row in tbl_Map
updates another table's, tbl_Codes, "code" field with code2 where it =