Can anyone please give me a hand solving a problem with the following
code.
When I run it I receive error 2467 'Application- defined or object
defined-error'

I've looked through many forums and still indecisive of what to choose
for my database.  Can anyone give me a full account (advantages and
disadvantages, where/when should use) about these two?
Very much appreciated,

Hi, i'm using Access2003. I have created db1 that is password
protected and db2 which is a copy of db1 that is read-only and
available to all. I would like the db2 copy to be updated with the
information  from db1 every time a user exits from db1 (and remain

I had posted a few days ago regarding the lpad and rpad and thanks to
help i got I was able to format my data.On the same lines I need help
in formatting negative values.I am able to identify these negative
values and I want to format them.They have to be formatted as follows;

In my form, I am trying to set up a field so that its default is the
max of that field + 1.  I have gone to my form, design view and
clicked on the data tab.  From there I clicked on the elipses next to
default value and built an expression.  Here is what the expression

My company has a database which I need to read from my database now
and again. This db can only be read via a dll written in C#. I need to
read data from this database and popule a table in my own database
which is programmed via MsAccess.

I am having a table looking like this:
-------------------------------------
PersID | Name | RoomID |
-------------------------------------

I'm working on a database that someone else created. I have a form -
frm_main that is based on a query that is based on two tables. The
join is such that the first table tbl_JCN has all records included in
the query, but the second table tbl_SOC only has matching records

Hi Does anybody know where I'm going wrong here in these lines? Access
is asking for the parameters not getting them automatically.
strSQLText = "DELETE * FROM [UsersColumnPreferences] where EMPID =
Employee and FormName = strFormname;"

Any suggestions, knowledge base articles, books?  We are not going to
go field level but now we have a couple clients that would like to
limit what employees can see of our application (forms and reports). I
guess we would need to create a database containing user names and

I've been developing in Microsoft Access since the 2.0 days.  Now I
have started using Access 2007 and needless to say I am less than
thrilled with the interface.  Everything is in a totally different
location and difficult to find.  I'm working through it and I'm sure

Allâh, Exalted is He says, "You who have faith! Have taqwâ of Allâh
and be with the truthful"; "...being true to Allâh would be better
for
them"; "... men and women who are truthful...Allâh has prepared for

Hello, I am heather and I am new to the area and do not know anyone.
I am looking to hookup for some drinks and then fun after that.  Are
you up for some fun?  I uploaded some pictures for you to see me.
Take a look and let me know if this will work then we can chat online.

I want to share knowledes about database. If any one interest with a
friendship movement, please contact me.

Hi, I am running Access2002.
I have to support a legacy Access database that has a linked table to
a .prn file
On one machine a vba routine can open and manipute the linked table.