Minty's latest activity
-
Minty replied to the thread Query results horizontally for single line export to Excel.You won't easily get that result layout into an Access query. It's probably easier to Pivot/Transpose it in Excel, if you fancied a bit... -
Minty replied to the thread Query Criteria with If-Then to return all records.Just to revisit this, although @arnelgp solution is an elegant one - you needed to put the criteria in exactly as I described, the other...
-
Thanks Minty, I seem to remember now that he did something like this. Headed there now....
-
Minty replied to the thread Search is down.@Jon yup defo gone all wonky again. 13.44 UK time
-
Minty replied to the thread Combo Box woes.Have a look at @isladogs postcode app thingy. It has a similar number of records and reduces it down to a few combo's - not sure of the...
-
Minty replied to the thread Emailing Multiple Invoices As Attachments To Different Email Addresses.The really simple way would need to pull in the other reports at the same time but ensure they had a different file name and a different...
-
Minty reacted to bastanu's post in the thread Solved Adding files using ADODB.Stream to SQL BLOB - varbinary(max) doesn't work - same code used to work OK for both SQL and Oracle BEs with
Like.
Hi guys, I ended up changing it to use AppendChunk (DAO) and it works. Funny thing is the retrieval of the file is still using the ADODB... -
Minty replied to the thread Query Criteria with If-Then to return all records.It isn't confusing - the logic of the solution is possibly confusing you. In your query (as a test) put criteria in the contractor ID...
-
Minty replied to the thread Solved Using recordset match to set TempVars.If you brought the division in with the employee detail in the login form in the combo (hidden if necessary) it would be readily...
-
Minty replied to the thread Query Criteria with If-Then to return all records.Ah - okay frequently someone uses a union query to generate the All in a combo, so it's easier to accommodate. I've not tried this but...
-
Minty replied to the thread Query Criteria with If-Then to return all records.If you remove the All or make the ID it returns null then you simply need [Forms]![Report Form]![ContractorIDX] or [Forms]![Report...
-
Minty replied to the thread Delay in MS Access Response.Make sure that your O365 is also bang up to date, and you don't have any pending or failed updates.
-
Minty replied to the thread Solved Adding files using ADODB.Stream to SQL BLOB - varbinary(max) doesn't work - same code used to work OK for both SQL and Oracle BEs.Hi Vlad, we have switched over to ODBC Driver 17, for nearly all our projects as it seems much more robust. I have an image upload...
-
HELL EXPLAINED BY CHEMISTRY STUDENT The following is an actual question given on University of Washington chemistry mid term. The...
-
An elderly man living alone in Manchester wanted to plant his annual tomato garden, but it was very difficult work, since the ground was...