Search results for query: *

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

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

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

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

I am having a problem retrieving a record from a stored procedure. I am new to this, and have had success retrieving an output parameter, but now I want to retrieve an entire record. The procedure I am trying to use is defined as... ALTER PROCEDURE dbo.aspnet_Membership_GetUserByUserId...

I have a table that currently has 29 rows. I have a report that is trying to list the contents of the table in two columns. I want them to come out with equal number of rows in each, with the first column having one more item if there are an odd number of items. I am trying to develop a...

I have a form with a bunch of rows and columns of checkboxes. I would like to name and position the checkboxes with a set of code rather than setting the properties of each checkbox using the form editor. Can someone give me an example of how to properly open the form in design mode and...

I would like to generate a SQL script using my current table format, which when executed would drop the table, re-build it using the updated structure, and then reload the table with data that was already in the table (assuming that the new structure still contains all of the old fields). Is...

I create a stored procedure which included the code --Mark procedure as system object EXEC sp_MS_marksystemobject sp_generate_inserts GO PRINT 'Granting EXECUTE permission on sp_generate_inserts to all users' GRANT EXEC ON sp_generate_inserts TO public Now I want to modify or delete the...

I have a report (REPORT_A) that contains several sub-reports. They all can't fit onto one page, so I added a page-break control so the report always prints on 2 pages and always breaks the pages between the two sub-reports I want it to. Looks great! NOW... I add this report (REPORT_A) into...

I have defined several custom classes that are similar. I have a sub-report that needs to be passed one of these custom objects and then know which type of object it is dealing with. I wanted to do something like: Dim genericObject As Object Set genericObject =...

I have a sub-report that is used in 3 different main reports. ParentReport1 contains SubReport1 ParentReport2 contains SubReport1 ParentReport3 contains SubReport1 I want SubReport1 to know which of the main reports are currently open. How can I tell if a report is open via code? Something...

I want to create a report that contains 3 or more sub-reports. I want a layout on the page like this... RPT1XXXX RPT2XX XXXXXXXX XXXXXX XXXXXXXX XXXXXX XXXXXXXX XXXXXXXX XXXXXXXX RPT3XX XXXXXXXX XXXXXX XXXXXXXX XXXXXX I know RPT1 is much longer than RPT2 and RPT3. (in...

I have a custom object A_Object, that contains a Vba.Collection of another custom object B_Object. If I am trying to display a list of information from the collection of B_Objects, I can just step through the collection, such as... Dim obj As B_Object For Each obj In A_Object.B_Objects 'do...

I have a Main form(1), which has a Sub-form(2), which has a Sub-form(3). When I press a button on the Main Form (1), I want the code for that button to get a value from a checkbox control on Sub-Form(3). Is this possible? Something like .... theCheckboxValue = Me.Subform1.Subform2.chkBox1

Is it possible to change the Window color of a form, other than changing the Windows theme being used? I'm not talking about the background color, but the outline of the window (which is usually blue).

I noticed that if I define a custom object that contains an integer and a double value, when the object is instantiated both of these values are set to 0 (rather than null). So when I populate a textbox on the form with these data items they display 0 rather than being blank. The problem is...