I am needing to output reports from access to PDF. This seems to be a
simple task with the PDF/XPS add-in and it works fine maually. BUT
when I use it in code with the OutputTo it takes 15 minuites to save a
report that when done manually takes < 1 min. I have found that I can

I have a crosstab query wich produces 3 columns of numbers - thats ok.
Then I get a select query using the crosstab query as source and multply
each of the 3 vaues by a different factor using expressions - thats ok too.
Then, in a 4th colum I add the three values, it works if all 3 ...

Hi -
I am trying to create a schedule task to send a daily Report vcia MS
Outlook.  
I had this working before but got my pc re-imaged and now I have to

On the form "frmtest" I have 4 list  boxes.  The data from the list is
generated from tblTestDescriptions.  Once the data is populated into the form
"frmtest", the data is stored in table "Run Book List".  
What I am trying to do, is make my first list box a combo box.  When you

My user would like me to switch the quit button from closing the database and
access, to just closing the database. She wants Access to stay up and allow
her to manually open up another database (avoiding the load time for access
itself). I  searched for code examples, but only ...

I have Windows Vista and Office 2003.  In Access 2003, it is using
millimeters and I would like to use inches.  How can I get it to change from
Metric to Imperial?
Sincerely, Marnie Shaw

In my database as each item is counter into inventory it is added as a new
line. When I do a report it shows all the lines of the same item. How do I
just get a quanity total of the item?
Thanks

On my form I have a place to select the employee.  It is a drop down box.  I
can see the choices that I have but when I select one, I get a beep but no
entry.  If I go through the tables, I can select the information with no
problem.  I have checked the properties and I can not ...

I have a spreadsheet that has multiple dates in the feild, I would like to
just group the data together by month and do a count and a sum on two ther
feilds of data. I have tried to input MM in the format box which than shows
me just the month number but when I apply the group ...

I have some macros that are running quite a few exports of queries and
also some maketable queries. I'm wanting for them to run WITHOUT me
watching over them and clicking "Yes" to making a new table and the
like. It is also likely that I will get an error message such as "n

i am new to VBA
I need the date in a field to change to red when it is 14 day old can this
be done?
I tryed using the =now() but no luck

I have a query that runs a calculation in steps in different fields.  They
are as follows.
CompWkDay: Weekday([Completion Date])
DayAdd: 6-[CompWkDay]

I am using Office 2003. I need to be able to open AND MODIFY  a specific
existing word document for each client when using access.
eg In access,  I select a client from a query, then I need to "click a
button" which will open the Word  document specific to that client. I will

I can't figure it out, I'm trying to create a function to find prime numbers.
Option Compare Database
Option Explicit
Public Function IsPrime(rngVal As Integer) As Variant

I have a set of query's that I am using to create a report (or set of
reports). I have set the date criteria in one of the query's and have
the rest using that query to build the rest of the query's in the
report. My question/issue is that I would like to be able to build a