Dim CMD As ADODB.Command
Set CMD = Build_SP_Command("spfm_User_SalesLeadSearch_Dynamic")
Execute_SQL_GetRows_Command (CMD)
Set CMD = Nothing

is there a way for the database to display an error message when a
user violates a constraint?
an age limit for example?
tia,

Help!  What is wrong with my code? I have a listbox that is supposed
to allow the users to select several items in the list and click a
button and it will add those items (contacts) to their record.  But,
what is happening is that if i pick 3 different items, I get 3

If i have store procedure with parameters, can i use it as record souce
without the enter parameter value to be opened and the data will be taken
from the current form

Hi I am new to using Access Data Projects as have always used mdb in
the past.
Can someone tell me why the bound fields from SQL do not display the
selected format unless I set the control source to =cdbl([Field]). the

I have a report that I have translated from and MDB into an ADP which has a
couple of subreports that sit in a group header and footer.  It uses the Link
Child Field, Link Master Field features to filter the data displyed data
according to the Master record value.  This feature ...

I started using access 2003 adp with sql server 2005 because i can't use
tables with bigint.
When i have sql server tables and I try to enter as design view i got error:
the version of microsoft access doesn't support design changes with vhe

Hi,  what is the better way to open a Recordset and don't affect the memory
server. Actually I use recorset with cursorlocation = cliente and cursortype
=adOpenForwardOnly but my server memory goes up.
for your advice thanks.

I have access 2003 adp that connect to sql server
I add new table/view/store procedure on sql server and in order to see it on
access i must refresh adp manually.
Is there a way to refresh access by code?

Hello, I noticed you expllained to someone that she was in the wrong NG as
she needed help with Outlook Express.
I just opened a NG in my OE and I'm shocked that it's been downloaded into
my new NG over 100,000 NGs!!!  So please kindly help me with these

Hi - I posted tis in microsoft.public.access.formscoding a week back and Guy
who replied (thanks Guy), but did not spot any obvious errors, suggested
posting here. In the meantime I am opening the detail for as acDialogue which
gets round the problem but isn't as usefull to the ...

I have form which has OnError event to track errors on entering data to
table. (validation rules, primary key, ect...)
on mdb in order to know what is this error i used with msgbox
DBEingine.errors(DataErr) which isn't working on adp. where is the error

I have application on access 2003 adp.
To some subForm i have i bound access table in order to make it the
dinamicly way to work.
The table is sql server 2005.

i have access 2003 adp.
one of my store procedures that i run create new table.
I need in the code that runs the store procedure to refresh the list of
tables in the adp so i can use these tables afterword.

We normally purchase Dell PCs. New Dell PCs now only come with Office 2007,
without a downgrade option.
Now I can purchase a non OEM version of office, but it is twice the price.
So, I've got to ask - what issues will using Office 2007 cause? The backend