密码根据月份而变化 [英] Password that changes according to month
问题描述
我想拥有一个每个月都会更改的密码。如果我有一张桌子
,其中一个字段为''Month',月份数和另一个字段
称为''密码''有12条记录。什么是查看当前日期的最佳方式,然后,如果是2月,那么选择与月份字段中的数字2相对的
密码。
dixie
I want to have a password that will change for each month. If I had a table
with a field of ''Month'' with the number of the month and another field
called ''Password'' that had twelve records. What would be the best way of
looking at the current date and then, if it was say February, picking the
password that was against the number 2 in the Month field.
dixie
推荐答案
dixie写道:
我想拥有密码将在每个月更改。如果我有一个
表,其中一个字段为''Month'',其中包含月份数,另一个
字段称为''Password',其中包含12个记录。查看当前日期的最佳
方式是什么,然后,如果是2月,则选择
密码与月份字段中的数字2相对。
> dixie
I want to have a password that will change for each month. If I had a table with a field of ''Month'' with the number of the month and another field called ''Password'' that had twelve records. What would be the best way of looking at the current date and then, if it was say February, picking the password that was against the number 2 in the Month field.
dixie
tblP
MonthID P
1 MLKJr
2 BMyValentine
3 bean239
4个小号
5 mmmysdy
6 dddysdy
7 ahatfoj
8 nohldy
9 tmstrs
10 gstsngblns
11 trkygblr
12 ntvty
SELECT P FROM tblP IN''G:\ HiddenDirectory \P.mdb''WHERERE MonthID =
Month(Now());
这可能不是最好的方法,但应该有效。不要使用Month作为
字段名称,因为它是一个保留字。 MonthID的类型为Long。
James A. Fortune
tblP
MonthID P
1 MLKJr
2 BMyValentine
3 bean239
4 prlfls
5 mmmysdy
6 dddysdy
7 ahatfoj
8 nohldy
9 tmstrs
10 gstsngblns
11 trkygblr
12 ntvty
SELECT P FROM tblP IN ''G:\HiddenDirectory\P.mdb'' WHERE MonthID =
Month(Now());
This may not be the best way but it should work. Don''t use Month for a
field name since it''s a reserved word. MonthID is of type Long.
James A. Fortune
我看到你在隐藏文件夹中使用不同的数据库来放置密码
in。如果一张隐藏的桌子说USysPW怎么样?
dixie
< ji * *******@compumarc.com>在消息中写道
news:11 ********************** @ z14g2000cwz.googlegr oups.com ...
I see you use a different database in a hidden folder to put the passwords
in. What about just a hidden table say USysPW?
dixie
<ji********@compumarc.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
dixie写道:
我希望有一个密码,每个月都会有变化。如果我有
I want to have a password that will change for each month. If I had
一个表
,其中一个字段为''Month'',其中包含月份数和另一个
with a field of ''Month'' with the number of the month and another
字段
称为密码,有12条记录。什么是最好的
called ''Password'' that had twelve records. What would be the best
方式
查看当前日期,然后,如果是2月,则选择
looking at the current date and then, if it was say February, picking
密码与月份字段中的数字2相对。
dixie
password that was against the number 2 in the Month field.
dixie
tblP
MonthID P
1 MLKJr
2 BMyValentine
3 bean239
4 prlfls
5 mmmysdy
6 dddysdy
7 ahatfoj
8 nohldy
9 tmstrs
10 gstsngblns
11 trkygblr
12 ntvty
SELECT P FROM tblP IN''G:\ HiddenDirectory \P.mdb''WHERERE MonthID =
月(现在());
这可能不是最好的方法,但应该有效。不要将Month用作
字段名称,因为它是一个保留字。 MonthID的类型为Long。
James A. Fortune
tblP
MonthID P
1 MLKJr
2 BMyValentine
3 bean239
4 prlfls
5 mmmysdy
6 dddysdy
7 ahatfoj
8 nohldy
9 tmstrs
10 gstsngblns
11 trkygblr
12 ntvty
SELECT P FROM tblP IN ''G:\HiddenDirectory\P.mdb'' WHERE MonthID =
Month(Now());
This may not be the best way but it should work. Don''t use Month for a
field name since it''s a reserved word. MonthID is of type Long.
James A. Fortune
我想我以前的帖子只是一个修辞问题,因为两者都可行。
感谢您的帮助詹姆斯。这正是我所需要的。
dixie
" dixie" <二*** @ dogmail.com>在消息中写道
news:41 ******** @ duster.adelaide.on.net ...
I guess my previous post was just a rhetorical question, as both would work.
Thanks for your help james. It is just what I needed.
dixie
"dixie" <di***@dogmail.com> wrote in message
news:41********@duster.adelaide.on.net...
我看到你在一个不同的数据库中使用隐藏文件夹放入密码
。怎么只是隐藏的桌子说USysPW?
dixie
< ji ******** @ compumarc.com>在消息中写道
新闻:11 ********************** @ z14g2000cwz.googlegr oups.com ...
I see you use a different database in a hidden folder to put the passwords
in. What about just a hidden table say USysPW?
dixie
<ji********@compumarc.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
dixie写道:
我希望有一个密码,每个月都会有变化。如果我有
I want to have a password that will change for each month. If I had
一个表
,其中一个字段为''Month'',其中包含月份数和另一个
with a field of ''Month'' with the number of the month and another
字段
称为密码,有12条记录。什么是最好的
called ''Password'' that had twelve records. What would be the best
方式
查看当前日期,然后,如果是2月,则选择
looking at the current date and then, if it was say February, picking
密码与月份字段中的数字2相对。
dixie
password that was against the number 2 in the Month field.
dixie
tblP
MonthID P
1 MLKJr
2 BMyValentine
3 bean239
4 prlfls
5 mmmysdy
6 dddysdy
7 ahatfoj
8 nohldy
9 tmstrs
10 gstsngblns
11 trkygblr
12 ntvty
SELECT P FROM tblP IN''G:\ HiddenDirectory \P.mdb''WHERERE MonthID =
月(现在());
这可能不是最好的方法,但应该有效。不要将Month用作
字段名称,因为它是一个保留字。 MonthID的类型为Long。
James A. Fortune
tblP
MonthID P
1 MLKJr
2 BMyValentine
3 bean239
4 prlfls
5 mmmysdy
6 dddysdy
7 ahatfoj
8 nohldy
9 tmstrs
10 gstsngblns
11 trkygblr
12 ntvty
SELECT P FROM tblP IN ''G:\HiddenDirectory\P.mdb'' WHERE MonthID =
Month(Now());
This may not be the best way but it should work. Don''t use Month for a
field name since it''s a reserved word. MonthID is of type Long.
James A. Fortune
这篇关于密码根据月份而变化的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!