Search results

Not as far as I know.

If your users find the screen ending up in a different postion to confusing then I don't see that they will have much to offer to troubleshooting. My users ask for all sort of stupid things and when I am feeling diplomatic I tell them that there requests are to advanced for me to implement...

Might help if you provided more information. What the formula actually is or prefereably an example spreadsheet?

=sumproduct((A1:A65536="Yes")*(B1:B65536=D9))

Maybe you should get in touch with the guy on this forum he seems to have a very similar problem to you just last month. http://www.accessforums.net/programming/convert-txt-file-5343.html This guy had a very similar problem to you in 2001 maybe he could help as well...

dim blah as collection set blah = new collection

From:http://www.webopedia.com/DidYouKnow/Internet/2002/web_vs_internet.asp

Yes, but the internet is not the same as the world wide web.

At least get my username right. I have no idea what not defining a date range has to do with a named range in excel. Named range are also an excellent way to find data in excel rather than using an absolute cell reference or relying on find functions. I assume you have already looked at...

I really hate it when people post the same question twice on the same board. Anyway to reiterate what I said on the excel board do you have a named range in your excel sheet which has the same name as your query?

Do you have a named range in excel called 'tblbatchdetails' as well?

from the way the post about the ban was written it seemed as though trumpet boy got banned for sarcasm in the watercooler, thats why I asked where it was. The ban he got seems fair enough, though might be better to make it permanent :p

Put application.screenupdating = false at the start of your code and application.screenupdating = true at then end

People are being banned for sarcasm in the watercooler now? or was it in the real parts of the forums?

That is a truly dreadful idea. Can you imagine how many wasted print outs that is going to produce? Printing before you even check the data and graphs is just crazy. You should really rethink this.

If we don't rely on transferspreadsheet and use copyfromrecordset instead this is easier, and for someone who doesn't know vba you've got the hang of it fast. Public Function ExportFiles() Dim rst As ADODB.Recordset Dim rst2 As ADODB.Recordset Set rst = New ADODB.Recordset...

Well nothing there is nothing you have mentioned that I would pay for. The only thing I can really think that I would be potentially interested are articles relating to useful Windows API functions and perhaps automating office apps using one of the .net languages, probably C# would be of...

I don't think you can use a sql statement in the transferspreadsheet method, I never use transferspreadsheet myself so I'm not 100% sure. Instead you actually have to create a query object in the db and use that. If your lucky someone else more familiar with this method will jump in with some...

That looks the right sort of thing. I'm guessing userID is a string and not a numeric value try: strquery = "Select * from tblcustomer where userid = '" & rst!USERID & "';" I've inserted apostrophes round your userid value