Search results

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

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

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.

Good day everyone, I was thinking of ways to license my front end. Yes I know there are third party solutions, but I think what I did works just as fine. So here's the deal: 1. I have 2 forms that remain open but hidden whilst access is open (i.e. Splash Screen and my Login Screen) 2. I then...

Good day everyone, I'm new to this forum. I wanted to talk about my current set up and your opinions. So I have a split database: access front end, sql back end I synced my sharepoint folder on each of my customers computer. I encrypted the folder so they dont have access to it. I then...