Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sm0wb04rd3r
Starting Member
15 Posts |
 Posted - 2004-01-26 : 02:45:29
|
| In the main manu of a database under the current date I would like the access to insert the current saying for that day. (i made a database of 365 sayings – so I have a saying for each day). How could I make access to insert a saying for each day????I am a lamer newbee (unfortunatelly) so I can’t code.Please help me if you can in this matter!Thanx a lot in advance!! |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-01-26 : 11:19:13
|
| Insert it where?Do you mean you want a saying to show up on a Form?Brett8-) |
 |
|
|
sm0wb04rd3r
Starting Member
15 Posts |
Posted - 2004-01-28 : 05:36:48
|
| Yes! I want each saying to show up on each day in the bottom part of the startup form! Is it possible? How?Thanx!! |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2004-01-28 : 06:04:45
|
| Drop a textbox on the form. Its (textbox's) property"DataSource" set to=dlookup("saying","sayings","n=" & datepart("Y",date()))I assume here that you have table named Sayings,in which there are 2 fields: n and Sayingfield n is integer from 1 to 365;field Saying is for storing saying texts.Replace in my sample these names with those you have in your table. |
|
|
|
|
|
|
Inserting different sayings problem! Please help!