Search results

CurrentProject.Connection.Execute correct? I see how you can put SQL in there, but can you pass a stored procedure with parameters in there as well? 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...

James, Assuming you have relationships set between these tables, the form wizard can you help you again. So, if you have relationships set, access the form design wizard. You will then be asked to select the fields you want to display on your form. You can select items from tableA and then also...

James, I think this is what you are trying to do, but correct me if I'm wrong. You have a table that contains information about particular items. You are trying to achieve the following: Pull up information on an item based on a selection in a list box. If there is sufficient stock, then...

Here's an example: I'm running Access 2000 that is connected to a SQL Server backend (ver 8.x) that houses all tables. There is a one to many relationship between items on the main form and items on the sub form. It used to be the case in an MDB setting, you can specify form elements 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...

It may seem I need to bind the particular fields between the two listboxes. My dilemma involves setting the source for the listbox in the subform. If I give a static source, such as a table ,then the listbox only displays that information regardless of which row is selected in the main form's...

I do see that the forms are linked via the common identifier. However, when you say "have the master link field be your listbox", am I allowed to link the two listboxes just by putting their names in the respective master/child link fields? It seems I would need to bind the listboxes to some...

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...

Going one level further Would it then 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. How can I populate a ListBox in FormB (subform...

thank you! :)