I am working with a Microsoft Access Database helping a non profit
organization try to figure out how many nights in a month people are staying
in there shelter.  I have two fields a Check In Date and Check Out Date
Field.  Therefore to figure out the nights a person stayed, I ...

I have never written a macro so I need some guidance please. I have a query
that pulls data for all of our marketing reps. The query sorts the results
based upon last name. What I would like to do, if possible, is export or
transfer to a spreadsheet the results but put each ...

Currently under "design view", under "Macros", I have an "output to" record.
The "output type" has limited options, and I need to get this changed to "tab
delimited format". Please could someone offer some assistance, as I have
found nothing on the net. Thanks

I have two different invoice reports based on productID. After I have entered
what invoice number I want to see, my commandbutton should print report A if
productID is between 80 and 89, else it should print report B. Is it possible
to put this criteria to OpenReport-action or is ...

I have set up a data base with a query-based form in which I enter a range of
dates to call up a set of records...so far so good.  I also have a Direct-X
date picker which is very easy to use and which I can plunk almost anywhere
in a form.  What I want to do is use the date ...

I know there is a macro that does this that works in Excel.  Will the same
code work in Word?  Where can I find that macro?
My goal is to enter the currency amount in number format in a field in a
Word document and have it appear in text format in a second field, e.g.

Hi -
I have a query that I need to send to a shared directory - how can I do this
via a macro?  I know how to sent via email, but what command do I use to send
to a directory?

How could I insert a photo on the database and show it in a form?
I have created an OLE object and try to insert a photo but I don´t success
showing the picture in the form, I can only open it clicking twice and see
the image but not surfing form one record to another.

Is it possible to get the numbers of records from a query / table by using
Macros?
Thx in advanced.

I am using an OutputTo macro in my AutoExec module.  Is there any way to turn
off the prompt that asks if you want to replace the existing file?  I have
DoCmd.SetWarnings False as my first statement; however, I am still prompted
to answer yes or no.

I am running a raffle.  I have one worksheet with peoples names and a
associated number.  I have a second worksheet with the raffle ticket numbers
and the associated number of the person who purchased the ticket.  I need to
be able to enter the ticket number and have the persons ...

Is it possible to convert the output in a report in capital letters? How?

I'm using Office 2000, getting run-time error 429 (activex component
can't create object) which fails on this code:
    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset

I need a macro to automatically copy the value of a field from one record
into the value of another field in the next record...  so, for example,
[closeamount] needs to be copied or forwarded into [openamount] for the next
day.

Trying to create a macro that will open a table and then go to a RANDOM
record.  After selecting the random record, append it's selection to a
different table and delete it from the original.
Can anyone tell me what the Access Offset expression is to go to a random