Search results

They were dates. I set the formats for both unbound textboxes to Long Date. I cant explain it.

Hi there. My issue is that I have a field with a date/time format. It captures date and time. I have a form set up with 2 unbound fields: "FromDate" and "ToDate". My subform is bound to a query (see SQL query below). When I requery the subform, the dates never seem to work. Please take a look...

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]...