Search results

Hi George, Thanks for still offering your opinion. Again though, this goes for anyone willing to answer, can you paint the picture of how exactly the hacker can get in? Theoretically, what are the weak points of an application as i described considering all security steps are taken?

@GPGeorge thank you so much for offering your advice. You've given me a lot to think about. This is indeed sensitive data that should have security at the forefront. I was insisting on illustrating scenarios where there would be a breach in confidentiality regardless of data being comingled...

:ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO::ROFLMAO:!! Tbh I find comfort in knowing no application is perfect. It gives me affirmation that I can get there and I'm allowed to make mistakes.

This is precisely why I value this forum. Your input is invaluable and I will do as suggested with taking some courses to get up to speed. After much introspect, I realized I'm not equipped to handle this venture on my own which is why I hired a developer with an existing team. He was kind...

How can I facilitate interoperability between these databases? Globally, there is a huge push towards interoperability between pharmacy management applications within a given jurisdiction. To date, the United States has difficulty achieving this despite government incentivized initiatives and...

I appreciate the concern. Forgive my ignorance but I don't see how data can potentially be released without access to it. Kindly educate me on the risk and what are my options on remedies?

I'm sticking with azure sql

The developer is using React JS. I have researched it and I am happy with the choice. I look forward to my application in the new year when my "team" will have something to show my customers.

Im not hosting the front end via sharepoint synced folder any longer. As @The_Doc_Man correctly predicted, I have experienced performance issues when the sync folder connection lapsed. However, it was not terrible, just embarrasing when it happened. I would also ensure that you are always...

your sarcasm is noted

I understand indexing will help performance of the query by helping access find the record quicker. Tbh I don't know what on earth I was thinking.

So I did it! Function QOHComp_Q() Dim db As Database Dim qd As QueryDef Dim qr As String On Error Resume Next Set db = CurrentDb On Error GoTo 0 CurrentDb.QueryDefs("PassThrough_Q").SQL = "SELECT " _ & "Concat(ChildDrug_T.GenericNameStrength_childdrug, ' ', Form_T.Abbreviation_form) As...

The only reason I'm not using the query built in access is due to performance. I am currently waiting 10-20 seconds for the form to open to display the results of which is unacceptable. You are spot on with the sql view route. I've created both subqueries in sql view and have joined them to...

Hi there CheekyBudda, 1. Yes I'm supposed to add a concatenated statement to show which staff member is responsible for the transaction. 2. Correct. Abbreviation_form is from table Form_Y. 3. I did not use the above statement as a pass-through query. I couldn't get the pass-through query to...

Not sure if I executed it correctly. I got nothing. But from what I see when then pass-through query is generated, if the stock out is null then it equals the stock in for some strange reason.

I mimicked what I retrieved in SQL view from the ms access query builder as much as possible. The tricky part are the subqueries StockIn_Q and StockOut_Q. Everything else on the form shows but this is where im getting my error.

The above works perfectly on the form. As for the SQL formatted query in VBA editor: I narrowed the error down to when the QOH is calculated. First, I had to replace the Nz function with IsNull.. i.e. IsNull([SumOfQuantity_goodsout],0) AS StockOut. I also isolated the [SumOfQuantity_goodsout]...

I'll take you up one that... Here's the query pulled from MS access query builder when you select "SQL View": SELECT OrderType_T.OrderType_description, [GenericNameStrength_childdrug] & " " & [Abbreviation_form] AS GenericNameStrengthForm, Manufacturer_T.CompanyName_manufacturer...

hey CJ_London.. thanks for the reply. heres an updated query where Im getting the same result: CurrentDb.QueryDefs("PassThrough_Q").SQL = "SELECT " _ & "Concat(ChildDrug_T.GenericNameStrength_childdrug, ' ', Form_T.Abbreviation_form) As DrugNameStrengthForm, " _ &...

Good day, I'm trying to calculate quantity on hand (QOH) for a drug that has 2 batch numbers. The query constructed in the Access query builder shows the correct information. However, when constructing the SQL statement for VBA, it shows the wrong values. Here is the query in SQL view from the...