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, 284 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, 195 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, 235 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, 218 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, 204 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, 85 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
Hi Guys
Please help me with Edit Button
Why doesn't the Edit button in the form "frmBDayList" work?
it Shows an error: "No Record is Selected for editing"
How Can It be fixed ?
CheckBday mod4.zip 337.04 kb, 131 downloads since 2023-04-09
Hi,
In your sqlquery code, you need to add the record id (see attached)
Derek.
CheckBday mod4 fixed.zip 339.84 kb, 153 downloads since 2023-04-09
Hi all,
You initially chose to store birthday data in three different tables, at least in this example.
These tables do not have any links with each other.
'Emp' works, while the wives and children go out on their own and in different places.
The final table in the form you point to displays data from THREE TABLES using a query
that combines the data for output using a UNION.
Unfortunately, in this case, it is problematic to display information about the ID and belonging
to the table.
Therefore, an error message is displayed that indicates that it is impossible to determine a unique identifier.
Solution:
Wrong - Sculpt various patches, where something is constantly wrong and not molded.
Correct - Recreate the database, taking into account the relationship between the employee and relatives)))) (Wives, children, etc.).
There should be strict relations in the family and not whoever wants where)))). And the program will get easier.
Derek's solution is just a temporary fix until the ID matches or is missing.
Thank you Derek for your solution but as Sparrow mentioned it is only temporary and when I enter many records the results are not correct.
So in order to get the result for the entry's wife and children in a company, I entered a button "wife" in the last form "frmBDayList"
I put this button because I need the project to show whose wife is born on a specific day and when you push this button, the name of the wife and also the name of the personnel should be shown in one line on the tablegrid
In the attached project only the name of the wife is shown and not the name of the personnel.
thank you for your help
CheckBday mod5.zip 336.61 kb, 148 downloads since 2023-04-10
Slightly corrected.
CheckBday mod6.zip 328.17 kb, 162 downloads since 2023-04-10
Hi guys
I'd like to add another line of data to this project when it shows a person's birthday.
What I need to do is that in the form "frmBDayList" the department of that person should also be shown.
like this:
First name - Last name - age - department
CheckBday mod7.zip 337.21 kb, 132 downloads since 2023-06-06
Please help guys. It's very urgent to me.
Im stuck with this issue that I cant handle.
I have attached the project and I need to know whether it is possible using scripts or other aproaches.
Thanks alot
SELECT name,
plastname,
strftime('%Y', 'now', 'localtime') - strftime('%Y', birthdate) as AGE,
department.section,
emp.id as id
FROM emp Inner Join department ON emp.id_department=department.id
WHERE strftime('%d-%m', birthdate) = strftime('%d-%m', 'now', 'localtime')
UNION
SELECT fistname,
lastname,
strftime('%Y', 'now', 'localtime') - strftime('%Y', birthdate) as AGE,
'Wife of ' || (SELECT name || ' ' || plastname FROM emp e WHERE e.id=wife.id_emp),
id_emp as id
FROM wife
WHERE strftime('%d-%m', birthdate) = strftime('%d-%m', 'now', 'localtime')P.S. add fix
My Visual Database → General → message for birthday
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi