Search results for query: *

I have a master form with a child subform setup. This is a one to many relationship. I want to ensure all fields are being filled into each subform record before new records are added. I would like to accomplish this without requiring the fields to be entered in the table properties. I have...

I have my main form (frmORC), a subform within the main form (fsubDatasheet), and a subform within fsubDatasheet (fsubTestShot). I am getting Error 2455 (You entered an expression that has an invalid reference to the property Form/Report) on the following line of code...

I have two tables (tblORC and tblTestShot). tblORC has the following fields: [ID],[Date/Time],[Item Number],[Discrete Job] and a lot more that aren't important. tblTestShot has the following fields: [ID],[Test Shot ID],[Test Shot Number] and some more fields about that "test shot". I have a...

I use a form to create a pivotchart much like how it is explained in the Microsoft help file: http://support.microsoft.com/?kbid=304143 I created a blank pivotchart form "frmGraph" that I manipulate with OWC10 coding. "frmGraph" has no fields or recordsource. I define these properties in my...

I'm trying to write a function that I can use across multiple forms (which are the same format) to analyze some data. I have successfully built the recordset but now I'm not sure if I can use it without providing specific field names in the recordset. Here's the part of the function I am...

I have a form with a bunch of combo boxes and a datasheet subform. When the form is loaded the subform displays all the records from a specific table. The user may then use the combo boxes to set any number of conditions that will filter the data in the subform and display records based on...

I'm trying to set the Source Object of a Subreport programmatically. I've created the subreport named "fsubIndividualChart" and for some reason Me.fsubIndividualChart.SourceObject = strIndChrtSource does not work (strIndChrtSource is a string expression). I get the error 3011: MS Jet...

I've created a form that displays two Pivotcharts at a time. I want to create a command button that exports the data in both charts to the same Excel file in separate worksheets. So far I've come up with the following code: Dim objExcelApp As Excel.Application Set objExcelApp =...

I'm trying to write code that will conditionally format individual data points in a Pivotchart form. I am getting the error "Error 13: Type Mismatch" for the following line of code: Set objChartSpace = Me.Form.ChartSpace I used the following support page as a guide...

I'm trying to figure out how to include symbols, specifically the Greek Character lower case sigma, in strings for use in objects like message boxes and screentips. Is this possible? If I can simply use the Chr() function, then does someone have a link that lists all the character numbers...

First I will explain my ultimate goal just in case someone has done something like this before. I have a PivotChart that acts as a SPC Control Chart. This Control Charts displays the pH reading values of each record in the database. When pH readings are "Out of Control," certain text box...

I have created a form that allows a user to edit a table, but not until they login with a username and password. Otherwise, the table cannot be edited, and is just used as a reference. I wanted to set up a routine so that after a specified amount of time, the form will automatically log the...

I am using the following code to open Outlook when a form is opened in Access. It works fine, but I'd like to minimize the window so the user doesn't have it in the way. I want Outlook to be open while the user is entering data into each form so that e-mails are sent on a consistent basis...

I wrote up a generic error handler that I want to use to handle all errors in each sub routine of my form. For some reason it never gives me an error description. I've also tried the "Error$" instead of "Err.Description" but have no luck. Any help would be greatly appreciated. Here's the...

I have a weird problem with sending e-mails in Access using VBA which differs from computer to computer. On the user's computer, Microsoft Outlook is not open. When entering data into the Access Forms, sometimes an event is triggered which sends out an E-mail. On some of the computers, this...

I'm having trouble using the BOF function in a DO LOOP. [DirectPlate-BathChgCleaner] is a checkbox. I'm trying to loop through the recordset in order to determine the [DirectPlate-TotalSurfaceSqFt] value when the [DirectPlate-BathChgCleaner] checkbox is True. This works fine except for when...

The form I am working with writes to a Table named "Silver Production Log.” I’ve written some code that also writes the field values to another table, “Silver PM Log”, when the user clicks an “Add Record” command button I created. This all works fine. I allow my users to go between the most...

I have a form with a Tab Control with multiple pages. On each page is a different form. The main form takes time to load and uses many resources b/c of the number of forms opened. When the form opens on the first page, I want all the SourceObject properties of each form on the other pages to...

SELECT DISTINCTROW [RRCC2 Production Log].[RRCC2-Date/Time], [RRCC2 Production Log].[Part Number], [RRCC2 Production Log].[Discrete Job], [RRCC2 Production Log].[RRCC2-Operator], [RRCC2 PM Log].[RRCC2-Etch Rate] FROM [RRCC2 PM Log] INNER JOIN [RRCC2 Production Log] ON [RRCC2 PM Log].[Discrete...

I recently split my database into three separate databases for various reasons. I'm trying to create one "Control Panel" form with command buttons that open each form from the different databases. I know about the DoCmd.OpenForm coding but from what I've read it only opens forms in the current...