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

Auto Todays Date & More

P: 38
Hi all before I begin to tell you my problems just a big thanks to Mary McCarthy who helped me lots. Thank You Mary!!!

Right todays problems are
Getting the date in my form automatically. (read below)
I need to have a butt thatprint an invoice. (see below)
When running a Report the Company name is duplicated on every line of the order details.
I need to have my /cmpanyname/address/Tel/Order Number/ Item description by line/Qty/Line total.then Sum total at the botton of screen

I need to get an invoice to printout after the order has been taken.

With the date problem I have edited the DATE field in my form & in table field. When I put = Date()
I get nothing
some settings read

Input Mask 00/00/0000;;_
Default value is = Date()
Enabled & Not Locked
/
I have put =Date() in the criteria field.

My head is bent with this one.
Thanks
Mark
Mar 15 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
With the date problem I have edited the DATE field in my form & in table field. When I put = Date()
I get nothing
some settings read

Input Mask 00/00/0000;;_
Default value is = Date()
Enabled & Not Locked
/
I have put =Date() in the criteria field.
For some strange reason the Date() function won't work in 2003. Don't know what the bug is but someone else might. Change it to the Now() function and it should work fine.

When running a Report the Company name is duplicated on every line of the order details.
Create a Grouping level for the report. Group on Company Name.

Mary
Mar 17 '07 #2

Post your reply

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