Search results

Is there a way to refer to a report as an object so that I can refer to a particular property of that report? For instance, I have a form and several buttons that call the same report (with different filtering). I would like to use the ServerFilter option to set a filter to be executed at the...

Hello, Is there a way to use the COUNT functions of SQL in an Access report? For instance, I can create a report which has it's record source set to a table in SQL Server. However, I would like to use the COUNT function and assign a text box (or boxes) the return value. I have not been able to...

Could someone shed light as to why the following occurs upon opening my Access project (SQL Server as the backend): Error received: "Module not found." If I try to save the project, but then I receive an error message that tells me it cannot find a report (which doesn't exist anymore). In...

I have an Access form that authenticates with SQL Server. The user would log in with a user/pass on startup. Is it then possible to change the connection login information as the Access form is running (it will be triggered) so that I can specify a new username and password? Would this mean...

Hello, I have a many-to-many relationship between two tables, which has a join table. Would it be possible to do the following: Take a user selected primary key from a list (or combo control) control (we'll call it key-A) from the first table, query the join table with key-A and find all...

Hi All, Does Refresh on a subform perform a Requery as well as part of the refresh command? Or does a requery need to be called seperate for a subform? Thanks, Nishant

If I just wanted to run a stored procedure (or query even) from within an Access Project, how would i go about doing that? Is the DoCmd.RunSQL method only used for Access databases? thanks, Nishant

Could someone shed some light as to why the following error occurs?: "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record." I am working with an Access Project (Access 2000) setting with a SQL server backend. This occurs in the...

Hello, Is it possible to assign a subform's current recordset to a listbox or combo box? For example, there is a main form that contains a combo or listbox. An item is selected, and then the corresponding subform is populated with those records associated to the item in the main form (simple...

Hello, Can anyone give me a quick rundown of using the recordset collection and how to access the fields and values within a collection (it seems MS Access Help just happens to not have any help related items for this topic because "it is no longer functioning properly")? I would hope to use...

Would it be possible to use a listbox within a subform that only populates itself with the data associated with that subform? For instance, FormA has a listbox from which all rows are populated into this listbox. Also, FormB (subform within FormA) has a ListBox as well. How can I populate the...