51
User Offerings / Re: Tablets Database
Last post by billhsln - January 16, 2024, 03:20:05 PM14 prescribed (1 of those is when needed) and 3 over the counter.
My pharmacy also lets me know when I need to renew. Of course, every once in a while, I forget to either take my morning pills or evening, so that throws off my numbers. I do one of those tablet holders that does an entire week at once with morning and evening spots.
My pharmacy lets me know how much the drugs cost and what I paid for them, so I wrote a program to track their price and what I paid, but not near as polished as Brian's program.
But I am doing ok and still using IWB daily. I do lots of ODBC connection into an AS400 using SQL which is sitting at my work over 87 miles from where I live.
Bill
My pharmacy also lets me know when I need to renew. Of course, every once in a while, I forget to either take my morning pills or evening, so that throws off my numbers. I do one of those tablet holders that does an entire week at once with morning and evening spots.
My pharmacy lets me know how much the drugs cost and what I paid for them, so I wrote a program to track their price and what I paid, but not near as polished as Brian's program.
But I am doing ok and still using IWB daily. I do lots of ODBC connection into an AS400 using SQL which is sitting at my work over 87 miles from where I live.
Bill
52
User Offerings / Re: Tablets Database
Last post by Brian - January 16, 2024, 06:31:46 AMLarry,
I was being a bit conservative when I said 2 or 3 - I didn't want Forum members to think I was a pill junky! Actually, I have 7 or 8 different ones to take. I have no problem remembering what and when to take, this just helps me to remember when to re-order. And it seems to be working well, and was nice to program something practical for once
And I had a feeling you might might be taking more than me!
Brian
I was being a bit conservative when I said 2 or 3 - I didn't want Forum members to think I was a pill junky! Actually, I have 7 or 8 different ones to take. I have no problem remembering what and when to take, this just helps me to remember when to re-order. And it seems to be working well, and was nice to program something practical for once
And I had a feeling you might might be taking more than me!
Brian
53
User Offerings / Re: Tablets Database
Last post by LarryMc - January 16, 2024, 06:23:09 AMQuote from: Brian on January 13, 2024, 11:20:28 AMI have two or three prescriptionsYou wrote a program to keep track of 2 or 3? LOL
Then I need an accounting firm to keep track of my 18 0r 19!!! LOL
In reality, the pharmacy is quick to call me when it is time for a refill because if I miss one , with all my meds, they will have to lay someone off.
LarryMc
54
User Offerings / Re: Tablets Database
Last post by Brian - January 15, 2024, 10:48:23 AMHello,
Because you never know how a program really works until you start using it in earnest, I found some changes I had to do. I was trying to enter a Dosage value of 2.5, and as I had set the edit control to numbers only, it wouldn't take the value
So the Dosage edit control is now sub-classed to accept numbers and a full stop only (plus backspace)
All the listview columns are now sortable
There is a check on startup to make sure the \backup folder is really there, and creates one if not
The database now starts with an ORDER BY clause on the Reorder column, so it shows the first to renew at the top of the list
Put a static control on the screen to show how many days were allocated before a renewal date shows in red
Think that's it, but you will have to delete your Tablets.mdb and generate a new one, as the format for the database is now different
Included the source file and a compiled exe
Brian
Because you never know how a program really works until you start using it in earnest, I found some changes I had to do. I was trying to enter a Dosage value of 2.5, and as I had set the edit control to numbers only, it wouldn't take the value
So the Dosage edit control is now sub-classed to accept numbers and a full stop only (plus backspace)
All the listview columns are now sortable
There is a check on startup to make sure the \backup folder is really there, and creates one if not
The database now starts with an ORDER BY clause on the Reorder column, so it shows the first to renew at the top of the list
Put a static control on the screen to show how many days were allocated before a renewal date shows in red
Think that's it, but you will have to delete your Tablets.mdb and generate a new one, as the format for the database is now different
Included the source file and a compiled exe
Brian
55
User Offerings / Tablets Database
Last post by Brian - January 13, 2024, 11:20:28 AMHi,
I have two or three prescriptions, and they all run out on different dates, and need renewing at different times. This program is to help me keep track of when to re-order
I've been working on this program on and off for quite a few days, and with Bill H's valuable help have overcome some of the trickier SQL problems
Full source code included, with exe. It is a Project. To start your own database, rather than the test data, just delete 'Tablets.mdb' from the \data folder, and run the program again, and a new, empty MDB will be created
Any comments or suggestions welcomed
Brian
I have two or three prescriptions, and they all run out on different dates, and need renewing at different times. This program is to help me keep track of when to re-order
I've been working on this program on and off for quite a few days, and with Bill H's valuable help have overcome some of the trickier SQL problems
Full source code included, with exe. It is a Project. To start your own database, rather than the test data, just delete 'Tablets.mdb' from the \data folder, and run the program again, and a new, empty MDB will be created
Any comments or suggestions welcomed
Brian
56
General Questions / Re: Sending SMS messages
Last post by Egil - January 02, 2024, 07:24:24 AMHi Brian,
And Happy New Year!
If your PC and smart phone both are connected to the same router it should be possible. But you'll need to dig rather deep into the GSM communication protocols to make it work.
My internet provider, which also is my GSM provider, had such a service at the very birth of the GSM networks here in Norway. But we had to go via a website to send the messages. It was almost not used by their customers, so that service does not longer exist.
Personally I use an easier method: E-Mail! But had a hard time in the start to learn how to filter out all the "Special offers for You" that from time to time fill my inbox. And later I discovered that these filters were very different with the various network providers, so there is no easy fix.
This is not the answer you needed, but if you manage to get a copy of the GSM/SMS protocols, please tell us where you found it.
Egil
PS
While I was on the phone in the middle of writing this message Clint described the method that my provider dropped several years ago. But a call to your network provider would be wise to do!
And Happy New Year!
If your PC and smart phone both are connected to the same router it should be possible. But you'll need to dig rather deep into the GSM communication protocols to make it work.
My internet provider, which also is my GSM provider, had such a service at the very birth of the GSM networks here in Norway. But we had to go via a website to send the messages. It was almost not used by their customers, so that service does not longer exist.
Personally I use an easier method: E-Mail! But had a hard time in the start to learn how to filter out all the "Special offers for You" that from time to time fill my inbox. And later I discovered that these filters were very different with the various network providers, so there is no easy fix.
This is not the answer you needed, but if you manage to get a copy of the GSM/SMS protocols, please tell us where you found it.
Egil
PS
While I was on the phone in the middle of writing this message Clint described the method that my provider dropped several years ago. But a call to your network provider would be wise to do!
57
General Questions / Re: Sending SMS messages
Last post by Brian - January 02, 2024, 07:18:40 AMHi, Clint,
Hope you are well. Bit of a faff if you have a number, but don't know which service to send to. Might just be content with an email, but it would have been nice to go a bit more modern. . . .
Brian
Hope you are well. Bit of a faff if you have a number, but don't know which service to send to. Might just be content with an email, but it would have been nice to go a bit more modern. . . .
Brian
58
General Questions / Re: Sending SMS messages
Last post by ckoehn - January 02, 2024, 07:13:59 AMYou can do it, but at least here in the United States you have to use it like an email message. You need to not only know the number but the carrier.
For example if you have Verizon:
10digit_phone_number@vtext.com
AT&T:
10digit_phone_number@txt.att.net
You can find the carrier extentions on the internet.
It has become more difficult in recent years because they call sending it from a program "third party access" or something like that, which apparently means it isn't as secure.
I use it in one of my programs as an alert to my commercial fish farmers when there is an error on their monitoring equipment.
Later,
Clint
For example if you have Verizon:
10digit_phone_number@vtext.com
AT&T:
10digit_phone_number@txt.att.net
You can find the carrier extentions on the internet.
It has become more difficult in recent years because they call sending it from a program "third party access" or something like that, which apparently means it isn't as secure.
I use it in one of my programs as an alert to my commercial fish farmers when there is an error on their monitoring equipment.
Later,
Clint
59
General Questions / Sending SMS messages
Last post by Brian - January 02, 2024, 04:29:44 AMHi,
If you have a known mobile number stored in a database in an IWB program, is it possible to send an SMS message direct from your program, with your computer logged onto your router, using WiFi?
Brian
If you have a known mobile number stored in a database in an IWB program, is it possible to send an SMS message direct from your program, with your computer logged onto your router, using WiFi?
Brian
60
General Questions / Re: Time Picker
Last post by Brian - December 26, 2023, 07:45:19 AMLarry,
Thanks for the suggestions, but I didn't get anywhere with them. Never mind, I was happy just getting the font to match my other edit control-defined fonts
Brian
Thanks for the suggestions, but I didn't get anywhere with them. Never mind, I was happy just getting the font to match my other edit control-defined fonts
Brian