I have 2 questions with TransferSpreadsheet.
1.  How do I open and select a sheet on the spreadsheet that I have
just exported? After gleaming the Newsgroups I have got this far but
can't work out to select a sheet...

Dear sir,
I have a form and a button on it. When I press that button, OnClic
event runs.
and "Me.Requery" code runs.

This should have been easy but it is not working. I go from form1 to form2
(openform command). I do not close form1. When the user clicks on a button on
form2 I want to go back to form1, which is still open. I do not want to close
form2. I have tried to use setfocus to go back to ...

I have written a simple program that does some documenting of the
applications forms.  However, I am missing one element the forms Caption
Property.
I have included the code that I wrote:

Hi. I'm trying to figure out how to set the options for the find and replace
dialog box. I have a form with a command button that opens the dialog box,
but the original developer used a series of SendKeys commands to set the
various options for the Find. This is buggy -- ...

    I am looking for the following
My Table name is: Orders
Fields
SL # (Auto number)

How do I use a multi-select Listbox to select multiple reports to print?  I
know this is a tricky procedure if you can help I appreciate it.

I have a subform with a relatively small (under 40) maximum number of records
for each main form record. I'm using a tab control to identify all the
potential subform records, whether present or not (this is a cosmetic feature
- no data is actually stored on the tab control ...

Hi;
In some Databases,such as fox pro (under DOS systems),tables are saved
independently from the main Database file.So,although i can import a table
that is saved on my drive E (named E:\m1.dbf) using dBase IV driver and thru

Hello everyone and thanks in advance for your assistance.
I have a form that pops up in the middle of code (set to pop up, modal and
opened acDialog) as a type of custom input box. My problem is how to I get
the variables to carry over in the code once the form has closed? ...

I have a table with a Date/Time field.  I chose Format: General Date because
the Example is 6/19/1994 5:34:23 PM.
I have a form with a text box that looks up (on Form Load) the time field
from the table.  I also set the Format of the text box to General Date.

I have a form (frmSARsByElement) based on a query that asks for a parameter,
"Element".
I am trying to build a main form with a text box (txtElement) and a button
that will open frmSARByElement using what is typed into txtElement as the

I have Office 2003 Professional and Office 97 Professional retail versions.
I do not have Visual Studios, and certainly not a MSDN subscription. I have
never made any money writing programs and want to start. I need the CHEAPEST
way to be able to develop for other users who MAY ...

  i write a code in which i have inserted some DLL through
Tools>references....and i compiled my modules..my doubt is what exactly is
happening internally...ie is that DLL is compiled with my application...if i
deployed my DB in some other machine whether my application will ...

How do I prevent the datavase window from opening when the shidt key is held
down?  I always thought it was in the Startup options, by unchecking the Use
Special Access keys checkbox.  That didn't do it however.
Thanks for any help.