Search results

Have you looked at the code behind the button, else look at it?

I think that is what you want, (look at the attached database).

You code is missing a lot reference back to the created Excel object. You need the reference to the Excel object in front of the following words, (because they are unknown for MS-Access) Sheets ActiveWorkbook Cells ActiveSheet xlPageField xlPageField xlColumnField xlRowField If you can't get...

Because the sub form is placed on the main form.

Do you have a field called "ComplianceCode" in the table "tblEmailAddress"? I ask because I can't find it and you use it in the below Where clause.

Can't you use a comma separated file instead? Why should it be from MS-Access to AS400, why not from AS400 to MS-Access?

And a &, (sorry that I haven't seen that in first post. Me.Filter = "CommitteeContact = '" & Me.CommitteeContact & "'"

You are missing a ' Me.Filter = "CommitteeContact = '" & Me.CommitteeContact "'"

Could it be so simple that you need the Recordset? Set Me.Recordset = rst.Recordset Else post your database with some sample data + name of the form. Zip the database because you haven't post 10 post yet.

Yes these two are the same, but it was not what you wrote, go back and read your post #2. You wrote that 11/12/2009 and 21/11/2009 refer to the same date!

Sorry - I do not agree.

No - I just tested it. :)

I think rpeare had the solution with the Filesystemobject. Looking at the output it looks perfect.

How do you delete it, do you save the file afterwards?

You can make a work around - close and open the form again by code, it is not perfect but it works. Dim TheFormName As String .. .. TheFormName = Me.Name DoCmd.Close acForm, TheFormName, acSaveNo DoCmd.OpenForm TheFormName

Sorry - No. Get use to it - the error message from Access isn't always clear, (mostly not, but you learn what it can cause the error when you stay long enough by MS-Access), by me it was a quiet another error message, more and less the below: "The OLE server may not be registered. "To register...

Sorry can't open your database, seems to be corrupt - hopeful others have more luck.

It works by me with the below code, new codeline added marked with red, (remember to change the blue codeline). Working database (by me) attached. Set grpApp = Nothing Set grpApp = Me.AdvancedGraph.Object grpApp.export "C:\Access programmer\TestJHB.jpg" Me.AdvancedGraph.Locked =...

Post your database with some sample data, zip it!

The database crash when I try to change the tab, (from Report Builder to Summary Charts). I'm using MS-Access 2010, which version do you use? Have you tried to download your database from here and open it and change the tab?