I am trying print a xtab report that has field headings that may change.  I
am reporting on staff members based on their employment 'active or non
active'.  The problem is that when someone is no longer active the report
crashes.  Any helpful tips or ideas on how to over come ...

When saving a 07 database to 02-03 the mdb NEVER compiles – Reference must be
rearranged to correct.  Is there something I am missing when I save it?

I am storing IP Addresses as a field in a table.  I would like to ping each
IP address and know which ones respond (and then use this response to update
another field in the table--which I know how to do).
Does anyone already have code which pings an IP address and interprets the

I am fairly new to VBA programming.
I have self-taught (with considerable help from this forum) all of the
things that I know about VBA.
I have just built and compiled a fully functional flight check-in program

I have access launching excel and then i want it to run a macro. i have the
macro saved as an add-in and if i load the file normally it opens up and
loads the addin (a menu bar and some macros). but when i load it from access
the addin does not load and i cannot find the macros. ...

tblDocuments
  Doc# (autonumber PK)
  DocName
  DocCreator

I'm having trouble getting a database to update.  its split into a front and
back end.  When data is entered in the table on the back end though, it never
updates on the front end until the database is closed and reopened.  even
when i query the table again by attaching it to the ...

Access03/WinXP
I have two recordsets - rs & rsCurrent - which have a one-to-many
relationship on CompanyID.  I am programming a process to update an export
table and need to loop through both tables in order to update specific field

I am trying to open a pdf file using application.followhyperlink.
I know the file and the pathname exist (tested) and I can open the file from
outside Access.  When I try to open from within Access, a window briefly
flashes open and closes.

Using Office 2003 and Windows XP;
In MS-Excel, I can use a function like the one below to assign a new color
to a certain position on the color palette:
ActiveWorkbook.Colors(52) = RGB(222, 202, 202)

I will be concatenating a number of invoice numbers into a comma delimited
string via code. The string may exceed 255 chars. Will it be truncated, or
is there anything I can do to exceed 255 chars?

What is the difference between the following declarations if I put them in
the Declaration section of the module?
Private intVariable as Integer
Dim intVariable as Integer

I would like to create a query that would update a table based on the data
entered in two text boxes.  The criteria for updating this table would be
based on a multiselect list box...  So basically the query reads as such:
UPDATE tblQualChecklist SET tblQualChecklist.Sequence =

I have a field on a form.
I need a code, that performs this operation:
-If the field is null, i can update it. If not, the access just allows
changes on the field with a password.

Just inherited a db.
Opened vba - references is "locked out".  I have not experienced this
before. Is there a permission that needs to be set to allow vba modules?
Thanks for the help.