51
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
52
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
53
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
54
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
55
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!
56
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
57
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
58
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
59
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
60
General Questions / Re: Time Picker
Last post by LarryMc - December 25, 2023, 06:35:38 AMI think you are going to have to send the control the DTM_SETMCCOLOR message with wparam set to MCSC_MONTHBK and lparam set to the color of the background you want.
And then send the control the DTM_SETMCCOLOR message with wparam set to MCSC_TEXT and lparam set to the color of the text you want.
That's my best guess.
And then send the control the DTM_SETMCCOLOR message with wparam set to MCSC_TEXT and lparam set to the color of the text you want.
That's my best guess.