You need to use the ServerFilter, even though when you apply a filter it sets the .Filter property of the form
Found this to do it, may need tweaking slightly for your use:
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
On Error GoTo Error_Handler
If ApplyType = 1...
Using Access 2000 with SQL Server 2000
I have an adp that has a continuous form that shows all of the records, a user can then right click on any of the fields and filter them accordingly to get the results they require, some of the fields have totals on them and the record count is shown at...
Sorted it, forgot to stick quotes around the variable that holds the @CREATE_DATE parameter, also found that identifying the type of variable being passed helps!!
.InputParameters = "@CREATE_DATE smalldatetime = '" & gstr_BT_Date & "', @SEARCH varchar = '" & gstr_BT_String &...
I have a From_Load event that sets the input parameters and recordsource for a subform.
If I only have the @SEARCH parameter (varchar(50)) in the stored procedure and only pass this parameter it works fine, however if I try to pass the @CREATE_DATE parameter(smalldatetime) I get the following...
I have found a way around this by converting the stored procedure that was picking up the default values to a view, then inserting the record into the table using a select from the view.
All works fine.
I have a stored procedure that looks up a record in a lookup table to find the last student id used, adds 1 to it, saves the record into this lookup table, then a new record is added to another table using this new student id.
This works fine, however I have another stored procedure to lookup...
I have read that you can only update one underlying tables data in a stored procedure.
I am Using an Access Form (in 2000 ADP) bound to a stored procedure but can only Edit data in table specified in UniqueTable property, does anybody know of a way to edit data in both tables using the same...
I am using an Access 2000 ADP that has a form that has its RecordSource as a stored procedure in SQL Server 7. The stored procedure is using 2 tables, does anybody know how I can edit the data in both the underlying tables (This worked fine when the RecordSource was a query in an Access 2000 MDB...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.