I am numbering fields in one table by comparing to its relational one to
many table's primary key.  The two fields used in the comparison are text,
on the last record of the comparison if I use "=" rather than "<>" in the
second part of the loop I get the runtime error "3021 no ...

I'm trying to write data in excel sheet and formatting cells
Below is the code snippet:
   Set objXL = CreateObject("Excel.Sheet")
   objXL.Application.Visible = True

I have never used VBA in Access, but I am an advid user of the tools
available within Access.  I have a new problem that I do not know how to deal
with and think VBA coding is the best solution to my problem.  I have over
980,000 records that I need to go through and compare two ...

I writing record set values into excel cell...
Snippet code:
       objXL.Application.Cells(rowcnt, 4).Value = rs!AddressLine1
       If Not IsNull(rs!AddressLine2) Then

I'm trying to use array in a message. Actually, it's a message through e-mail
but it should be the same as a msgbox.
....
' Creating the array of sheet names

A Procedure with the purpose of checking data import is as follows;
Sub CheckLoadData()
..    
DoCmd.RunMacro ("MRO_IMPORT_SRC_DATA")

I am trying to transfer information from an access database to an excel
spreadsheet.  The coding requires the Dim statement "Dim acsAccess as
Access.Application."  However, when I run the program I get an "Can't locate
project or library" error message.  I'm at a loss as to what ...

I have created a comma delimited file from MS Project using OLE DB connection
to Access. The problem that I am having is when I use the transfertext action
to create the Access table I get a couple of blank rows. I noticed in the
flat file that at the end of the file I have a ...

I am pretty proficient working with Access VBA but the following I have no
idea how to do, & I would think this is possible.
I would like to know if an Email is recieved & it has attachments to
programtically have the attachments downloaded.  Ideally also not just any

I am working with a database linked to a "backend" database which is also
accessed by other users. Is there any method of determining which of these
users is currently accessing the backend database. The lbd viewer
applications apparenetly don't work on linked databases. The only ...

Hi, I'm getting an error message "User-Defined Type Not Defined"
my code is as follows:
Function MergeIt()
  Dim objWord As Word.Document

Access 97
I have a form with a button that opens a report using a macro.  The macro
has a where condition to display the matching record.  When the report opens
I want to make a label control visible based on a text box (data field).  

I am attempting to use an Access app written for Access 2000 on an XP Pro
(SP2) machine with Access 2002 SP3.
Attempts to perform certain operations (primarily printing reports)
generates the message: "MS Access undefined function :left$: in expression.

I want to query the Top 100 scores; however, I want the
ties, too. For example, number 100 has a score of 7490. I
want to include the additional 5 records with a 7490
score. This would make the query return 105 records.

Is there a way to have a vb code that will autimatically set the focus on a
list box in column 0 and go to the first record that is blank (is null) and
select it? if so, could someone provide me an example of the code...