Recent content by cheekybuddha

TinyInt has a max value of 255 - so useless in a table of 108000 records! Beware also, sometimes you can not join between fields of different datatypes (perhaps this is an Access limitation - I'm not 100% sure) I think any savings will be negligible

Ah, I missed the tests - thank you @Gasman and @arnel for showing the benefit of SELECT 1 (y)

This is counter-intuitive (I'm not saying it is not true!) The * here does not require the db engine to enumerate any fields - this seems like an AI mis-understanding. It is not the same as SELECT * ... Using * generally allows the COUNT() query to use the table metadata statistics for record...

Out of curiosity, which datatypes are you converting from/to ?

I used to do similar dynamic html in the old version of the webbrowser control by first navigating to about:blank, and then writing to the DOM document of the loaded empty page. So, no need for external html file and not relying on js to create the initial document. Perhaps this technique...

Use a form for display. You can set the form's recordset to your parameterised qdf rst

Oops! Didn't see that they can connect via ssms, so the drivers must be installed. You are using trusted connection. Are all the other users set up to be able to access the server?

The odbc driver must be installed on each client machine. Is that the case?

The problem with the /cmd switch for this situation is that is does not work if the target accdb is already running. One possibility is that you can have a db specifically waiting for the /cmd that opens, connects to the user frontends, performs the required actions and then shuts down again to...

Frank, didn't you go through all this already a few years ago back on UA? Why fire 42 queries when you are fetching identical data in six time periods? You can do the same with a maximum of 7 queries and probably fewer. If you want help sorting out speeding this up you should provide the...

I'm just curious why you need to rely on the data from the subform. Is it not already contained in the treeview? Certainly you ought to be able to get the number of clicked node's children directly, without having to perform an extra dlookup() And aren't the id's required already stored...

No he did not say to use ampersand

This is Arnel's query (using Allen Browne's ConcatRelated() ): TRANSFORM First( ConcatRelated( "TestedFor", "Table1", "DateReportDue=#" & Format([DateReportDue],"m/d/yyyy") & "# And Sample_ID = '" & [Sample_ID] & "'", "TestedFor", Chr(13) & Chr(10) ) ) AS TFor SELECT...

You will also need a group concatenation function for the output you show. @theDBguy can point you towards an example on his website.

I'm not sure my logic is correct! WE need to hear from @mloucel for clarification of what is required.