You are not logged in. Please login or register.
My Visual Database → General → message for birthday
Hi
Is there an script to show a Birthday Message in a specific date?
I recorded information for 100 employees of a company as well as their spouses and children.
is it possible that a message pops up on his/her birthday, showing that person's name and when I click on his/her name, it refers me to that persons page.
thank you
Hello, I saw a topic on the forum that did not get an answer.
This subject concerns birthday dates and may be interesting to apply it to other subjects, in particular to stocks or other archives.
Has an answer been posted?
-------------------------------------------------- ----------
Here is the message in question:
'message for birthday'
Hi
Is there a script to show a Birthday Message in a specific date?
I recorded information for 100 employees of a company as well as their spouses and children.
is it possible that a message pops up on his/her birthday, showing that person's name and when I click on his/her name, it refers me to that persons page.
thank you
Hello,
Here's an idea. Hope it can be a start to what you want to do with it.
CheckBday.zip 549.47 kb, 89 downloads since 2022-11-27
Thanks Brian, this example can be adapted for several programs.
Hi all,
Slight modification of Brian's solution. By the way, I didn’t find solutions on the forum with launching with parameters, maybe I don’t see it well.
You can try, provided that there are not very many forms in the program. The more forms, the longer the launch.
If run at computer startup with the "bday.exe /min" parameters, it will display only information about the birthday, if not, then nothing. Message timeout 3 sec.
In normal startup mode, fully working.
CheckBday mod1.zip 336.31 kb, 40 downloads since 2022-11-28
Hi Destiny, Brian, Sparrow,
Hope you're all well.
There are lots of ways to achieve this sort of thing - here's a very simplified option (based on Brian and Sparrow's examples) that doesn't require a script.
Regards,
Derek.
CheckBday mod2.zip 336.79 kb, 74 downloads since 2022-11-28
Thanks to Brian, Sparrow and Derek for the examples they provided. That's great.
Thanks
Hi guys
thanks a lot for different approaches.
is it possible that an alert in shown a day or a week before someones birthday?
for example when you click on a bottom, an alert says that tomorrow is Tom's Birthday?
or a bottom show an alert that during the next month there will be 4 birthdays?
thanks
There are lots of different ways you can do something like this - at it's simplest, you could just sort a 'next birthday due' column.
Attached is an option that colour codes the table grid depending on whether a birthday is due in the next 5 days (highlighted in red) or in the next 14 days (highlighted in yellow).
Derek.
birthdaybash.zip 371.93 kb, 61 downloads since 2023-01-07
Hi everyone
Thank you all for your help
I created a project with many workers and their relatives.
and I have attached the sample project.
is it possible that when you click on the bottom "btShowBday" in the form "frmMain" all the workers and their relatives are shown on the form "frmBDayList" and an alert in shown for the birthday?
because in my sample When I click on that bottom only the worker is shown and his wife and children are not shown on the tablegrid.
please don not change the tables and forms
CheckBday mod3.zip 336.97 kb, 53 downloads since 2023-01-08
Form frmBDayList - btSearch (SQL query)
SELECT name,
strftime('%m/%d/%Y',birthdate) as Birthdate,
date('now') - birthdate + (case when strftime('%m-%d', 'now') < strftime('%m-%d', birthdate) then -1 else 0 end) as AGE
FROM emp
WHERE strftime('%d-%m', birthdate) = strftime('%d-%m', 'now', 'localtime')
UNION
SELECT fistname || ' ' || lastname,
strftime('%m/%d/%Y',birthdate) as Birthdate,
date('now') - birthdate + (case when strftime('%m-%d', 'now') < strftime('%m-%d', birthdate) then -1 else 0 end) as AGE
FROM wife
WHERE strftime('%d-%m', birthdate) = strftime('%d-%m', 'now', 'localtime')
UNION
SELECT name || ' ' || lastn,
strftime('%m/%d/%Y',birthday) as Birthdate,
date('now') - birthday + (case when strftime('%m-%d', 'now') < strftime('%m-%d', birthday) then -1 else 0 end) as AGE
FROM children
WHERE strftime('%d-%m', birthday) = strftime('%d-%m', 'now', 'localtime')
ORDER BY AGE DESC Thank you sparrow for your help.
When I used this script in the sample project that I have attached, it works fine but when I insert it in my own project it shows the attached error message.
what am I doing wrong?
Untitled.jpg 29.04 kb, 7 downloads since 2023-01-08
Check the ORDER BY line
thanks a lot
I found the problem and solved it with your help.
It works great
My Visual Database → General → message for birthday
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi