By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Insert value for the whole field

P: 25
I hoping to make things easier for my cilents. Below i have the fields for a table

Table one
Month
Customer
Transaction Amt

I wish to prompt the user for the month in which the records belong to.
Eg. In the Month of September i enter 100 records.

The Month field will automatically fill with "September" so that the user need not type september for a 100 times.

Should i use a INSERT sql? how should i go abt doing it?

Please and Thank you ppl!
Sep 5 '07 #1
Share this Question
Share on Google+
3 Replies


Scott Price
Expert 100+
P: 1,384
I hoping to make things easier for my cilents. Below i have the fields for a table

Table one
Month
Customer
Transaction Amt

I wish to prompt the user for the month in which the records belong to.
Eg. In the Month of September i enter 100 records.

The Month field will automatically fill with "September" so that the user need not type september for a 100 times.

Should i use a INSERT sql? how should i go abt doing it?

Please and Thank you ppl!

Try setting the default value of the Month field in your table to this:
Expand|Select|Wrap|Line Numbers
  1. =Format(Date(),"mmmm")
Any new records will automatically have the current month of the current year entered.

Regards,
Scott
Sep 5 '07 #2

P: 25
Try setting the default value of the Month field in your table to this:
Expand|Select|Wrap|Line Numbers
  1. =Format(Date(),"mmmm")
Any new records will automatically have the current month of the current year entered.

Regards,
Scott
Hey Scott,

The format works perfectly fine. However, the thing is the records are normally entered at the end of the month, some times even entered in the start of following month.Thus i require to prompt the cilent for the month of record belongs to.

Please and Thank you if you can help me..
Sep 6 '07 #3

Scott Price
Expert 100+
P: 1,384
Oh for *reeeeasonable* clients that do things the *right* way and enter their records on time... :-)

I would suggest then that you populate the Month field by using a combo box with RowSource of either a lookup table (tblMonth, MonthID, MonthName), or a value list that is set to the 12 months of the year. Make the Month field mandatory at the table level, and you're set, since there is no way that they can then save the record without entering a month value. (and BTW, since Month is a keyword, you should likely rename your field to something else to avoid confusing the poor computer down the road somewhere... MonthName, PayMonth, StatementMonth, etc)

Regards,
Scott
Sep 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.