Can anyone please help me with code to open an existing PDF file withVBA?
Thanks.
Alan

When at work I run a macro in access to export 2 data files and save to
network and then launch a 3rd file( all in excel.)  I then run a excel macro
to get data files 1&2 and paste into file 3. then with the use of vlooksup ,
calculations and finally emailing out separate tabs ...

Help Needed.  I need to build an access query that compares numerical
ranges in minimums and maximums.  The two tables that are needed to
build the query are the following.
table 1: "Load Chart" has approximately 5,500 records

So, I've a form that gets 'filtered' ala Allen Brown's method filtering for a
field in a subform, which consists of concatenating an sqlString, and using
that sqlS as the form's recordsource.
I'd like to attempt to make a change, and actually use the forms filter

Some advice please
I need to create a table, define fields and types/properties using VBA to an
application I have already distributed. The database has been split.
Can anyone point me to any code for this and I am also unsure where the

I'm using the photo function from the Law Tracks example db. Access 2003.
When I try to insert an image into the contacts form, I get an error that
says "You have no program registered on your machine to edit pictures." I'm
running windows xp so I have the standard image editing ...

I have a number data type field that stores decimals representing time. So
for example the user would type in 1.25 which represents 1 and 1/4 hours. I
need to get Access to sum all the times and then convert it to hours and
mins. and store in a bound field. What is the simplest ...

The nice thing about autonumbers is that it allocates a unique number.
does anyone know where Access stores the info of the last allocated index
number?

I put a field with Contactdata from my Acces database in a word document like
this:
{MERGEFIELD "ContactType"}
How can I add the content of this field into activedocument variables in VBA?

Can anybody tell me how to print out the descriptions of all objects listed
in the database window?
There is an sql stmnt suggested in this forum:
SELECT MSysObjects.Name FROM MSysObjects

I have a list box in a form called "ADName".  This selects just two columns,
the first being the bound column.  The second is an e-mail address that i
want to use to e-mail an attachment from Excel.  I have used ItemData to get
the value of the list box but I need to use the ...

I have a question to ask. What i was trying to do here is to be able to
prompt user for the location where they want the new file to be. For example,
the file hasn't existed yet and is going to be created but the database needs
to know where the user wants the soon-created file ...

I have some code that sends an e-mail perfectly well however it puts the
first line of the body text at the top, then the attachment and then any
subsequent text below.
My question is how can I ensure the attachment is at the bottom of the e-mail?

I was wondering if there is a way of exporting data from query to excel
spreadsheet as shown in the code. The following code is to export the result
of the query to CSV type of format.
For example, i have a query (simple one) to retrieve students from student

I am getting an error message as Follows:
Compile Error
End IF
Without block IF