Search results for query: *

I found the problem. I was declaring the form as a variable, then setting it's property visible = true. It turns out that the bang method (Forms!frmX!txtId) cannot be used to reference a field UNLESS you open a form via the DoCmd.OpenForms method. Once I changed the form format, everything...

I solved the fields problem (my error) and the default problem (pass defaults to the database). I CANNOT get Access to see the form with the ID parameter, though. I used the string format provided above plus any additional combination I could think of. Access keeps prompting me for the ID, no...

I gave you a star for having me try harder. I am getting it to work (by passing defaults to the other parameters), although now I have another problem. The problem is I use the stored procedure in question in several procedures. In one procedure in particular, I load only particular fields in...

I have a form opening in the Report 'open' event to gather parameters (a date range, if desired and a status or group of statuses) and have not figured out a way to pass the values as parameters back to the sp. Filters do not work with stored procedures - only views and tables. I do not want...

The solution is not difficult - although I did not fully understand your example. Create a temporary table in SQL Server, dump the records you need into the table, then select the records from the temp table back to your report. Be sure to use 'SET NOCOUNT ON' in your stored procedure...

I am currently programming an application using Access 2003 ADP/SQL2K. I want to use a simple stored procedure to return records to a report. The only way I found to do this is to create an ADO (v2.7) recordset in the Open event of the report, then set the recordset property to the recordset I...