I have a listbox that the user is able to add items to through and SQL
statement that is run on the NotInList event.  At the end of the event,
I set Response = acDataErrAdded, telling access that the NewData
variable has been added to the underlying table.  The recoord gets

One of those seemingly basic questions that I can't find the answer to:
I have a field "Action" with three lookup values: "Do_It",
"Delegate_It", and "Defer_It."  When the user chooses "Do_It," I want
him to be able to choose from a second list of lookup values.

Why can't I do this in the report activate section of my main report?
I have a main report, and a subreport on it. The idea is that if the
subreport has a certain value in a control within it, I want to hide
the subreport. I get an error(runtime 2101 the setting you entered

context: vb6/ ado / .mdb format / jet 4.0 (not using Access - ADO only)
- creating tables via ADO (don't have access)
- all tables have a primary key (PK)
- many of the PK will become FK(Foreign Key) in other table(s)

I often want to query the database with certain parameters in my query
which I do not want included in the query result.
The problem is when I want to group on 1, sum the 2nd (and group by)
and use a parameter on the 3rd (but don't want to group by it). For

Dear reader,
First of all a happy new year.
In Report event there is the "On No Date" event but in a Form this event is
not available.

Does anyone have a book to recommend for programming in ACCESS. I want
to find a book which is for enter level VBA programmer, but not Dummy
one. I hope the book is focusing on syntax of VBA, and better any
example of applying VBA in ACCESS. Thank you very much!

hi guys, i have a project on my hand and what i'm told to do is to
create a log-in feature using tables and forms.
Da question is that is there any way to allow different users different
access to enter into the forms or even to prevent some users from

I'm trying to determine if there is a way in VBScript, perhaps via ADO
or DAO, to access what I'll term MS Access "object groups".  What I
mean by "object groups" are the folders that you see under the "Groups"
pane on the left hand side of the Access 2003 application, just below

I hope not, but, I think the answer to this question is "it can't be done".
Northwind sample database. Orders form.
Go to a new record.
Select a customer in "Bill To:"

In sheet view (like a query), is the a way to add color to specific
columns (like some red and some green?) or cells?  Not in a form, but
in a sheet view?  So say I had a query and I wanted to perform some
conditional formatting (say format all the blanks cells red so the

I've got two queries; one is a modification of an older query; the
other I created from scratch.
The old one is about 5 copies down the road from something that has
been expandable when I'm in View mode--it showed the Points of Contact

I got some code from http://www.fabalou.com/VBandVBA/lotusnotesmail.asp to
send emails atomatically from access. It works but does not attach anything
to the email
I am trying to email the report "RP_NC Form" when I clic a button.. What s

I am making an app which has to work on a number of DB systems. This
requires simple SQL which will work almost everywhere.
Something like this does not work in MS access
select b.name,a.code,count(a.code) as x

Hi Access Gurus
The MS Access DB (MS Access 2002 Database) which is currently serving
as the backend Database to MS Access (MS Access 2002/XP) frontend needs
to be converted to Oracle 8i Backend (With the frontend still being MS