Recent content by RSfromCO

Thanks for the replies. It does appear that the Allow Edits property of the lowest level subform was somehow set to NO. Changing that to YES made it work. THANKS.

I have a main form which has a sub-form. That sub-form then has a sub-form of its own that contains check-boxes, buttons, and an unbound textbox. From the main form, I can click on the buttons, check-boxes, and the textbox and things appear to be functioning. However, when I place the cursor...

Using an Access project connected to a SQL Server database, I have a very simple ADODB Recordset (with a single record). I am trying to DELETE the single record. The code executes OK and does in fact delete the record, but I get a run-time error saying... "Row cannot be located for updating...

All I can say is WOW! Yes it makes sense. Thanks for sharing your expertise George!

Thanks for the response George. I do understand how your query works. I had tried something similar myself, but I was trying to use something like FIRST rather than MAX. After reviewing your suggestion, and making a quick adjustment its working great. I'm not sure the best way to get a...

gmmastros and Patricia, your suggestions work great and do exactly what I wanted. Now I need to try something similar but with a twist. Now if I add a 3rd table, a lookup table (LU_OrderTypes) that defines what OrderTypes there are.... OrderTypeID and Description fields. Something like...

I'm having a problem putting this concept into SQL. I'm hoping someone can help.... Let's say I have tables CUSTOMERS and ORDERS. CUSTOMERS is straight forward, 1 record for each customer info. ORDERS contains one record for each Order placed. ORDER records contain a CustomerID and an...

That's exactly what I wanted it to do. Duh! Thanks.

Does anyone know of a good way to impliment a shift-click or control-click method of selecting multiple items in a listbox instead of it just automatically selecting multiple items with a simple click. I would prefer that if a user clicks on one item and then clicks on another that it unselect...

I have a report with a sub-report. Sometimes I want the sub report to be SubReport_A, and sometimes I want the sub report to be SubReport_B. I want to set the source of the sub-report in code. Is there a way to set the source of a sub-report in VBA? I'm not trying to set the data source, but...

I have a MS-Access application which is used to access data stored on a SQL server. There are several people in the office that run the application. It is most convenient (for keeping everyone running the latest version of the application) to keep a single copy of the compiled application...

Thanks TheAceMan1. I didn't realize that a table.field had a property called RowSource. I thought that was just a form control property. Your example for the table was right on as no forms are involved here.

If a field in MS-Access, has a lookup defined which is a combo-box which uses a Value List... Is it possible to obtain the list of available choices for that field programatically? The list has to be stored somewhere... but I don't see anyway to access it. I thought maybe it could be accessed...

Well..... If I add the line... SET NOCOUNT ON to the stored procedure, it appears to now return a recordset... which is all I was trying to do in the first place. So now my question is, what does SET NOCOUNT ON do to the stored procedure that otherwise that line should not be there. FYI...

It says version 8 (which I think is 2000). Your example doesn't show the code for the stored procedure, but I would guess it has a line something to the effect... @RETURN_VALUE nvarchar(256) OUTPUT Which would define why you have access to a return value called @RETURN_VALUE The stored...