Is there a way to test if an object variable is set? I have a SET
statement in an For Each loop and would like to check if the object
variable is SET
    For Each node In tvTargetControl.Nodes

I've been presented with a database where, for reasons that prabably
appeared OK to the author (mebbe converted from non-MS Access???) , there is
one table per file. Rather than open, convert & save all 150 .mdb files, is
there a macro that will do it ?

I have a form that creates a sign based on the text you enter and resizes a
box and the text depending on which option you select.  I can recreate the
sign on another for using the variables selected stored in a table.  But is
it possible for the sign to be saved as a picture??

My db is currently secured with an MDW.  One of my tables tracks pricing per
department.  One of the MDW security groups I set up allows members to modify
all the records in that table.  Is there a way to take security one step
further by allowing users with the ability to modify ...

Don't know wheter this is a programming question or an SQL question, but here
goes:
I have a list of date data that I want to transform from this:
MyID   MyDate        MyValue

I have a dao.recordset which is made from a crosstab sql.
I want to know if a particular field name is one of the recordset's fields.
Is there a neat way of doing this without using onerror?
many thanks

i have a database that i updata daliy to other database. what i want to do is
change the data in second table
the data format is the following,
03/09/2005 11:30:16

I'm working with a database for a tabulation programs. I'm using a scanner
pen to ender barcoded numbers into the program and every time I scan someting
into the screen Visual basic comes up with an error and when I try to debug
and compile the same error comes up.  Does anyone ...

I am writing a system in Access 2003 for a non-profit: it is an Auction
system which will be conducted over the local radio station.
I am concerned with presenting the latest bid info using projectors: the
options I see are:

I am developing an Access DB that will reside on a networked PC that I want
to access from any PC connected to the network. I will have an access front
end connect to the backend db. I am developing this for a friends business
and he will have probably 8 or 10 PCs to connect all ...

I'm using addnew to append records to a table.  It steps across the fields
and works ok until it gets to a text field that is blank, then it gives the
message "invalid use of null" and quits.  I guess it is tying to to put Null
into the blank text field and bombs out.  what's ...

Does anyone have any experience capturing the latitude and longitude of
a location in an a DB? There is the possibility that I may have to
expand a DB of mine to capture the L/L of specific locations and curious
if there's anything special or helpful that I should be aware of.

What is the VBA code to set up a pivot on 2 columns of data from a Access
database as the standard pivot function does not provide the required result?

I have some apps created in Access97 VBA, converted to Access 2000, and now
they need to be moved to XP.   These databases are secured using Access
security.  
They worked great in 97-2000, but there is one feature that breaks in XP,

My computer is out and it the message it give me up above that have
writting,Thanks