I am using Access 2000 on W2K OS.
I want to close two forms and open a third form. The following code does
not close the FrmCombo0 form. The second DoCmd.Close works as does the
DoCmd.Openform. The current form is "Frm_Elementary_Phones"

I have the code working to create one sql query and transfer it to an excel
file, but what I really need is to create five different queries (that vary
only by one parameter and the name of the query) and transfer them each as a
separate sheet in the same excel file.

Hi, I am a novice, so please excuse my ignorance.
I want two Option Boxes to be mutually exclusive, i.e. when one is
turned on the other must be off.  So I put the two boxes into a
OptionBox Group.  But then I realized the individual OptionBoxes in a

I'm struggling with putting together the code that will allow me to create
links to a few tables on a SQL server from Access.  I can do it using a DSN,
but I'd much rather establish the connection without a DSN.  I've been
retrieving data from years without a DSN, I just haven't ...

I'm not sure if anyone is familiar with Word Viewer, but I am currently
opening a hyperlink attached to a record. Would anyone know how to open a
document from access using this program (Word Viewer)!
Your help is much appreciated.

I would like to know on how to hide a subform that is nested on  subform
that is nested on a main form based on a value of a checkbox.
I have tried many combination of the following line of code but bo success.
My sub-subform is still visible

Is it possible to refresh a continuous form so it gets the data that was
updated on another form using a requery or another function without that the
position of the record selector changes
even if I store the position of the current record (using myPosition =

I want a piece of code to run every 3.5 hours.  How do I get that to happen
without relying on a form to be open to count on the form timmer?  Or is
there a way to have a hidden form do it?

Table A has addresses which are updated annually.  Table B is from the
database of record (a different system entirely), which is updated
constantly.  It is now time to update Table A.  What is the most direct
overall strategy?

I'm having the hardest time getting a chart to display the data in the
format I want.  So I'm hoping someone can help me with it.
When using the wizard, I want to have 2 data fields while using a series and
axis.

I have added a ListView 6.0 activexcontrol to my form in Access.  I am
wondering how to basically take all of the selected items (from checkboxes)
and return them in a string separated by commas.  For
instance..."0575,0478,2028,2028".  I am also wondering how to have only one

I am opening a continuous form that is linked to a query that is only showing
records with a certain [TransID] value (and it is a long integer number).  
There could be 1 or multiple records (but never 0) and each one will always
have the same transid value (each time this form is ...

in Access 2003, I have a continuous form that I need for the field called
TransID (non-unique integer) to automatically replicate to any new fields
created in that table.  
How do I do that?

I use a commonDialogControl to open a directory with text-files.
When I select a file and click Open, I want to fill a text-field with the
filename, but I can't find out how?
regards

Thanks for taking the time to read my quesiton.
http://support.microsoft.com/default.aspx?scid=kb;en-us;210290 is not
working for me.  
I have my Row Source Type set to Table/Query, then I set my Row Source using