I am having a repeating issue with a report of mine.  I am going to try to
explain and hope someone out there understands me!
Table 1                        Table 2
AutoNumber               AutoNumber

Hi,  
With the execution of following sub in a global module, msaccess crashes:
The goal is to delete all tabcontrols of a form and save the design of the
form.

I have a recordset full of data that I need to dump into a table in order to
be able to query and report on.  Any suggestions how to do this?  I have the
create table part down, I just need to know how to write the data into the
table.

I have a button on my form from which I would like to open up a word
document. The word document would be located in a folder in the same level as
the database. Is it possible to do this?
I noticed with the button wizard you can create a button which opens up

I'm new to access so, any suggestion even if it may seem simple is a help.
When entering into the database, the user goes directly into a form that
displays fields in the database. Currently the sorting is based on the order
they were entered.

Good Day;
I would like to add record number field to a table. I figure all I have to
do is get the number of the last record and add "1" to it. Small problem, not
sure what the code would be to do this.

Hi this module to export a query to Excel works Access/Excel 2000 but
not with Access/Excel 2003. The Module comes up with the error handler
message Please ensure that you have not already got MoIncident.xls
open. and gets to the portion marked **** before it fails.

I've written a number of user-defined / custom functions and saved them as
modules in Excel. Is there an easy way to import them for use in Access.
These functions refer to parameters, names and tables in the particular excel
workbook (though they could all presumably be saved as an ...

Is it possible to use a variable as pathname in a maketable query? And if so
how do I do this?

Access 2003.  I know how to use the Package Wizard to create an installation
package for an Access database application.  How can I create an Update
Package, that is a package designed to update an existing installation?  If
it cannot be done with the Package Wizard, what can I ...

I've created a form in which I have a button which sends an email out to a
user. In that email, I'd like to reference the form number of that particular
form. I tried the following for my message column:
strMsgBody = "Issue no.[table1]![Database Reference No]  A Technical Issue

I have a form with a button in it which sends an email to a specified
address when pressed. I would like the message to contain the form number of
the form from which the email was sent. (i.e. - if the email is sent from
form 2, the message would say something like....blah blah ...

I am receiving run time error '3251' with the message: "Operation is not
supported for this type of object"  at line 7 (rcdOrders.FindFirst
"rcdOrders![....)  during execution of the following code:
Private Sub MarginForProduction_AfterUpdate()

I need to pass the variant(value1) in my database to a web page. I use the
following code to do that:
   Application.FollowHyperlink "URL.do?" & "variable1=" & value1
When I open the specific web page and type in the value1 my self, I will get

I have made my own switchboard, and want one of the buttons and its label to
only be visible if either a certain user is signed on, or if the user is an
admin. I would appreciate the code to do it either way as I'm not sure which
I am going to do. Thanks in advance for your help.