I have a massive database that contains a table that has one column with
account numbers. However, I'm linking to another database and it's table with
the same information does not have leading zeros for that field.
So.. I need to modify the large database to remove all leading ...

I've got a simple parent:child join that pulls out 10 fields (usually only 1
or 2 rows) and I want to mailmerge the data into a Word document already set
up with the appropriate insertion fields defined.
I haven't done this before & need some sample code to guide me.

Below is the code where I have an append query whereas if there are no
records to append, a message box will appear.  I can't seem to get it to
recognize the fact that there are no records.  I have tried "count", "If
Count = 0", etc.  Please help.

I have an array that can go up to 25 columns and 9 rows in size. I am taking
the contents of this array and placing the data into an Excel sheet through
VB.
Sometimes, however, the array may be only 24 or 23 columns in size since

I need your help with my database, I am using ODBC to connect to our server
which houses all the data, but in the last two days any query I try to run
gives me the "Not Responding" error.  I have changed queries from complex to
simple but get the same error.  Your help is ...

Thanks in advance
What I have at present looks at cells A1 G2 & F3.
What i Need is to have a loop that looks at just a row, lets say row 4 ie
A4,B4, C4 all the way to the end. Not sure I how I refer it cells in a loop

In Excel '00, 1st file has macros,  when I open the 2nd file (and have both
files running) 2nd file wants to use the macro from the 1st. How do I stop
this...is it the link on the 2nd file that needs to be disconnected? I am
disabling the marco when opening the 1st file!

using rst.
how do i either display the current record number, or at least test if the
current record number is = 5

Hai ,
I would like to know if there is a way to move items in a listbox. the
list box has values populated from the data base.
I would like to know if there is some way i can move items up and down

I have copied form Internet a function that creates a toolbar on the fly.
However, when i use it i get the following error : Compile error : user
defined type not defined. Should i refer to some library ?
Here is the function :

Hi -
I want to use VB classes, modules, tables located in database (DB2) in
another database (DB1).
Earlier and MVP (Alex Dybenko) suggested that I add a reference from DB1 to

I am trying to link an Excel sheet as a table in Access through code, and I
stumble whatever I do on the database.TableDefs.Append <LinkedObject>
statement.
Situation is the following:

Private Sub cmdExpToExcel_Click()
'code behind command button "Export to Excel"
   Dim lngMax As Long
   Dim lngCount As Long

I am just curious about the upcoming version of access 2007 and I have a few
questions. Maybe somebody has already made some experiences with it:
1. Will Access finally support Splitters and panels to make forms
developement more flexible and the interface easier to handle for ...

Is there any possiblity to build the custom toolbar and the buttons on the
fly, through a code? We have to send out the database to different cities and
we will have to go specially  there to instal the toolbar.On the other hand,
if it is possible to do it  by code, it might save us ...