I'm trying to get my access database to display a message box where the
user can type in information that they want a report to be created on
when a button is clicked but so far everything I've tried hasn't
worked.  All suggestions welcomed.

I have a report that when selected opens a form which has the path where the
report will be saved as a pdf file ( I am using a program called Primo Pdf).
THis location is automatically copied into memory
When I hit continue on the form it opens the primo pdf writer form which has

I am using Windows 2000 and Access 2000 and I want to programmatically
disable the scroll wheel on the mouse when users are viewing a recordset in a
form
I want to limit record navigation to the standard navigation buttons and

I would like to run a query whenever the DB is opened. The query is named
"RemQry". It returns records where the days transpired is greater than 2. It
contains the owners of the records and the email addresses. Once "RemQry"
runs I would like to programatically send an email for ...

I have some records to print to serial printer (like Epson LX 300).  If I
create a report and then print the report, the page break is always added so
that even the report has few lines, the printer will scroll and load next
page.

I have a very "novice" question in regards to reports.  I am trying to hide
several labels on a report base upon choices on the data entry form.  The
current code I have is below:
If Me.ChecHomeImp.Value = 1 Then

My problem is that the same basic query needs to be run from different
tables. How can I  create a query at run time and code it to the
docmd.transfertext command.  I have only been able to run a stored query.
dan

I have written some VBA code in a adp in access using a SQL2K database. The
code runs mostly SQL statements using the '.execute' command. There are
several loops in the code which also use some recordsets in the data.
The code runs fine on my machine, taking about 15 mins to run. ...

I would like to have the ability to create a query that pulls data from a
table in a format that enables visio or as an access report to automatically
create a flowchart from inside access. This would enable me to see
associations in my data. I can do something similar by ...

I have a query that i want to export to excel. This query retrieves about 40
000 records. When i export the query there's no problem, but when i try to
programme a DoCmd.OutputTo action i get the following error:
" Run-Time error 2306:

Just wondering how I would write data to a table on a button click
after i have entered the data into a form.  All help appreciated.

In the code below I had to stipulate the full UNC for "DoCmd.CopyObject" How
do I set this up to work anywhere.
Code
Dim StrBDM As String

My code below is an event procedure when I double click from a field (JPL1 -
"strjpl1") in a form and it will retrieve only data from current data. what i
need is your advise or show me sample code should i have more than 1 data
i.e. "PN" (strpn). anyone there can help me. i have ...

I'm trying to find the vbscript  to create a record selector on a .asp page.
I know this forum is specifically for Access, but if someone could assist me
or point me to a forum that is specifically for vbscript I would REALLY
appreciate it.

in Access ,I need to export some data to An Excel file
now,the path is constant
I wanna to let the user to choose the path via dialog form
How can I realize it?