I've got an Excel Macro in an Access Module and it isn't working properly.
The first time it is run (after the database is opened) it works perfectly.
Subsequent tries after that don't work right.  The Excel code is below:
   Set XLbase = New Excel.Application

My goal in the following code is to use the Array in the For Loop to generate
the field names by concatenate the numbers 1-4 at the end of the first part
of the field names
i.e. HiPathKey1, HiPathKey2, HiPathKey3... unfortunately the method I'm

Does anyone have a suggestion on which forum to look for help on the Access
Developer Extensions? Specifically how to include an odbc datasource in your
install package.
Any help is, as always... Greatly Appreciated.

I am currently using the code to get the network userid on any newly created
records.  It works perfectly as I have a form with an UpdatedBy field with
the default value of =fOSUserName() which is the function name in Dev
Ashish's code.  The module name that the function resides ...

I am trying to setup an array to store a single value from multiple record
sets. The value is Margin. Here is the code I have:
Option Compare Database
Option Explicit

Hello.  The boss is beginning to ask about the number of lines of code that
there is in different Access databases that have been created and those
currently under construction.  Does Access have a way of determining that or
is there another method for determining (other then ...

In Excel, a default chart has the y-axis label partially blocked by the
border of the label box.  I am using Office 2003.  How do I let all of the Y
axis label show?

I use some specialized CAD software to design timber structures.  It supports
some export to Access and has some limited Access database functionality that
the developer has provided.  In German.
The module below converts a integer mm value that gets exported from the CAD

I have been tasked to create a perl login.  I have worked out most of the
imporant items such as login name, setup of printers, etc.
I don't know the perl command to view the user group membership. My boss
have created new groups which determine network drive mappings ? The old ...

Hello, I'm using Access 03.  I have used the Wizard to create a "duplicate
record" button on my form.  After the user clicks the button to dup the
record, they want the [First Name], [Last Name] and [email] fields to be
blank in the new record.  The code behind the button is as ...

I just want a specific size. I do not want maximize. How to code it?

Good Evening,
Instead of forcing a user to use a button to close out of the database I want
to allow the user to click the red - x in the right hand corner of Access
Window.  To make sure the user wants to close the entire application, I have

I have set up a module to run when the main data form is opened, to check for
"Next Steps" dates which are within two days of the current date.  I set up a
table and an append query which pastes qualified data into the table.  The
routine calls that table for its purposes of ...

I need your help ...please!!!
Can anyone tell me why I'm getting the following write conflict error when I
try to insert a new record in a SQL Server table:
""This record has been changed by another user since you started editing it.

I'm trying to use a time in a select case statment, along with the <>.  It
doesn't work whith the <>.  Is there a way to make this work?
vTime = Format(Time, "h:m")
vDate = Date