I have a "Page Setup..." button on a custom toolbar that appears when a
report is displayed in preview mode. Selecting "Custom Printer" allows a
user to select an installed pdf viewer (e.g. Acrobat Reader) to print a
report to.

How can I close all open tables and queries with code

I have split database.  I want to run code on the backend from a module.
I'd like to run it on a timer once every hour.
How would I do this?
Thanks

I have an updatable query based on 2 queries.qryinput and qry output. I want
to update a  field in the table products with this result. Since the query is
non updatable ,how should i proceed, can i use the dlookup function? How
should it look like? My  query is the following

I am linking up to outlook inbox to extract mails.  When my mails are
received, they are put in a series of fields. I am more interested in
splitting the contents table. This is the body of the outlook mail. Below is
a sample of our data reads in the same field.

I have code that loops through a list of Customers displaying the same
report for each customer in preview mode
1. The problem is that each report overwrites the other and only one
customer's report is displayed

I have a perfectly normal query  giving the right results. but when i copy it
and try to use it as sql i get red letters.May be i will have to change the
commas or something ?
strsql = " SELECT products1.Productid, DLookUp("grade","products","productid

In the code below the query takes to long to execute. Is it possible to wait
for the query to be executed?
'Option Explicit
Option Compare Database

I would appreciate some help writing a function for access. I have a table
that  contains 3 date fields.  I need a function that returns a count
(integer) of how many times Time A falls between Time B and Time C.  every
record has all 3 times.

i would like to create a user defined domain aggregate function such as
calculate the median of a series. ( i would like to be able to do this
without calling on excel)can you tell me how to do this. also, can i
calculate the query by using the query designer. thks

I want to load the data in a select query into array(s) in VBA code so that I
can manipulate the data.  (ACCESS 2003)
Query has 7 fields (call them A, B, C, D, E, F, G) for brevity.
There could be any number of records in this query.

My accdb works great.  Everything works.  When I compile the accde I can run
any VB.  I don't get any error / warning that I can see.  I need help!

We are trying to do Modulus 10 on string that is 57 numbers long
(015116946868000060740000012463000112100031150000000016699).
We need to be able to multiply every odd number with 2 and then sum up even
numbers.

I have two queries, almost identical; except one is for scoring questions
answered correctly, and the other is for incorrect answers. The questions are
often repeated, which means the user can sometime get them right/wrong. I
want to have a real time scoring system where as the ...

I'm using Access 2007 and my question is
Where I can find samples of how to call Subroutine or how you incorporate a
module with your application
I saw a lot of codes but not how to leverage it with your forms for example