Search results for query: *

I'm using Access 2003 and Microsoft Graph Chart on a form. I want to be able to print the graph and the information on the form. The problem I'm having is that the Graph does not print any of the data points inside it. Here's the code I'm using: Private Sub Print_Form_Click() On Error GoTo...

I'm using Access 2003 I have a form named Plot that is from an older version of Access that I need to convert into a subform on the new application. I can convert everything successfully and I don't get any errors. However, when I make changes to the underlying objects and queries, I cannot...

Hi, I have a query that I use to export data to an excel file (Access 2003): DoCmd.TransferText acExportDelim, , "qryDelimited", strFile, True The numeric fields (doubles) return values such as "1.07989595" From the query. However, when I export this to a .csv and open it up in Excel, it...

I'm trying to activate the title on a chart, but I keep getting the run-time error "1004 Unable to set the hastitle property of Chart Class" Here's my code, not sure what I'm doing wrong. I'm using 2003: [Forms]![TabMenu]![Plot]![plotofdata].Requery...

Hi, I'm using Access 2003. I have a form (form1) that opens another form (form2) that contains a subform (form3). The vba code on form1 needs to set the record source for form 3. I know Access is finding the form because I hide some columns: For I = 1 To 11 Forms![form2]![form3]("Text" &...

I'm using access 2003. I'm trying to export the results of a query using DoCmd.TransferText acExportDelim. This works fine, but the csv file does not contain the column headers, which I need to have. I've tried setting the attribute hasfieldnames attribute to "Yes" to no avail. Is there an...

I'm using Access 2003. I have a query that holds site ids, chemicals and the chemical's BSAF: SiteID Chemical BSAF 1 Chem1 .0001 1 Chem2 .0002 I need to dynamically create a table based off this query that adds the chemical as a field so the table would end up being like...

I'm using Access 2003. I'm get the compile error "Method or Data Member Not Found" when trying to loop through some embedded sql. I've done this a million times before so I'm not sure why the error is happening in this case. Here's the sql statement: strSQL = "SELECT d.Rec_ID, d.[Site ID]...

I'm using Access 2003. Right now, a form holds a scatter graph made with MSGraph Chart 8. I need to add the form as a subform to another page. I've done this, but the problem is I cannot get the graph to refresh. I've searched the forms for ways to refresh a graph object and have looked...

Hi, I'm using MSAccess2003. I have a query that joins two tables together and is used as the record source of a subform. Access seems to not allow you to perform updates on these fields because the records are pulled from two different tables. For example, the Latin Name comes from the...

I have a query that populates a form on load: 'Populate Class List box Dim strSQL As String strSQL = "SELECT DISTINCT Class from tblChemClass ORDER BY Class" Form![UpdateChemClass]![UpdateChemClassSub]![lstClass].ColumnCount = 1...

Hi, I'm using Access 2003. I have a main form that has a dropdown box of site IDs. When a user selects a site ID, and event is triggered that sets the recordsource on a subform. This is a one to many relationship, so the subform can have multiple values. I have a hidden field that holds a...

Hi, I'm using Access 2003. There is a button that has an on click event that populates the following tables: tblProbabilityPlot tblProbabilityPlot_A tblProbabilityPlot_B Once these are populated it opens a form that graphs the information. This form uses OLE CLASS Microsoft Graph Chart and...

Hi, I'm lost! I have a subform within a form. The main form allows the user to select a site id. There are multiple records associated with each site ID. Each of these child records has a field named "MARINEorFRESHWATER" which is a list delimeted by a colon. The user needs to be able to...

Hi, I have a form that contains a listbox of Site IDs. I want to update Latin Names that have the selected Site ID from the list box. The OnClick event on the listbox creates a list of Latin Names. I would like to use this list to create a query that becomes the recordsource of a subform...

Hi, wanted to do a search to see if solution exists, but the search is down. Anyway, I have a field in a table name "MARINEorFRESHWATER". The field can be empty or contain a list separated by colons (i.e freshwater; brackish; marine). I'm trying to highlight the values in an option box based...

Hey, I can't figure this out for the life of me (it shouldn't be that difficult) I created a combo box where only one value can be selected. Its Row source is a value list containing the following choices: Unknown Marine Fresh Tidal The name of the combo box is ListClass. I have another...

Hi, I have a query that populates a list box: strSQL = "SELECT [tblSite-Type].[User Entered], [tblSite-Type].[Site ID], [tblSite-Type].[Superfund Site] " strSQL = strSQL & "FROM [tblSite-Type] " strSQL = strSQL & "ORDER BY [tblSite-Type].[Site ID], [tblSite-Type].[Superfund Site];"...

Hi, its been awhile since I used Access jet engine. I'm having a problem with the following query. I set it up how I normally do using other databases, but it returns zero results when I try to run it in access. I want to get the values from the temp table that do not exist in the site...

Hi, I know how to do a dcount on a table to get a record count and display that. However, I want to get a record count from a query and display that instead. Not sure what I'm doing wrong (always comes up blank): strSQL = "SELECT " strSQL = strSQL & "COUNT(tmp.Rec_ID) AS...