Search results for query: *

Figured it out, set the focus to the graph object before printing the form

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 tried the str function and that somewhat worked. It changed the data correctly. However, you have to alias it, and I cannot use the same name as the alias without getting a circular reference error. These have to be named the same because its a template used for other programs as well...

One thing that's kind of neat. I have just one query named "qrydelimited" that I created (doesn't matter what the fields in it are). There are a bunch of different reports that are based on different queries that all need an option to be exported. You can dynamically change this query using...

Thanks for your replies Will look into your feedback over the weekend.

Yes, you I think you can do it inline like: dim strSQL AS string strSQL = "SELECT fields FROM table" DoCmd.TransferText acExportDelim, , strSQL, strFile, True

Good idea. Still kind of new to vba. Like the input though and will look into it.

Whoops, have a global function called charcount that this function uses as well. You can put it above this function in your code if you want: Public Function CharCount(OrigString As String, _ Chars As String, Optional CaseSensitive As Boolean = False) _ As Long...

Here's the code I use to export to a CSV file. It allows the user to pick a location to save the file to. The reason I have the export to a csv versus excel file because fields over 255 characters (such as memo fields) get truncated when exporting to excel. However, if you want Excel, this...

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

For Some reason, it started working now (didn't make any changes). Not sure why, but its working

Thanks for the reply, I tried that, but get a 438 run-time error: Object doesn't support this property or method

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

Got it: Forms![form2]![form3].form.RecordSource = strSQL

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

Figured it out, was doing "Hasfieldnames = true" and changed to just "true" and it worked: DoCmd.TransferText acExportDelim, , "qryDelimited", "C:\Documents and Settings\jniesen\Desktop\bsaf\test.csv", True

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

Hi, thanks for the input, here's what I ended up doing and it works fine: Dim qryProbAll As String Dim qryProbSite As String Dim ProbChem As String Dim tblProbabilityPlot As Object Dim ColName As Object Dim db As Database Dim rs As DAO.Recordset Set db =...

Hi everyone, Will get back when I figure this out.