Search results

So do I. Both subs and functions can return multiple values when passed as byRef parameters (the default), but a function can also return a value - typically a boolean. For example can be used like this if somefunction(a,b,c)=true then debug.print a, b, c function somefunction(a as string, b...

I didn’t isay it was, just that is what the error implies. Why assume a report? OP has not provided relevant information as to where they are using this calc which will impact the solution It is also possible the use of $ in a field name, even with square brackets, could be the issue. I...

What about right clicking on the control?

This error implies the sum is in a query, you would just get #error if it was the controlsource to a control

I concur with @theDBguy - for testing only, provide your testers with copy of the FE and BE. At least you will get feedback on design, ease of use, your interpretation of the requirements, etc. Make sure part of the feedback is around performance requirements - moving to something like SQL Azure...

Other issues with excel - 1 million row limit and no indexing

The odd thing to me is no duplicate first names Why?

All slow methods relatively, plus Excel8? A 2 second Sleep? Slowing down after 500 odd reports? Might be due to poor coding, old vba version. hardware issues. Wouldn’t like to speculate beyond the addition of the sleep simply masks the issue

Ok - so how long is More than 10mins to produce 300 workboooks?

No need to open the query, transferspreadsheet does that anyway Not clear if the requirement is for 300 x 10 sheet workbooks or one workbook with 10 sheets x 300 rows. If the former my method would probably take around 10 minutes, the latter around 15 seconds

Perhaps use “01 Jan “ & me.currYr Not sure why you are using strings for dates or why you don’t just insert it rather than update after insert

I open an excel object, use copyfromrecordset, use excel automation to format the worksheet rows and columns and add functionality such as filtering. Repeats for 3 further worksheets then saves. Largest worksheet has around 5000 rows. Takes less than 10 seconds from pressing the button to...

Designer also uses square brackets even when not required and table names regardless even when they are only required when a field name appears in more than one table. I guess because the formatting routine works at a lower level for these

Agree not needed but if you wanted to you need a ) before the And

Try =subformname.form.controlname Change names to suit. You might find this link useful http://access.mvps.org/access/forms/frm0031.htm

It will however remove duplicates. Suggest use UNION ALL to prevent this

To get the right answer you need to be able to ask the right question and provide all the relevant parameters which could impact the answer. That requires training. When you develop an app in access/web/ whatever you are the AI - you need to ask questions of the client to clarify exactly what...

Apparently the minerals exist in Ukraine and to some extent in the area currently held by the Russian invasion. Not saying the minerals can be economically extracted. Seems to me trump wants a share (do these minerals exist in the USA? I don’t know) which he either gets by negotiating with...

So after 1-1 1/2 years of your neighbour moving the boundary line on to your plot you would do what?

Use a crosstab query? Or look at the concatrelated function http://allenbrowne.com/func-concat.html Be aware the function will only return 255 chars so if your dates are say 10 chars plus a comma you will be limited to 23 dates