Hi I am sure if this is the right category but I am using a access database
project with sql backend and recently I lost my control button wizard. Do you
know how to reactivate a control button wizard? It was very useful when
creating forms.

I am new to sqlServer and am doing an application front end using Access
2003 and the backend sqlServerExpress 2005.
When I run a very simple Stored Procedure on a table called 'MiscCharges'
such as;

I have a subreport that when I run it by itself it prints the correct
information.  
When I run the main report that has this sub report, I get the following
error.

I have isolated a strange problem having to do with a bookmark
I  have a standard  navigation routine that sets the command buttons on each
form.  This was originally developed for MDB’s and worked fine.  Since
converting to an ADP I am finding this strange problem.  Aren’t they ...

I quote another user on this forum, as I have not seen this as an own question.
"I have another problem with access 2003 with sp3 adp poject. If you
have a table with a bit column and default value 0 before sp3 access
insert correctly false, after sp3 access insert true. This is ...

I tested the sub report with the Stored procedure and it works.  As soon as I
run the main report I get the following error: "Incorrect Syntax near the
keyword 'Exec'  With in the subreport Recordsource I have the following text
exec [GetRepGroups]. Any ideas on what I need to do?

I have an acess data project that I want to convert to 2007, from the looks
of the blogs I am in deep weeds! I built it as a data project so I have no
MDB file. I can open it in Access 2007 but I can not save it or convert it.
What gives with this ADP Death I have been reading ...

RePost for Non HTML users...
I have an .adp that was built in 2007 and converted down to 2000.
We have many workstations that have either 2000, 2003 or 2007.
We made some backend SQL Server changes and moved the db

After building a project (citrus.adp) in Access 2000, I just started using
Access 2007.  I noticed that I can't save my citrus.adp as a 2007 database.  
I can only save it as a 2000 or 2003 database.  Why can't I save it as 2007?  
Thanks.

I am currently experimenting with upsizing a front end/back end Access 2000
database (via the upsizing Wizard) and have found that keeping the front end
an mdb with the back end converted to SQL Server 2000 results in
excruciatingly SLOW execution speeds for the queries. As I ...

I am trying to move the focus from a subform (Continuous form) to a
control on the parent form.
I have tried the following on the Exit event of the last control in my
subform, but they don't work, if you can help that would be great

In an ADP form that is calling a stored procedure with the parameter
string defined in VBA and the results displayed in a sub form. When
searching by name it works correctly, however when searching by a date
it displays the following error message.

Is it possible to copy database diagrams from one database to another in sql
server 2000?
How ?

I want to prevent entry into a field in Access, using home/student 2007
version.  Field name FromDate and field name ThruDate.  If i plug in the
validation text [ThruDate]>=[FromDate] i get an error message "Invalid SQL
-cannot use multiple columns in a column level CHECK ...

Bonjour à tous,
J'utilise actuellement la commande DoCmd.OpenReport comme suit :
DoCmd.OpenReport NomDeLEtat, acViewPreview, "Rq_Etat", "NumAppel =
'LeNumAppel'"