I am trying to shell out to run a VB script file. I do not need to track the
progress of the shell. It can fire off and then the VBA code can continue.
The code I have is:
hTask = Shell("c:\Cdosmtp.vbs", 1)

I have been trying to use the mousehook dll to disable the scrolling
function on the mouse.
I have tried copying and pasting the code from Stephen Lebams website
onto the on click event of a button and the on load event of a form.

Friend, I am using a code to export data from a table to a word
document using bookmarks and have a problem with a date format.
When I export a field that is a mm/dd, in my word doc it shows up with
the format mm/dd/yyyy. Is there a way I can export to show the format

Tried this on microsoft.public.access.gettingstarted - no response -
perhaps more appropriate here.
I'm not a database user, simply helping someone get started with a new
computer.

I am trying to have a search form feed criteria to a query which is the
basis for a list box in a search matches form.  I cant seem to get the
variables to transfer from the search form to the matches form.  the
variables were declared as public.  any ideas?

I am creating a new database by copying a template .mdb file. This
template has assigned permissions for each of it's objects. I know that
just by copying the file, I lose these permissions. Is there any way to
import them or set each of them through software?

I try this:
A first "group" query (sorry if this isn't the right name) count the records
from a table with a criteria (field1="A") and return counter1=10 records.
A second "group" query count the records from same table with another

I wish to make the commitment line times the Primary Key. There are no
duplicates, and the data type is Number.  However whenever I try this,
the Error Message 'Index or Primary Key Cannot Contain a Null Value"
appears.

Just wondering how others handle developing Access (2003) apps that
will run on a variety of different computers running at different
resolutions?
My impression is that Access doesn't really lend itself well to

I have a report that needs to be sent out to several hundred agents.
The report has both Tables and Graphs/Charts in it's content.
I currently generate the report and print each page in Adobe Printer to
create PDF files, but this stops me at each report with a prompt window

Someone here at work was out and her backup, apparently, erased a very
important table.  While the Help Desk is trying to locate a backup
tape, I was wondering if there is a way to get the table back without
having to find the backup of the database (if a backup tape can be

I ran into a weird problem with a subreport with an OnFormat event
of the subreport detail. When I view the field list in report design
view, all the aliased fields in the recordsource are available. But
when the report runs, the aliased fields are inaccessible. Of

I am trying to calculate Cost times Quanity but i also want to
calculate another field if the cost field is zero i have some thing
wrong, here is my code in the query
IIf([SundrySub]=0,nz([cost],0)*[Quanity]),IIf([SundrySub]>0,nz([Sundry],0)*[Quanity])

Is there a way to check a files date and time stamp from VBA in access.
I have a need check a date stamp on a file that I am importing.
Thanks in advance,
Mike

I know this has been posted elsewhere, but none of the fixes in those
posts seems to address the problem I have.
First some background;
I have two tables, Exp_info (containing the field "ExpID" among others)