Search results

Thanks KitaYama, much appreciated for the guidance. Thanks everyone for helping me to resolve this issue

I have not used this before. Do you by any chance have an example you can direct me to?

Yes, I do have the password. Apologies about the code - I have not posted code before. Thank for advising how to do it. I forgot to credit the original author for this code: Ron de Bruin (https://www.experts-exchange.com/questions/25135521/Can-VBA-open-a-Password-Protected-Zip-Folder.html)

Apologies! The file in question is the zipped file. If I run the function, and the zipped file is not password protected, the contents are extracted. However, if password protected, it 'ignores' the file, i.e., nothing extracted. If I try to open the zipped file in the normal way, i.e., not...

Hi, hope someone can help! The below code unzips a non-password protected file perfectly. However not for a password protected file. I have struggled to find a solution using the famous search engine. Can anyone help, or at least aid with an alternative vba? Thanks Function Unzip1(ZippedFile...

Thanks very much! Works exactly as I needed it to.

I am trying to determine the first time a company [Company_ID] placed an order [Order_Date]. I have tried different ways and they are clumsy and do not give the correct result. It somehow seems that there should be an easy way to do this but I cannot figure this out (not being an expert...

Thanks plog and XPS35. I had not considered these points and so I will go back to the drawing table having been given a alternative way to do this. Much appreciated

The count is accurate, i.e., zero. Essentially my client selects a date range (not shown in the Select above), which may result in a positive Count, but if no Tests were done for that date range, will result in a Count of zero. But the problem is that it does not give a result of "0", but a...

Thanks for your input. I should have made the point that there are 3 other Select statements for 3 other Tests which are joined by a Union All Statement allowing the graph to show the Counts for each Test by Interval. So the statement above may be zero while the 3 others generate values

Hi, wonder if someone can advise? I have the following query which allows me to create a graph. It results in the following results: Test, Interval and Count. However if the count value is nothing, then no Interval is generated and then no data is generated and the graph generates an error...

Thanks all for your input, and in particular to plog who reminded me to keep it simple. Tried your approach and got it working perfectly! Thanks so much, your help has been tremendous and is greatly appreciated.

Thanks for your guidance, much appreciated. I have created two queries and tried to link them, but not working. I assume my syntax is at fault? Could you please assist? Joined query: TRANSFORM Count SELECT qryUnionELISA.Test, qryUnionELISA.Interval, qryUnionELISA.Count FROM qryUnionELISA UNION...

Thanks for your input! So are you suggesting that I save one query as say, qry1, the second as qry2, and then create a pivot query incorporating qry1 and qry2? (I am not an advanced programmer so not sure exactly what to do)

Hi, hope someone may be able to advise! I am trying to join two queries into a pivot table This pivot on one query works: TRANSFORM Count(SampleTestedFor.TestedFor) AS TestedFor SELECT IIf([SampleTestedFor].[Packed]=8,'','LCMS') AS TestGroup FROM ((Samples_List INNER JOIN SampleTestedFor ON...

Thank you! This links through to the following url: https://bytes.com/topic/access/insights/873647-invoking-database-command-line The last post includes a zipped Access example. Essentially the author suggests linking a variable to the end of the command line, which when the database opens...

Thanks all for contributing to the discussion. Sonic8 - your contribution recommending Hyperlinking or Deep Linking in Microsoft Access should have been very helpful but unfortunately the link the video supplied was to a site where the article was no longer available, and an email to the owner...

Thanks for both your responses. I did consider that the outgoing message may be confusing, but considered possibly 'hiding' the link by making the text white, or linking to a nondescript image. I will see if the video has any guidance.

Hi all, Is it possible to have a link in my returned email message that when clicked, will open my Access database and open a specific form with the linked record ID? Thanks

Thank you both for your input. I was not aware of SharePoint REST. Very foreign to me, and appears to be outside my level of understanding as an average programmer, but will explore further and see if I can learn enough to get this working!