Search results for query: *

Thank you for your help I got it working with that!

So with the following Stored Procedure (I am only sending one parameter), I can get a count of the number of records which meet the criteria and return that number to the adp. In the adp I would basically say myvar = cmd(3) to retrieve the count I sent to the database? CREATE PROCEDURE...

Yes, I need the code to run the stored procedure and to receive the variable that comes back from the stored procedure. That would be great! Thanks!

What I am trying to do is allow a user to enter a order number into a form. When they click on Search the form will query the database and return a 1 if the order was placed and a 0 if the order was not placed. What is the easiest way of doing this? I have a stored procedure that will see if...

Yeah what I did was create a new database and imported things into it and it slowly began to work. Seems there is a problem with Access 2000 that MS knows about where if you import forms / reports, etc into a ADP sometimes it will give you a Network error message. Once you get that your done for...

Yes it is true for all of the forms and Reports. It will not let me access the code behind an upsized forms database.

Thats the thing it doesnt matter what the code is. If the field says Event Procedure it will not work.

I recently upsized an Access 2000 database to SQL server and created a ADP. I have a Form that opens up a report. The user selects criteria on the form and when they hit apply it puts a filter on the Report to only display the data they want/need. I do this by putting coding behind the OnClick...