Search results

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

Wow you're here! Thanks so much! I'll try this out asap and let you know if I have any issues. Thanks soooo much!

Thank you soooo much! I actually found a lead right here on this website. Going through the forums I saw a lead. Take a look: https://www.access-programmers.co.uk/forums/threads/check-ssh-tunnel-status-for-live-connection-in-vba.310194/#post-1677425

Have you ever gotten the answer?

Now that I think about it, I'm basically creating an online pharmacy. It's nothing new. But I need that functionality. Looking up "online pharmacies" on youtube and seeing advertisments of current pharmacies on how their website functions, @plog is right. I dont have to over complicate this. A...

I'm not good at web development. I am proficient in MS Access. Are you saying building a website in Wix or wordpress (for example) can solve my problem? I can build a secure patient portal that can manage 100,000 + users seemlessly?

Lets entertain the .accde FE file option. What all does that entail? How will I get that on patients mobile phones as an app? I'm almost certain this cannot happen or even if it is, advisable.

Hi there! So I built a pharmacy management software. Now I'm looking to offer patients the ability to view their medication list, request refills and update their demographics. All of this information is currently captured in my SQL Server tables. Naturally, I wanted to stay "in house" with...

Ok great! Ill limit the amount of forms opened and add close commands once new form is opened. Thank you so much for the concise answer!

So regardless if the form is already loaded, there still will be memory required to keep the form open? My question is: would the performance take a noticeable hit the more forms are opened? Should I now write code to close forms once I move on to the next form in sequence? Is this...

Good day all, How much of an impact on performance does opening multiple forms at once have on database application performance? Lets say 3 to 5 forms as opposed to 1 to 2 forms.

I would greatly appreciate that! I need it to communicate with databases like drugbank and the fda to get information in drug interactions and allergies based on the drugs ndc number.

you just let me know when and I'm there. Ill be happy to share what I've done.

I am very weak on Rest API and using it through access. Any good training on this anywhere? I really am glad someone is talking me out of it. I just couldn't find sources that did. If you'd like, I'd love to briefly show you what I have created though a video chat. I am sponge!

The BE is SQL server

I can dig it! Thanks for clearing that up. I want to be apart of a community because there is so much I don't know.

Again, the end users do not have access tothe tables. It is an accde file. There are no forms available for them to change those fields. As far as updating the software, you are involved in my other post with sharing the FE across a synced sharepoint folder. I got some good advice from other...

I'm confused. The conversation was based on a method I proposed and was hoping everyone can criticize it. I was open to everyone's opinion and thanked everyone. If they asked for further explanation, i took the time to do that. The person you're defending misinterpreted my comment to another...