Running Access 2003 and need to open an Excel spreadsheet to run an excel
macro by clicking a button on an Access Form.  Does anyone have some code
samples that show this?

Thanks for taking the time to read my question.
Just wondering how to empty an array after it has values in it.
Thanks,
Brad

The following is a part of my validation on the BeforeUpdate event procedure
of an unbound text box (Me!PndCk18In1) on my form.  My issue is that although
it captures and prompts the "error" this line (Me!PndCk18In1.Undo '**ISSUE**)
does not seem to work therefore after the ...

I have a situation where a query attribute is a function call that takes two
parameters.  When I add criteria, Access treats the attribute as a parameter
query before calling the function.  How do I call the function without the
atrtributes being treated as a parameter query.

I am tryuing to dynamically position fields and labels in a report header
based on selections made by the user
I have entered the following in the On Format properties section
If DLookup("location", "repgroups") = "Left" Then

I have a table of book titles with an index back to an author table.  I
would like to have a form with a search (find) button on it where I can type
in a title or part of a title using wild cards and get a display of all the
books and authors that match my search pattern.  Is ...

Currently I'm using a SELECT...INTO statement to create a new table upon
which a second query is run in order to return some rows to be used to
populate a bunch of textboxes. Afterwards I DELETE the new table I just
made. I would like to skip the steps of creating and deleting ...

I have a form with 2 fields in,
now i want to see if this to fileds match
to fiels in my table , i know how to write
in sql by select and so onbut how do i connect me

I have a database with password but I need to open it from anothe
database(it is the program). When I try to open the program it says "N
valid password".
How can I use opendatabase in VB

Thanks for taking the time to read my question.
I have a string that I am parsing, and sticking into an array.  The string
has text and numbers.  I want only the numbers.
So I've tried setting my array to Double, but it is still allowing text.  

I have a combo box which sets a form which sets subforms on that form.  The
only problem is that the combo box doesn't have a value when it initially
loads, it's blank.  What sort of method should I have the onLoad event call
to have the Combo box start off with a value listed?  ...

Is there a way in access like in excel
where i can hide the application, but not my forms
I wold like to have that access open in a form but
access program, menu and so on is not visible.

Good Evening,
Does anybody know of the programming syntax to open a word document in a
specific layout????
i.e. Print Layout, Normal Layout etc....

I am trying to develop an Access application which requires that the data be
displayed in an Outlook calendar monthly format to include displaying an
event over a range of dates.  I would prefer to have the object as an
embedded item in the Access database so that the application ...

http://i9.photobucket.com/albums/a66/bubbajoe12345/workspace.jpg
I've created a nice form for entering/viewing information into the record --
works for viewing the records as well.  But, when paging through the form,
using the default arrows to go to: First, Previous, Next, Last, ...